My JSON is an object, not an array — will it work?

Enter the path to the array inside it (for example results). A single object is converted as one row.

How are missing fields handled?

Columns are the union of all keys; missing values are empty cells.

Can I convert NDJSON (one object per line)?

Yes, NDJSON is detected automatically.

Data & Spreadsheets

JSON to CSV

API responses and exports come as JSON; analysis happens in spreadsheets. Flatten nested JSON into a CSV with one row per record and a column per field.

Runs in your browser — files never leave your device.

Drop JSON, TXT files here

or click to browse · paste from clipboard · up to 100 MB each

Select files

Options

Path to the array (optional)

Arrays inside records

Delimiter

Why convert JSON to CSV

JSON is hierarchical and CSV is flat, so the useful part is the flattening: nested objects become dotted columns (address.city), arrays become indexed columns or joined strings, and records with different keys get the union of all columns.

The result opens directly in Excel, Google Sheets and pandas without any parsing code.

How it works

Drop JSON, TXT files onto the box above, click it to browse, or paste from the clipboard.
Adjust the options if you need to — the defaults suit most cases.
Press Convert. The work happens on your device, so speed depends on your computer or phone.
Download the CSV — individually or all at once.

About the formats

JSON · JavaScript Object Notation · .json

The data format of web APIs: nested objects and arrays in plain text, readable by every programming language.

JSON supports nesting; converting it to a flat table (CSV, Excel) requires flattening nested keys such as address.city.
JSON has no comments and requires double quotes around keys and strings.
A JSON array of objects maps naturally to a spreadsheet: one object per row, keys as column headers.

TXT · Plain text · .txt

Just characters, no formatting: the most portable format there is, opened by every editor ever written.

Plain text has no fonts, colours or images; only the words, line breaks and tabs survive.
Encoding matters: UTF-8 is the modern default; older Windows files may use Windows-1252 and show odd characters for accented letters.
Line endings differ between Windows (CRLF) and macOS/Linux (LF), which some tools care about.

CSV · Comma-separated values · .csv

A plain-text table with one row per line and commas (or semicolons) between cells: the lowest common denominator for exchanging data.

CSV has no sheets, formulas, formatting or data types — everything is text.
European locales often use semicolons as separators because the comma is the decimal mark.
Values containing commas or line breaks must be wrapped in double quotes.

Related conversions

CSV to JSONOn-deviceCSV rows into a JSON array of objects.JSON to ExcelOn-deviceJSON arrays into a formatted Excel workbook.Excel to CSVPopularOn-deviceExcel sheets to CSV with chosen delimiter and encoding.CSV to ExcelPopularOn-deviceCSV into a proper Excel workbook, delimiter auto-detected.Excel to JSONOn-deviceExcel sheets to JSON arrays with typed values.ODS to ExcelOn-deviceLibreOffice Calc ODS to Excel XLSX.

More in Data & Spreadsheets · All converters