JSON ⇄ CSV Converter
Convert JSON arrays and CSV tables locally.
Input & settings
Result
How to use it
- 1Choose a direction
JSON array to CSV, or CSV to a JSON array.
- 2Paste your data
JSON should be an array of objects; CSV needs a header row.
- 3Copy or download
Take the result as text, or save it as a file for Excel or your database.
Good to know
Headers must be unique
Every CSV column needs a non-empty, distinct name so the JSON keys are unambiguous.
CSV values stay text
Numbers and booleans from a CSV become strings, because CSV carries no type information.
Nested values are serialised
An object or array inside a row is written as JSON text, and missing fields become empty cells.
Formula prefixes are escaped
Values starting with =, +, - or @ are escaped on export, so spreadsheets do not run them as formulas.
Common uses
- Loading an API response into a spreadsheet
- Turning an exported report into JSON for a script
- Checking a data file before import
- Sharing a small dataset with someone who only has Excel
- Building fixtures for tests
Questions
What shape does my JSON need?
An array of objects, where each object is one row. The keys become column headers.
Why are my numbers quoted after CSV to JSON?
CSV has no types, so every value arrives as text. Convert the fields you need in your own code.
What happens to nested objects?
They are written into the cell as JSON text, so no data is lost even though CSV is flat.
Why are some values escaped in the CSV?
A cell beginning with =, +, - or @ can be treated as a formula by spreadsheet apps. Escaping it keeps the file safe to open.
How it works
CSV needs unique, non-empty column headers. CSV values remain strings. Nested JSON values are serialized as JSON text; missing fields become empty cells. Spreadsheet formula prefixes are escaped on CSV export for safer opening.