JSON to CSV Converter
Turn a JSON array into a spreadsheet-ready CSV. Nested objects become columns such as address.city, and the result opens cleanly in Excel or Google Sheets.
- Runs in your browser
- No sign-up
- Free to use
How to use JSON to CSV
- Paste a JSON array of objects, or open a .json file.
- Choose a delimiter. Use a semicolon if your version of Excel expects it.
- Decide whether nested objects should be flattened into separate columns.
- Select Convert to CSV, then copy the result or download it as a .csv file.
JSON to CSV features
Nested data flattened
Objects inside objects become columns named with dot notation, such as customer.address.city.
Consistent columns
Every key found in any record becomes a column, so records with missing fields still line up.
Correct CSV escaping
Values containing commas, quotes or line breaks are quoted according to RFC 4180.
Delimiter choice
Comma, semicolon, tab or pipe, to match the software that will open the file.
Excel-friendly download
The file includes a UTF-8 marker so accented and non-Latin characters display correctly in Excel.
Runs locally
Your data is converted in the browser and never uploaded.
When to use JSON to CSV
- Opening an API response in Excel to sort and filter it.
- Handing exported application data to a colleague who works in spreadsheets.
- Importing JSON records into a database or CRM that accepts CSV.
- Producing a quick report from a log or analytics export.
JSON to CSV FAQ
What JSON structure does it expect?
An array of objects works best: each object becomes a row and each key a column. A single object is treated as one row. If the array is nested inside a wrapper object, such as {"data": [...]}, the first array found is used.
How are arrays inside a record handled?
Arrays of simple values are joined with a semicolon in one cell. Arrays of objects are written as JSON text in the cell, because they cannot be represented as flat columns without duplicating rows.
Why does Excel put everything in one column?
Some regional settings make Excel expect semicolons rather than commas. Choose the semicolon delimiter and convert again, or use Data → From Text/CSV in Excel to pick the delimiter on import.
What happens to null and missing values?
Both become empty cells.
Is there a size limit?
No fixed limit. Files of tens of megabytes convert in a few seconds on a typical computer.
From a tree to a table
JSON is hierarchical: values can contain objects, which contain arrays, which contain more objects. CSV is flat: a grid of rows and columns in which every cell is text. Converting between them means deciding how to represent depth in a single header row.
The convention used here is dot notation. A record with {"user": {"name": "Ada"}} produces a column called user.name. The converter first scans every record to collect the full set of column names, in the order they first appear, then writes one row per record, leaving cells empty where a record has no value for a column.