“Invalid JSON”
Check for a missing comma, unquoted key or unmatched bracket. Use the JSON Validator to find syntax errors, or JSON Formatter to inspect valid JSON.
Convert JSON to CSV online in seconds. Paste JSON or choose a .json file, turn nested fields into columns, preview the results, and download a CSV file. Your data stays in your browser.
| id | name | profile.city | skills |
|---|---|---|---|
| 00123 | Ada | London | ["JavaScript","React"] |
| 00124 | Ben | Paris | ["Python"] |
JSON to CSV conversion turns structured JSON into rows and columns. Each object in a JSON array becomes a CSV row; its properties become column headers. Nested objects can be flattened into columns such as profile.city. CSV files can be imported into Excel, Google Sheets and many data analysis tools.
This converter creates text-based CSV, not an Excel workbook. If you need a real .xlsx spreadsheet, use our JSON to Excel converter.
Paste an array or object, or choose a .json file from your device. Your file stays on your device.
Click Convert JSON to CSV, then check the rows and columns. Open CSV options if you need a different separator or layout.
Copy the CSV text or download a .csv file for Excel, Google Sheets or another data tool.
Convert a JSON array to CSV with one row per object. In this example, profile.citybecomes its own column, while skills remains JSON text inside a CSV field.
[
{
"id": "00123",
"name": "Ada",
"profile": {
"city": "London"
},
"skills": [
"JavaScript",
"React"
]
},
{
"id": "00124",
"name": "Ben",
"profile": {
"city": "Paris"
},
"skills": [
"Python"
]
}
]id,name,profile.city,skills 00123,Ada,London,"[""JavaScript"",""React""]" 00124,Ben,Paris,"[""Python""]"
Nested JSON objects become dotted column names such as profile.city or customer.name. A JSON array of objects becomes one row per object. All fields found across the records are included as columns, so a field missing in one record is blank rather than disappearing from the table.
Nested arrays stay as compact JSON text in one CSV cell by default. Open CSV options and choose Expand into columns to make indexed columns such as skills.0 and skills.1. This changes the columns, not the number of records: it does not create a new CSV row for every array item.
| JSON shape | CSV behavior |
|---|---|
| Array of objects | One row per object, with a combined set of column headers. |
| Single JSON object | One CSV row with columns taken from that object's fields. |
Object with one record array, such as data | The list is automatically used to create the CSV rows. |
| Object with several record arrays | Convert once, then choose the intended top-level array under CSV options → Rows from and convert again. |
| Nested objects and arrays | Nested objects become columns such as profile.city. Lists stay together in one cell unless you choose Expand into columns. |
Missing fields, null, or empty strings | All produce blank CSV cells. CSV cannot distinguish these values on its own. |
Some API responses place the records inside a field called data, instead of making the list the entire JSON file. The converter can use that list to create the CSV rows.
{
"data": [
{
"order": "A-001",
"customer": {
"name": "Ada",
"country": "UK"
},
"total": 49.5
},
{
"order": "A-002",
"customer": {
"name": "Ben",
"country": "FR"
},
"total": 28
}
]
}order,customer.name,customer.country,total A-001,Ada,UK,49.5 A-002,Ben,FR,28
Automatic selection works when the list is directly inside the main JSON object. It won't find a list deeper inside your data, such as response.data.items. For those files, paste the list you want to convert into the JSON input box.
You can convert JSON files without installing software. Choose a local .json file, inspect the result, then download converted.csv or copy the CSV text. The JSON is read and processed in your browser, not uploaded to a conversion server.
You can convert JSON files up to 10 MiB (about 10.5 MB) and download CSV files up to 24 MiB (about 25 MB). For smooth performance, each conversion supports up to 100,000 rows and 2,000 columns. The table preview shows the first 50 rows, and the CSV text preview shows the first 6,000 characters. The downloaded CSV still contains all converted rows.
Your input must be one JSON object or array. If your file has a separate JSON object on each line (JSONL or NDJSON), combine those objects into a JSON array first. This converter doesn't support JSONL files directly.
If a value contains a comma, quotation mark or line break, it needs extra care to keep the CSV columns intact. The converter places quotes around these values and doubles any quotation marks already inside them. Each CSV row ends with a standard line break.
| JSON value | CSV field | Reason |
|---|---|---|
"London, UK" | "London, UK" | The comma requires surrounding quotes. |
He said "Hi" | "He said ""Hi""" | Embedded quotes are doubled. |
line 1\nline 2 | "line 1
line 2" | The JSON input shows \n; the CSV keeps that line break inside a quoted value so it doesn't start a new row. |
["JavaScript","React"] | "[""JavaScript"",""React""]" | Nested arrays remain JSON text by default, escaped as one CSV field. |
Use commas for most CSV files. Some spreadsheet setups expect semicolons instead, and you can also separate values with tabs. The download is still namedconverted.csv, even if you choose a different separator.
CSV is a plain-text table, not a workbook with typed cells or multiple sheets. The CSV file preserves the characters written by the converter, but Excel or Google Sheets may interpret those characters as numbers, dates or formulas when importing the file.
| Data | What to know |
|---|---|
Leading-zero ID, e.g. 00123 | The CSV contains the original digits, but Excel may display 123. Import the column as Text to retain zeros. |
Large integer, e.g. 9007199254740993 | The exported CSV keeps the digits, but Excel may round long numbers. Import the column as Text to preserve them. |
Boolean, null and absent fields | Booleans become true or false. Null, missing and empty-string cells are not distinguishable in CSV. |
| Text that resembles a spreadsheet formula | By default, the converter adds an apostrophe to values that might be read as formulas. This changes the CSV text and cannot guarantee safety in every spreadsheet app. |
If accented letters, Chinese characters or other text look wrong in Excel, open CSV options and enable UTF-8 BOM (Excel compatibility). The converter does not impose Excel's 32,767-character cell limit on CSV values; your spreadsheet application may still impose its own limits when you open the file.
For IDs and long numbers, use your spreadsheet's Text/CSV import feature and set those columns to Text. If you need the exact original CSV text, you can turn off the formula-risk option. Only do this when you trust the data you're opening.
Both tools can turn JSON objects into rows and columns. The important difference is the file they produce: CSV is a portable delimited-text table; XLSX is a spreadsheet workbook. Choose based on what the next application expects.
| Feature | JSON to CSV | JSON to Excel |
|---|---|---|
| Download format | Plain-text .csv | Excel .xlsx workbook |
| Rows and columns | Yes | Yes |
| Cell types | Text only; the reader interprets values | Spreadsheet cells can hold numbers, booleans and text |
| Multiple sheets and workbook features | No | The downloaded Excel file contains one sheet |
| Best for | Database import, data interchange, simple tables | Opening and editing a workbook in Excel or similar apps |
Need a real Excel workbook instead? Convert JSON to Excel (.xlsx). If you need to check an API response before exporting it, use our JSON Compare tool.
Check for a missing comma, unquoted key or unmatched bracket. Use the JSON Validator to find syntax errors, or JSON Formatter to inspect valid JSON.
An empty array has no data rows. A list of empty objects has no columns. Supply at least one record containing a field, then convert again.
If your JSON contains several lists, the first result may show the whole object as one row. Open CSV options, select the list you need under Rows from, then convert again.
Fields absent from one JSON object appear as blank CSV cells. Null and empty strings are also blank. CSV alone cannot recover which of those was originally present.
Excel may infer numeric and date formats on import. Import the CSV through the text/CSV workflow and mark identifier and long-number columns as Text.
This tool has file-size and table-size limits to keep your browser responsive. Try splitting a large JSON file into smaller files and converting them separately.
Paste JSON or upload a .json file, click Convert JSON to CSV, check the table or CSV preview, and then copy the CSV or download converted.csv.
Yes. Choose a .json file from your device, preview the converted rows, then download a .csv file. The file is processed in your browser, without uploading its contents.
Yes. Nested objects become columns with dotted names, such as profile.city. Nested arrays stay as JSON text in one cell by default, or you can expand array items into separate columns.
Yes. Each object becomes one row. Columns include fields found across the objects, and missing or null fields become empty cells.
Yes. CSV is a text-based table format that Excel and Google Sheets can import. You can enable a UTF-8 BOM for some Excel configurations. Excel may still automatically change long numbers and IDs with leading zeros; import those columns as text if precision matters.
Not completely. CSV stores text rather than JSON data types. True and false become text, while null and missing fields become empty cells. The CSV contains the converted values, but Excel or other spreadsheet apps may interpret numbers and dates differently.
No. Your JSON file and the CSV it produces are processed in your browser. The contents of your JSON and converted CSV are not uploaded to our servers.
CSV is a plain-text table format without worksheets or typed spreadsheet cells. JSON to Excel creates a real .xlsx workbook instead. Use JSON to Excel if you need an Excel workbook.
Yes. Use CSV to JSON Converter to turn CSV rows into JSON objects or arrays. The conversion runs in your browser, and you can copy or download the result.
If your JSON contains one list of records inside a field such as data, the converter uses that list automatically. If it contains several lists, convert once, open CSV options, choose the one you want under Rows from, and convert again. Lists stored deeper inside other objects cannot be selected directly.
If a value contains the chosen separator, quotation marks or a line break, the CSV puts it inside double quotes. Quotes inside a value are doubled. Line breaks within a quoted value are kept, so the data stays in the correct column.
No. This tool accepts a JSON object or array. JSONL and NDJSON files contain separate JSON values on different lines. Combine them into one JSON array before using this converter.