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.
Tool activity
Simple tools for everyday work.
Get expert help from ALCO.
Need help with a website or a workflow beyond this tool? Explore ALCO’s website development services for your business.