📑 JSON to CSV Converter

Free JSON to CSV converter

Convert JSON data into a CSV file that opens in Excel, Google Sheets, Numbers and most database tools. Paste a JSON array of objects, or upload a .json file, and click Convert. The tool collects the column names from all of your objects, flattens nested data into extra columns and gives you CSV text to copy or download. Everything runs in your browser, so your data is never uploaded.

How to convert JSON to CSV

1. Paste your JSON or upload a file. An array of objects works best.
2. Choose a delimiter: comma, semicolon or tab.
3. Pick your options: header row, flattening, formula protection and Excel-friendly download.
4. Click Convert to CSV.
5. Copy the result or enter a file name and click Download .csv.

What the options do

• Include header row: adds the column names as the first line.
• Flatten nested objects: turns an object inside an object into separate columns named with a dot, such as address.city. Without it, the nested object is saved as JSON text in a single cell.
• Protect against spreadsheet formulas: adds an apostrophe in front of text that starts with an equals sign, plus, minus or at sign. Otherwise a spreadsheet could treat that text as a formula. See the safety note below.
• Excel-friendly download: adds a UTF-8 marker to the downloaded file so Excel shows accented and non-English characters correctly.

How different inputs are handled

• Array of objects: each object becomes a row, and the columns are the combined set of all keys. If an object lacks a key, that cell is left empty.
• Array of arrays: each inner array becomes a row, with no header.
• A single object: becomes one row.
• Arrays inside objects: kept as JSON text in one cell so no information is lost.
• Values with commas, quotes or line breaks: wrapped in quotes automatically, as the CSV format requires.

A note on spreadsheet formula injection

If you open a CSV from an untrusted source in a spreadsheet, a cell that begins with a formula character can run commands or pull in external data. Keeping the formula protection option switched on is the safe default for data that came from users, forms or the web. Turn it off only when you really need text that starts with those characters to stay exactly as it is.

Tips for clean results

• If you get an error, check the JSON with the JSON formatter first. It can also fix JavaScript-style data.
• Very deeply nested data produces many columns. Flatten only what you need.
• Use a semicolon delimiter if your spreadsheet software expects it, which is common in some European regions.

Limits and privacy

The converter accepts up to 5 million characters, files up to 2 MB and up to 200,000 rows. All processing happens locally in your browser.

Frequently asked questions

Why are some cells empty?

Different objects can have different keys. When an object does not have a key, its cell is left blank.

Why does Excel show strange characters?

Use the Excel-friendly download option. It adds a marker that tells Excel the file is UTF-8.

Can I convert CSV back to JSON?

Yes, use the CSV to JSON converter on this site.

Does it keep numbers and true or false values?

They are written as plain text in the CSV, because CSV has no data types. A spreadsheet will usually recognize numbers again when you open the file.