JSON to CSV Converter
Convert JSON into a CSV table you can open in Excel or Google Sheets, right in your browser.
Your files never leave your device
Drop JSON files here
or
Up to 100 MB per file. Add as many files as you like.
Adds a tiny UTF-8 marker at the start of the file. Turn it off only if another program has trouble with it.
How to convert JSON to CSV
- 1Drag your JSON files into the box above, or click to choose them.
- 2Choose the separator. Comma works almost everywhere, but some European versions of Excel expect semicolons.
- 3Click Convert, then download your CSV files and open them in any spreadsheet app.
How your JSON becomes a table
The converter looks for a list of records, such as an array of objects, and turns each record into a row. Every field that appears in any record becomes a column, so records with different fields still line up.
Nested fields get their own columns, so an address with a city becomes a column called address.city. Lists inside a record are kept as JSON text in a single cell. Many API responses wrap their data in an object with one list inside, such as a "results" list. That list is found and used automatically.
Excel needs a small marker at the start of a CSV file to show Arabic and accented letters correctly. The Excel-friendly setting adds it for you.
Your files stay private
This tool runs entirely in your browser. Your files are never uploaded to a server, so nobody else can see them, not even us.Read our privacy policy
Frequently asked questions
What JSON structure works best?
A list of objects, where each object is one row, for example a list of customers or products. A single object becomes one row, and a list of lists is written as it is.
What happens to nested data?
Nested objects are split into columns with dotted names, such as address.city. Lists inside a record are written into one cell as JSON text. Untick the nested-fields setting to keep each nested object in one cell instead.
Why does my CSV look wrong in Excel?
If all the data ends up in one column, your Excel probably expects semicolons. Choose Semicolon as the separator and convert again. If letters look scrambled, make sure the Excel-friendly setting is ticked.
What if my JSON has a mistake in it?
The converter tells you, and usually shows the line and column where the problem is, so you can fix it in a text editor.
Are my files uploaded to a server?
No. The conversion happens entirely in your web browser, on your own device. Your files are never sent to us or anyone else, so they stay completely private.
Is it really free?
Yes. There is no sign-up, no watermark and no limit on how many files you convert. The only limit is your device: very large files need more memory.
Does it work on my phone?
Yes. It works in any modern browser on Android, iPhone, iPad, Windows, Mac and Linux. Very large files may take longer on older phones.