CSV and JSON Converter
Convert either way, map columns, and choose how nested values are handled.
The direction follows what you paste: a table becomes JSON, a JSON array becomes a table.
Your result
Paste a table or a JSON array to convert it.
How to use it
- Paste CSV or JSON, or upload a file.
- Choose the JSON options if you like.
- Copy or download the result.
Examples
- Table to JSONid,name then 1,Ada [{"id":"1","name":"Ada"}]
- Value typesThe numbers and true/false option {"id":1,"active":true}
- Nested JSON{"tags":["a","b"]} The cell holds ["a","b"]
Tool details and privacy
Turn a table into a JSON array, or JSON into a table. The direction follows what you paste.
APIs want JSON; Excel wants a table.
Options
- Indented JSON, and plain numbers and true/false without quotes.
- A number with a leading zero (such as a phone) stays text.
Limits
- JSON must be an array of objects or one object.
- Nested objects are written into the cell as JSON text.
Privacy
What you type or open stays in your browser. Nothing is uploaded or saved on the server.
Questions
How is the direction chosen?
Text starting with [ or { is read as JSON.
Do numbers stay text?
By default yes; tick the option to write them as numbers.
Does it read XLSX?
Yes, for CSV to JSON.
Is anything uploaded?
No.