JSON to CSV Converter

How the JSON becomes a table

Each record becomes one row and each field becomes a column:

• Rows come from the top-level array. If the JSON is an object that contains arrays, such as {"data": {"items": [...]}}, the tool picks the array with the most objects in it. You can choose another array, or the whole object as a single row.
• Nested objects are flattened with dot notation: {"address": {"city": "Pune"}} becomes a column called address.city.
• Lists inside a record, such as "tags": ["new", "priority"], are joined into one cell as new; priority, or kept as JSON text (["new","priority"]) if you need to read them back later.
• The header is the union of the keys of all records, in the order they first appear. A record without a field gets an empty cell in that column.
• Values: text is written as it is, true and false stay as words, null becomes an empty cell, and numbers are copied exactly as written in the JSON, so long IDs are not rounded.
• An array of arrays is written row by row, without a header.

Quoting and line endings

The CSV follows RFC 4180. A field is wrapped in double quotes when it contains the delimiter, a double quote, a line break, or a space at the start or end, and quotes inside a field are doubled ("Said ""hello"""). Lines end with CRLF by default, as the standard says; switch that off for LF.

Opening the file in Excel

Excel reads CSV files using your computer's regional settings. If everything lands in one column, your Excel probably expects semicolons, so choose the semicolon delimiter and download again. Keep Add a BOM for Excel switched on so that Excel recognises the file as UTF-8 and shows the rupee sign, Hindi text and accented names correctly. Switch it off if a script or database will read the file, because some programs treat the BOM as part of the first column name.

Protection against formula injection

A cell that starts with =, +, - or @ can be run as a formula when the CSV is opened in a spreadsheet app such as Excel or Google Sheets. A value like =HYPERLINK(...) hidden in exported data can then create misleading links or pull in data from the internet when someone opens the file. With protection on, which is the default, the tool adds an apostrophe in front of such cells, and of cells that start with a tab or carriage return, so spreadsheets show them as plain text. Plain numbers such as -42 are left alone. The apostrophe stays visible in the cell, so switch protection off if the CSV is only for a program that does not run formulas.

Privacy

The conversion runs in your browser. Your JSON is not uploaded or stored.