CSV to JSON converter
Convert CSV to JSON and JSON back to CSV, with quoted fields and ragged rows handled properly.
Open this tool
Checking access…
About this tool
Turn a CSV export into JSON, or an array of JSON objects back into CSV, without opening a spreadsheet. Commas inside quoted fields, escaped quotes, semicolon and tab delimiters, and rows with missing columns are all handled by a real parser rather than a split on commas, and anything that looks wrong is reported row by row instead of silently dropped. The conversion runs in your browser, so an export full of customer records or invoice data never leaves your machine.
Using this tool
Why did my postcode or product code lose its leading zero?
Because “Convert numbers and booleans” turned 01234 into the number 1234. Codes, postcodes and phone numbers are text that happens to be made of digits, so untick that option and every value comes through as a string.
What happens to nested JSON when I convert to CSV?
A nested object or array is written into the cell as JSON text, and the tool tells you how many values that affected. CSV is a flat format with no way to express nesting, so the alternative would be to lose the data.
My CSV uses semicolons. Will it work?
Yes. Detection is automatic and usually right, and you can force comma, semicolon, tab or pipe if a file confuses it — which happens with European exports where the decimal separator is also a comma.
Why is there a 1 MB limit?
Both the input text and the parsed result sit in your browser’s memory at once, and a larger file will make the tab stall, especially on a phone. Above a megabyte a spreadsheet application or a command-line tool is the right instrument.
More files tools
Create a ZIP archive
Pack several files into one ZIP you can email or upload.
Open Create a ZIP archiveExtract a ZIP archive
Look inside a ZIP, then save just the files you actually want.
Open Extract a ZIP archiveFile checksum calculator
Compute SHA-256, SHA-1, SHA-384 and SHA-512 checksums and compare them to a published one.
Open File checksum calculatorNeed more than a quick tool?
These are free and always will be. If one of them is solving a problem you keep having, the underlying issue is usually worth a conversation.