JSON to CSV converter
Turn a JSON array into a CSV table for Excel or Sheets.
About the JSON to CSV tool
This JSON to CSV converter turns a JSON array into a CSV table that opens in Excel, Google Sheets or LibreOffice. Each object becomes a row, every key found in any object becomes a column, and nested objects are flattened into dot columns such as user.name or tags.0. Choose a comma, semicolon, tab or pipe delimiter and download data.csv; the Excel-friendly option adds a UTF-8 marker so Hindi names and the ₹ sign display correctly.
At a glance
- Input
- JSON array, or an object holding one array; .json files up to 20 MB
- Output
- data.csv (data.tsv with tabs), optional UTF-8 marker for Excel
- Delimiters
- Comma, semicolon, tab or pipe
- Nested data
- Flattened to dot columns such as user.name and tags.0
- Price
- Free, no sign-up
- Works in
- Your browser, on phone or computer. Works offline after the first visit.
- Privacy
- What you type never leaves your device.
How to convert JSON to CSV
- Paste your JSON array, or press "Open file" to load a .json file.
- Pick the delimiter and whether to include a header row.
- Copy the CSV or press Download to save data.csv.
Private
Your text stays in your browser and is never sent to a server.
Instant
Results update as you type, with nothing to install.
Free
No sign-up, no limits and no ads inside your writing space.
JSON to CSV: frequently asked questions
How are nested JSON objects converted to CSV columns?
They are flattened with dot notation. For example {"user":{"name":"Asha"},"tags":["a","b"]} becomes the columns user.name, tags.0 and tags.1, so no value is lost.
What if my objects have different keys?
Every key that appears in any object becomes a column, in the order it is first seen. Rows that do not have a key get an empty cell.
Why does Excel show Hindi or ₹ as strange characters?
Older Excel versions guess the wrong encoding for CSV files. Tick "Excel-friendly download" to add a UTF-8 byte order mark, and Excel will show Hindi, ₹ and emoji correctly.
My JSON is an object like {"data":[…]}. Does that work?
Yes. If the top-level object has a single key holding an array, that array is used as the rows. Any other single object becomes one row.
Is my text sent anywhere?
No. Everything runs in your browser and your text never leaves your device. Nothing is stored on any server.



