CSV to JSON
Parse messy CSV into clean JSON.
CSV to JSON parses comma, semicolon or tab separated data — including quoted fields containing separators and line breaks — and outputs an array of objects or of arrays. It detects the delimiter automatically, can type-convert numbers and booleans, and handles files with a byte order mark. Parsing happens locally; no file is uploaded.
Loading CSV to JSON…
Runs entirely on your device. No file or text you enter here is uploaded. How to verify it.
How to use CSV to JSON
- Paste CSV, or open a .csv file.
- Confirm the detected delimiter and header row.
- Copy or download the JSON.
Questions about CSV to JSON
Does it handle quoted fields with commas inside?
Yes, following RFC 4180: a field wrapped in double quotes may contain commas, line breaks and doubled quotes. Splitting on commas — the naive approach — corrupts any real-world CSV containing an address.
Are numbers converted automatically?
Optionally. Type conversion is off by default because it damages data: leading-zero identifiers become integers, and long numeric IDs lose precision past 2⁵³. Turn it on knowingly.
What about inconsistent row lengths?
Rows shorter or longer than the header are reported with their line numbers rather than silently padded, so you can find the broken line in the source.
Can it read an .xlsx file directly?
No. It reads CSV, TSV and other delimited text. Export the sheet as CSV first — one menu item in Excel, Numbers or Google Sheets — which also settles what should happen to multiple sheets and formulas.
Does it cope with very large files?
Both the input text and the JSON it produces have to fit in browser memory. Files up to tens of megabytes are comfortable; beyond that the tab slows noticeably, and a command-line parser is the better tool.
Is CSV to JSON really free, with no limits?
Yes. There is no account, no daily cap, no file-size tier and no watermark, because there is no server cost to recover. The site is funded by clearly disclosed partner recommendations on the Partners page, never by metering the tools.
Are my files or text uploaded when I use CSV to JSON?
No. Everything is processed by JavaScript running in your browser, on your device. You can verify it: open your browser's developer tools, switch to the Network tab, and use the tool. You will see no request carrying your data — because there is nowhere for it to go.