How to Convert JSON to CSV
JSON is perfect for code and APIs, but when you need to open data in a spreadsheet you want CSV. This converter turns a JSON array of objects into a clean table. It collects every key across all the records — so objects with different fields still line up — and writes each object as a row, with empty cells filling any gaps. Fields containing the delimiter, quotes or line breaks are quoted the RFC-4180 way, and any nested object or array in a value is written compactly as JSON so nothing is lost. If your array is wrapped inside an object, the tool finds it automatically. Pick a comma, semicolon or tab, choose whether to include a header, then copy or download. Everything runs in your browser, so nothing is uploaded.
Paste your JSON
Paste an array of objects or load the sample; it's parsed locally with nothing uploaded.
Choose the options
Pick the delimiter and toggle the header row.
Copy or download
Grab the CSV with one tap or save it as a .csv file.
JSON vs CSV — What's the Difference?
JSON — JavaScript Object Notation
A structured format of objects and arrays with real types and nesting, ideal for code and APIs. Spreadsheets can't open it directly as a table.
CSV — comma-separated values
A flat, universally supported table format that opens in every spreadsheet. Converting JSON to CSV flattens your records into rows and columns you can analyse anywhere.
Common Use Cases
Open API data in Excel
Turn a JSON API response into a spreadsheet you can sort and filter.
Reporting
Export JSON records to CSV for reports and dashboards.
Share with non-devs
Give colleagues a familiar CSV instead of raw JSON.
Data analysis
Load JSON data into analysis tools that prefer CSV.
Bulk edits
Convert to CSV, edit in a spreadsheet, then convert back.
Database imports
Prepare JSON records as CSV for import tools.
Migrations
Move data from JSON-based systems into tabular stores.
Quick transforms
A fast, no-install way to turn JSON into CSV.
Tips & Best Practices
Use an array of objects
The cleanest input is a top-level array where each item is an object with the same-ish keys.
Match the delimiter
Choose comma, semicolon or tab to match the tool you'll open the CSV in.
Flatten first for nesting
Nested objects become compact JSON in a cell; flatten your data if you want separate columns.
Keep the header
Leave the header on so your columns are labelled in the spreadsheet.
Differing keys are fine
Records with different fields are unioned automatically, with blanks where a key is missing.
Semicolons for Europe
Use semicolons if the CSV will open in a comma-decimal locale.
Troubleshooting
It says the JSON is invalid
The input must be valid JSON. Check for trailing commas, unquoted keys or mismatched brackets, then try again.
It says no objects found
The converter needs an array of objects. A single object is treated as one row; primitives can't become columns.
A cell shows braces or brackets
That value was a nested object or array, written compactly as JSON. Flatten the data first for separate columns.
A column is missing for some rows
Only keys present in at least one object become columns; rows without that key get an empty cell.
Frequently Asked Questions
How do I convert JSON to CSV for free?
Paste your JSON array of objects above and CSV appears instantly. Copy it or download a .csv file — free, no signup.
What JSON shape does it expect?
An array of objects works best. Each object becomes a row and its keys become columns.
What if objects have different keys?
Every key across all objects becomes a column, and any object missing one gets an empty cell.
Are commas and quotes handled?
Yes. Any field containing the delimiter, a quote or a line break is wrapped in quotes and inner quotes are escaped, per RFC 4180.
What happens to nested objects?
A nested object or array in a value is written compactly as JSON so nothing is lost; flatten first for separate columns.
My array is inside an object — will it work?
Yes. The tool automatically finds an array nested inside a wrapper object and converts it.
Can I choose the delimiter?
Yes. Output comma, semicolon or tab-separated values to match your target tool.
Can I omit the header row?
Yes. Turn off the header option to output only the data rows.
Will the CSV open in Excel?
Yes. The output imports cleanly into Excel, Google Sheets, Numbers and any CSV-aware tool.
What about empty or null values?
Null and missing values become empty cells, keeping every row aligned.
Is my data sent to a server?
No. Everything happens inside your browser, so your data never leaves your device.
Can I download the result?
Yes. Save the output as a .csv file, or copy it straight to your clipboard.
How large a file can it handle?
It comfortably converts thousands of records, all within your browser.
Can I convert CSV back to JSON?
Yes — use our CSV to JSON converter for the reverse direction.
Does it preserve Unicode?
Yes. Any Unicode characters in your data are preserved in the CSV output.
Can I convert to TSV instead?
Yes — choose the tab delimiter for tab-separated output.
Does it work on phones?
Yes, in any modern browser on Windows, Mac, Android or iPhone with nothing to install.
Is this converter really free?
Completely free, forever — no account, no ads and no premium wall.
100% free · No signup · Processed in your browser · Data never sent
Last updated: August 2026 · FlipMyFormat JSON to CSV Converter
Written and maintained by the FlipMyFormat team · Runs entirely in your browser