How do I convert JSON to CSV?

Paste your JSON array or object into the converter and select JSON → CSV. The tool automatically discovers all columns, flattens nested objects, formats CSV cells according to RFC 4180 rules, and displays a live table preview before copying or downloading.

How are nested JSON objects converted to columns?

By default, nested JSON objects are flattened using dot notation (such as user.address.city). You can also choose 'Keep as JSON string' if you prefer nested objects preserved as compact JSON strings within a single cell.

What happens to arrays inside JSON when converting to CSV?

Arrays inside JSON object fields are preserved as stringified JSON arrays (such as '[1,2,3]') in a single cell. This prevents silent row explosion or structural distortion of your dataset.

How are commas, quotes, delimiters, and line breaks handled in CSV?

Fields that contain the selected delimiter, double quotes, or line breaks are quoted, and internal double quotes are doubled according to CSV rules. The preview lets you verify the selected delimiter before export.

What is the difference between JSON and CSV?

JSON can represent nested objects, arrays, booleans, numbers, and null directly. CSV is a flat table of rows and columns, so nested JSON needs an explicit flattening or serialization policy.

What is the difference between CSV and Excel (XLSX)?

CSV is plain delimited text and does not store workbook features such as formulas, multiple sheets, styles, or typed cells. XLSX is a structured spreadsheet file format; this tool produces CSV, not a native Excel workbook.

Is my JSON or CSV uploaded?

No. JSON parsing, dot-notation flattening, CSV formatting, table preview generation, and file downloads run 100% locally in your browser.

Processed locally

JSON to CSV Converter Online

Convert JSON to CSV locally, preview columns, flatten nested objects, choose delimiters, download clean CSV, or reverse CSV back to JSON in the same browser tool.

Overview

What this tool does

JSON to CSV Converter Online transforms JSON arrays, objects, and array-of-arrays into clean CSV or TSV data locally in your browser. It automatically discovers columns across all objects, flattens nested structures using dot notation, handles missing or null fields, escapes delimiters and newlines according to CSV standards, and includes an optional spreadsheet formula protection mode. You can also switch to CSV → JSON mode to parse CSV files back to JSON with conservative type inference.

Workflow

How to use

Follow the core workflow below. Use “Show in tool” to locate the real control in the live tool above.

Choose the conversion direction
Use JSON → CSV for spreadsheet-ready rows, or switch to CSV → JSON when you need structured JSON from delimited text.
JSON → CSVCSV → JSON
Switch to CSV to JSON when needed
Optional
Open CSV → JSON to parse delimited rows back into structured JSON while preserving exact strings unless conservative type inference is enabled.
CSV → JSONFirst row is HeaderInfer Primitive Types
Paste JSON or choose a local file
Add an array of objects, a single object, an array of rows, or CSV data that matches the selected direction.
Input DataChoose FileSample Data
Choose how nested data and columns should be handled
Flatten nested objects or keep them as JSON strings, then review which columns will be included and in what order.
Nested objectsColumnsFlatten with dot notationKeep as JSON string
Set CSV output rules
Choose the delimiter, line ending, header behavior, and optional spreadsheet-formula protection before generating the CSV.
DelimiterLine endingHeaderProtect spreadsheet formulas
Review the table preview and diagnostics
Check rows, columns, nested-field handling, and formula-like cells before exporting the converted data.
PreviewRowsColumnsDiagnostics
Copy or download the converted data
Copy the generated CSV or JSON, or download it as a local file after reviewing the conversion settings.
Copy CSVDownload .csvCopy JSONDownload .json

Success

You can now convert JSON to CSV or CSV to JSON, configure flattening and column preferences, and export the converted result.

Copy CSVDownload .csvCopy JSONDownload .json

Practical cases

Examples

API array to spreadsheet CSV

Convert an array of JSON objects into columns with header row included.

Nested user data with dot notation

Flatten nested JSON objects such as user.contact.email into structured CSV columns.

Missing vs null fields

Preserve null as literal string 'null' while missing properties become clean empty cells.

CSV with quoted commas and newlines

Parse or output RFC 4180 compliant CSV fields containing embedded commas, quotes, and line breaks.

IDs with leading zeros in reverse mode

Parse CSV to JSON while preserving identifiers like '00123' as exact strings.

Troubleshooting

Common errors

Silently exploding nested arrays into variable row counts instead of preserving them in cell JSON strings.
Losing nested fields by failing to recursively flatten objects with dot notation.
Incorrect CSV quoting when values contain commas, double quotes, or line breaks.
Treating leading-zero identifiers (e.g. '00123') as numbers during CSV to JSON conversion.
Duplicate CSV headers overwriting object properties silently.
Spreadsheet formula injection when opening untrusted CSV files in Excel or Google Sheets.
Uploading sensitive JSON or CSV datasets to external cloud tools unnecessarily.

From evidence to action

AI workflow

Use the converted CSV or JSON directly when that data format is the artifact required by a script, spreadsheet, test fixture, or coding-agent workflow. Review nested-field and type-conversion settings before moving the output into the next system.

Developer guides

Learn with this tool

Understand the concept, inspect a testable example, then open it in the tool above.

Data FormatsWhat Is a CSV File? Format, Structure, Examples, and Common Pitfalls Data FormatsJSON vs CSV: Differences, Use Cases, and Which Format to Choose Data FormatsCSV vs Excel (XLSX): What’s the Difference?

FAQ

JSON to CSV Converter Online

What this tool does

How to use

Choose the conversion direction

Switch to CSV to JSON when needed

Paste JSON or choose a local file

Choose how nested data and columns should be handled

Set CSV output rules

Review the table preview and diagnostics

Copy or download the converted data