CSV to JSON and JSON to CSV Converter
Paste CSV or open a file to get JSON, or paste a JSON array to get CSV for a spreadsheet. Delimiters are detected automatically, numbers are converted only when that is safe, and nothing leaves your device.
Processed in your browser. Nothing you paste is sent to a server.
How to use this tool
- Choose the direction.
- Paste data or open a file. For CSV, check the delimiter and header options.
- Copy or download the result as .json or .csv.
How it works
CSV is read with an RFC 4180 parser: quoted fields, doubled quotes, and line breaks inside quotes are handled. With a header row, each row becomes an object keyed by the header; without one, an array. "Convert numbers" turns cells such as 12 or -3.5 into numbers but keeps values with leading zeros (007), very long digits, or spaces as text, so codes and phone numbers are not damaged.
JSON to CSV takes an array of objects (columns are the union of all keys, in order of appearance) or an array of arrays. Nested objects are written as JSON text in the cell. With formula protection on, cells starting with = + - or @ are prefixed with an apostrophe so spreadsheets do not run them.
Limitations
- Very large inputs (tens of megabytes) are slow to show; download the result instead of scrolling the preview.
- Dates are kept as text; they are not converted to a date type.
Privacy and data
Everything happens in your browser. What you paste or open is never sent to our server, logged or stored, and the page works offline once loaded.
Frequently asked questions
Why are some numbers kept as text?
To avoid damage: a postcode like 01234 or a 20-digit ID would change if converted to a number.
What is formula protection?
Cells starting with =, +, - or @ can be run as formulas when a CSV is opened in a spreadsheet. The apostrophe prefix stops that; turn it off if you need the raw values.