Developer tool / 07
JSON to CSV Converter
Convert an array of JSON objects into comma- or tab-separated rows.
JSON to CSV Converter: TOEA builds a union of object keys as headers, preserves row order, and quotes cells containing separators or line breaks. Runs 100% locally in your browser with zero server file uploads.
- Category
- Developer tools
- Runs
- In your browser
- Cost
- Free · no sign-up
- Availability
- Ready to use
Runs entirely in your browser
Opening the CSV in Excel
Excel opens CSV files with its own guesses: long numbers turn into scientific notation, leading zeros disappear, and accented letters can come out garbled. Importing through Data › From Text/CSV, choosing UTF-8 and setting the affected columns to Text, keeps them intact. Google Sheets and LibreOffice handle UTF-8 by default.
Nested data and formula injection
CSV is flat. Nested objects and arrays are written into one cell as JSON text, which keeps the data but not the shape; for a clean table, flatten the records first so each field is a single value.
If the data came from users, watch for cells that begin with =, +, -, or @. Spreadsheet programs can treat them as formulas when the file is opened. Prefix such cells with an apostrophe, or have the program that consumes the file import them as text.
How to use it
- Paste a JSON array of objects.
- Choose comma or tab output.
- Convert and download the table.
Privacy & limitations
Conversion happens locally. Nested objects and arrays are preserved as JSON text inside a cell.
Related tools
Frequently asked questions
What JSON shape is required?
Use an array whose items are objects, such as a list of records.
How are missing keys handled?
Their cells are left empty while all discovered headers remain present.
Free tool · runs in your browser · no account required