Converters
JSON to CSV Converter
Convert JSON to CSV and CSV back to JSON.
Free foreverRuns in your browserNo sign-up
CSV
About the JSON to CSV Converter
Convert an array of JSON objects into CSV, or a CSV file back into JSON, in one tool.
Column headers come from the object keys, and quoted fields, commas and line breaks are handled correctly.
Handy for spreadsheets, data imports and moving data between apps.
Key features
- JSON to CSV and CSV to JSON
- Handles quoted fields and commas
- Open a file or paste your data
- Copy the result instantly
How to use
- 1Choose the direction you want to convert.
- 2Paste your data or open a file.
- 3Copy the converted result.
Examples
JSON to CSV
Input:
[{"name":"Ada","age":36}]Output:
name,age
Ada,36Object keys become the header row and each object becomes a data row.
CSV to JSON
Input:
name,age
Ada,36Output:
[{ "name": "Ada", "age": "36" }]The first row is used as keys for each JSON object.
Frequently asked questions
- What JSON shape works best?
- An array of flat objects converts most cleanly, with each object becoming a row and each key becoming a column.
- How are nested objects handled?
- Nested objects and arrays are written as JSON text inside the cell so no data is lost.
- Is my data uploaded?
- No. The conversion runs entirely in your browser.