Which separator should I choose?

Comma suits most software and English-language Excel. In much of Europe, Excel expects semicolons because the comma is the decimal mark, so choose semicolon if a comma CSV opens with everything in column A. Tab is handy for pasting into a spreadsheet, and bar for data that is full of commas and semicolons.

Why do accents look wrong when Excel opens a CSV?

Without a marker Excel guesses an old Windows encoding and turns é into Ã©. Leave "CSV marked as UTF-8 for Excel" ticked and the file starts with the byte-order mark that tells Excel it is UTF-8. Untick it for tools that do not expect one, such as some database importers.

What does "Stop text running as formulas" do?

A cell that starts with =, +, - or @ is treated as a formula when a spreadsheet opens a CSV, which can be abused to run commands or leak data (CSV injection). With this ticked, such text gets an apostrophe in front so it shows as text; plain numbers such as -12.5 are left alone. Untick it only if the CSV feeds a program that wants the raw text.

Can it convert JSON Lines to CSV?

Yes. A .jsonl or .ndjson file, one JSON object a line as logs and data exports often are, becomes one row a line. Text with one JSON value per line is recognised even without that extension.

How large a JSON file can become a CSV?

Files up to 150 MB, converted in the background with Stop to cancel. A CSV has no row limit of its own, though Excel opens only the first 1,048,576 rows of one.

Stays on your computer How this works

Free JSON to CSV converter

Convert JSON or JSON Lines to CSV: nested objects flattened into columns, lists into rows, with the separator you need and a UTF-8 mark so Excel shows accents correctly. Preview the table first. Converted in your browser; nothing is uploaded.

Lists of objectsJoin plain lists withCSV separator CSV marked as UTF-8 for Excel Stop text running as formulas in the CSV

Drop a .json or .jsonl file here, or click to chooseTap to choose a .json or .jsonl fileJSON or JSON Lines (.jsonl, .ndjson) · up to 150 MB · nothing is uploaded

Or paste JSON

About this JSON to CSV converter

CSV is the format every spreadsheet, database import and BI tool accepts, and JSON is what most APIs and apps export. This page turns one into the other: it finds the records in the JSON, flattens nested objects into dotted column names, decides what to do with lists, and writes a CSV you can preview before saving. It is free to use, with no account and no upload limit, and it runs entirely in your browser: nothing is uploaded, and while the page stays open, a feature you have already used keeps working offline.

It shares its engine with JSON to Excel, so the same file gives the same columns either way, and an .xlsx is one button away.

What you can do

Convert .json, .jsonl and .ndjson files, or JSON pasted in
Flatten nested objects into columns such as customer.email
Lists of objects as extra rows, or as separate linked CSV files in a ZIP
Comma, semicolon, tab or bar as the separator
A UTF-8 byte-order mark so Excel opens accented and non-Latin text correctly (on by default, can be turned off)
Text that starts with =, +, - or @ is guarded so a spreadsheet does not run it as a formula
Values with commas, quotes or line breaks quoted properly; the header row first

How to convert JSON to CSV

Drop the JSON file on the box or click to choose it, or paste JSON and press Convert.
Tap the box and choose the JSON file, or paste JSON and tap Convert.
Pick the separator: comma for most tools, semicolon if your Excel uses commas as the decimal mark.
Press Save CSV.

Questions

Which separator should I choose?: Comma suits most software and English-language Excel. In much of Europe, Excel expects semicolons because the comma is the decimal mark, so choose semicolon if a comma CSV opens with everything in column A. Tab is handy for pasting into a spreadsheet, and bar for data that is full of commas and semicolons.
Why do accents look wrong when Excel opens a CSV?: Without a marker Excel guesses an old Windows encoding and turns é into Ã©. Leave "CSV marked as UTF-8 for Excel" ticked and the file starts with the byte-order mark that tells Excel it is UTF-8. Untick it for tools that do not expect one, such as some database importers.
What does "Stop text running as formulas" do?: A cell that starts with =, +, - or @ is treated as a formula when a spreadsheet opens a CSV, which can be abused to run commands or leak data (CSV injection). With this ticked, such text gets an apostrophe in front so it shows as text; plain numbers such as -12.5 are left alone. Untick it only if the CSV feeds a program that wants the raw text.
Can it convert JSON Lines to CSV?: Yes. A .jsonl or .ndjson file, one JSON object a line as logs and data exports often are, becomes one row a line. Text with one JSON value per line is recognised even without that extension.
How large a JSON file can become a CSV?: Files up to 150 MB, converted in the background with Stop to cancel. A CSV has no row limit of its own, though Excel opens only the first 1,048,576 rows of one.

For a spreadsheet with real dates and sheets, use JSON to Excel. Excel to JSON goes the other way, XML to Excel handles XML, and the CSV Toolkit cleans and reshapes the CSV afterwards.