How do I convert a JSON array to CSV?

On the JSON → CSV tab, paste your array into JSON input (array of objects) or use Upload file. The CSV output appears right away; use Copy or Download. Column headers are the union of all keys across the objects.

Why do I get JSON must be an array of objects?

The converter only accepts a top-level array, such as a list of records. If your data is a single object or wraps the list under a key, copy just the array part. Syntax mistakes show an Invalid JSON message instead.

How are nested objects and arrays handled in the CSV?

By default nested values are written as JSON text in a single cell. Tick Flatten nested objects into dot-notation columns (a.b) to turn an object like address with city into an address.city column. Arrays stay as JSON text.

Why do some cells start with an apostrophe in Excel?

Safe spreadsheet export is on by default. Cells beginning with = + - or @ get an apostrophe prefix so Excel and Google Sheets show them as text, not formulas. Untick that option if you need the raw values.

Can I convert CSV back to JSON, and is there a file size limit?

Yes, use the CSV → JSON tab; it detects comma, semicolon, tab or pipe delimiters and treats the first row as headers. Uploaded files can be up to 20 MB. Everything is processed in your browser.

Yes. Every tool is free to use, with no account and no credit card. The work runs on your device rather than on our servers, which is what keeps it free to run.

Does it work on mobile?

Yes. It runs in current mobile browsers on iOS and Android, with nothing to install.

📊

Free JSON to CSV Converter

Convert JSON arrays to CSV and CSV back to JSON. Handles nested values, quoted fields, and commas in values automatically.

Runs in your browserNo sign-up, no pop-upsNo login requiredFree forever

Works offline once loaded

Safe spreadsheet export — prefix cells starting with = + - @ so Excel and Google Sheets show them as text instead of running them as formulas.Flatten nested objects into dot-notation columns (a.b)

JSON input (array of objects)

CSV output

Output will appear here…

Common uses

Export JSON API Data to CSVConvert JSON API responses and data exports into CSV format for Excel, Google Sheets, and databases.
Convert JSON to Excel-ready CSVTurn any JSON data file or API response into a flat CSV that Excel and Google Sheets can open directly.
Prepare JSON Data for Database ImportConvert JSON exports to CSV for bulk import into MySQL, PostgreSQL, SQLite, and other databases.
Convert JSON Reports to CSV for AnalysisTransform JSON analytics data, reports, and logs into CSV for business intelligence and data analysis.
JSON to CSV for Developer WorkflowsQuickly convert test fixtures, mock data, and config JSON to CSV or back — part of your data pipeline.

How It Works

This tool converts between JSON and CSV entirely in your browser using zero external libraries — the conversion logic is hand-written TypeScript that runs locally. JSON parsing uses the browser's native JSON.parse, while CSV parsing uses a custom RFC 4180 state-machine that handles the edge cases most naive converters get wrong.

1
JSON parsed and headers collected
JSON.parse() reads the input and validates it as an array. The converter then walks every object in the array to build a union of all keys — so sparse arrays where different rows have different fields still produce a complete header row.
2
Optional nested-object flattening
If the flatten option is on, nested objects like {"address":{"city":"Oslo"}} are recursively collapsed into dot-notation columns (address.city) before headers are built. Arrays and empty objects are left as JSON-stringified cell values.
3
RFC 4180-compliant cell encoding with formula neutralization
Each cell value is escaped per RFC 4180: fields containing commas, double-quotes, or newlines are wrapped in double-quotes, and internal quotes are doubled. Safe Export mode (on by default) also prefixes any cell starting with =, +, -, or @ with a single quote, preventing spreadsheet apps like Excel or Google Sheets from treating injected values as executable formulas.
4
CSV-to-JSON uses a character-level state machine
Reversing direction, the shared parseCsv function walks the input character-by-character, tracking whether it is inside a quoted field to correctly handle embedded commas, escaped double-quotes (""), and newlines inside cells — cases that a simple line-split approach mishandles. detectDelimiter sniffs the first row for comma, semicolon, tab, or pipe to support non-standard exports automatically.

Related Tools

📊

Excel / XLSX Viewer

Open and view .xlsx, .xls, .csv, and .ods spreadsheets without Excel or Google Sheets. Switch sheets and export to CSV or JSON. Runs entirely in your browser.

Try itFiles stay local

📊

JSON to Excel

Convert a JSON array of objects into an Excel (XLSX) or CSV spreadsheet. Nested objects become dotted columns. Runs entirely in your browser — no upload.

Try it

📊

PDF to Excel

Extract tables from PDF bank statements, invoices and reports into Excel (.xlsx) or CSV. Preview the rows first; amounts stay real numbers. Runs in your browser — nothing is uploaded.