Private JSON to CSV conversion in your browser

JSON to CSV Converter

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.

JSON TO CSV CONVERTERTurn JSON arrays and nested objects into a downloadable CSV table.
No upload required
JSON Input
CSV Preview
idnameprofile.cityskills
00123AdaLondon["JavaScript","React"]
00124BenParis["Python"]
2 rows · 4 columns
CSV options Separator, lists & Excel settings

When enabled, this option adds an apostrophe to text that might be treated as a spreadsheet formula. Turn it off for unchanged text export. Excel may still change IDs or long numbers when opening CSV files.

RESULT2 rows ready for CSV
Download .csv files Runs in your browser Nested JSON support
01

What Is JSON to CSV Conversion?

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.

02

How to Convert JSON to CSV Online

01

Paste JSON or choose a file

Paste an array or object, or choose a .json file from your device. Your file stays on your device.

02

Convert and preview the table

Click Convert JSON to CSV, then check the rows and columns. Open CSV options if you need a different separator or layout.

03

Copy or download CSV

Copy the CSV text or download a .csv file for Excel, Google Sheets or another data tool.

03

JSON to CSV Example

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.

JSON INPUT
[
  {
    "id": "00123",
    "name": "Ada",
    "profile": {
      "city": "London"
    },
    "skills": [
      "JavaScript",
      "React"
    ]
  },
  {
    "id": "00124",
    "name": "Ben",
    "profile": {
      "city": "Paris"
    },
    "skills": [
      "Python"
    ]
  }
]
CSV OUTPUT
id,name,profile.city,skills
00123,Ada,London,"[""JavaScript"",""React""]"
00124,Ben,Paris,"[""Python""]"
04

Convert Nested JSON to CSV

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.

Which JSON structures can be converted?

JSON shapeCSV behavior
Array of objectsOne row per object, with a combined set of column headers.
Single JSON objectOne CSV row with columns taken from that object's fields.
Object with one record array, such as dataThe list is automatically used to create the CSV rows.
Object with several record arraysConvert once, then choose the intended top-level array under CSV options → Rows from and convert again.
Nested objects and arraysNested objects become columns such as profile.city. Lists stay together in one cell unless you choose Expand into columns.
Missing fields, null, or empty stringsAll produce blank CSV cells. CSV cannot distinguish these values on its own.

Example: convert an API response with a data list

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.

JSON INPUT
{
  "data": [
    {
      "order": "A-001",
      "customer": {
        "name": "Ada",
        "country": "UK"
      },
      "total": 49.5
    },
    {
      "order": "A-002",
      "customer": {
        "name": "Ben",
        "country": "FR"
      },
      "total": 28
    }
  ]
}
CSV RESULT
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.

05

Convert a JSON File to CSV

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.

06

How CSV Handles Quotes, Commas and Newlines

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 valueCSV fieldReason
"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.

07

Open JSON to CSV Results in Excel

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.

DataWhat to know
Leading-zero ID, e.g. 00123The CSV contains the original digits, but Excel may display 123. Import the column as Text to retain zeros.
Large integer, e.g. 9007199254740993The exported CSV keeps the digits, but Excel may round long numbers. Import the column as Text to preserve them.
Boolean, null and absent fieldsBooleans become true or false. Null, missing and empty-string cells are not distinguishable in CSV.
Text that resembles a spreadsheet formulaBy 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.

08

JSON to CSV vs JSON to Excel

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.

FeatureJSON to CSVJSON to Excel
Download formatPlain-text .csvExcel .xlsx workbook
Rows and columnsYesYes
Cell typesText only; the reader interprets valuesSpreadsheet cells can hold numbers, booleans and text
Multiple sheets and workbook featuresNoThe downloaded Excel file contains one sheet
Best forDatabase import, data interchange, simple tablesOpening 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.

09

Common JSON to CSV Problems

“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.

“No rows to export”

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.

Wrong rows from an API response

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.

Missing values in some columns

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.

IDs or dates change in Excel

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.

File too large or slow to process

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.

FAQ

Frequently asked questions

How do I convert JSON to CSV online?

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.

Can I convert a JSON file to 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.

Can I convert nested JSON to CSV?

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.

Can I convert a JSON array to CSV?

Yes. Each object becomes one row. Columns include fields found across the objects, and missing or null fields become empty cells.

Can I open the CSV file in Excel?

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.

Does JSON to CSV preserve data types?

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.

Is my JSON uploaded to a server?

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.

What is the difference between JSON to CSV and JSON to Excel?

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.

Can I convert CSV back to JSON?

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.

What happens when the JSON contains multiple arrays?

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.

How does the converter handle commas, quotation marks and line breaks?

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.

Can I convert JSONL or NDJSON files here?

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.