JSON to CSV Converter
Turn JSON data into a CSV file for Excel or Google Sheets. Your data stays on your device.
- Runs in your browser
- No sign-up
- No watermark
This tool turns JSON into a table. A list of objects becomes one row per object, and the keys become the header. Nested objects are flattened into columns with dotted names such as address.city, and arrays become numbered columns such as tags.0 and tags.1.
Values that contain the delimiter, quotes or line breaks are quoted correctly. Everything happens in your browser, so the JSON is not uploaded.
How to use JSON to CSV
- Paste your JSON, or choose or drop a .json file.
- Pick the delimiter and the line endings.
- Tick the byte order mark option if the file is going to Excel and has accented letters.
- Copy the CSV or download it.
Frequently asked questions
Is my JSON uploaded?
No. It is converted in your browser and never leaves your device.
What JSON shapes work?
A list of objects works best. A list of lists, a list of plain values and a single object also work. If the JSON is an object with one key that holds a list, such as {"data": [...]}, the list inside is used.
How are nested objects and arrays handled?
They are flattened. An object inside an object becomes a column named with a dot, like user.name. Items in an array become numbered columns, like tags.0, tags.1. Rows that lack a key get an empty cell.
Why do accents look wrong when I open the CSV in Excel?
Excel often assumes an older text encoding. Tick the byte order mark option before downloading and Excel will read the file as UTF-8.
Can I use a semicolon or a tab instead of a comma?
Yes. Choose comma, semicolon, tab or pipe. Many European versions of Excel expect a semicolon.
What happens to null and true or false?
null becomes an empty cell. true and false are written as the words true and false. Very large whole numbers can lose precision because JSON numbers are read as ordinary decimal numbers.