CSV Output
Supports Nested Objects and Arrays of Objects
Convert JSON to comma-separated CSV for spreadsheet import and data analysis
Try the JSON to CSV converter with sample data
JSON to CSV Converter
Convert JSON to CSV format for Excel and data analysis — handles nested objects & arrays
How to Convert JSON to CSV Online - Step by Step Guide
Use our free JSON to CSV converter to transform your JSON data into CSV format in 3 simple steps
1
Step 1 – Paste or Upload Your JSON File
Paste your JSON data into the JSON to CSV converter, or upload a file directly. An array of objects becomes one CSV row per object, and a single object becomes one row. Try Sample: the first order contains two items, and the second adds an email field.
Multiple Input Methods: Direct paste, file upload, or try sample data to get started quickly
Real-time Validation: Instant syntax error detection with helpful correction suggestions
Objects, Arrays & Nested Data: Arrays of objects become rows; nested objects become dot-path columns
JSON Input
[
{
"order_id": "A-1001",
"customer": {
"name": "Ana Silva",
"city": "Lisbon"
},
"items": [
{
"sku": "A",
"qty": 2
},
{
"sku": "B",
"qty": 3
}
],
"tags": [
"priority",
"gift"
],
"total": 129.5
},
{
"order_id": "A-1002",
"customer": {
"name": "Ben Carter",
"city": "Austin"
},
"items": [
{
"sku": "C",
"qty": 1
}
],
"tags": [],
"total": 42,
"email": "[email protected]"
}
]2
Step 2 – Preview the CSV Output
Watch your JSON to CSV conversion happen instantly. Columns include fields from all records in first-seen order. Nested objects become dot-path columns such as customer.city. In this sample, email is added from the second order, while both items in the first order stay together as JSON in one cell. Simple arrays become comma-separated cells. Values with commas, quotes or line breaks are escaped.
Instant Conversion: See results as you type or paste - no waiting required
Dot-Path Columns: Nested objects are flattened into columns like customer.name
Proper Escaping: Correct handling of quotes, commas, and line breaks for CSV standard
Auto Convert→Real-time
CSV Output
order_id,customer.name,customer.city,items,tags,total,email
A-1001,Ana Silva,Lisbon,"[{""sku"":""A"",""qty"":2},{""sku"":""B"",""qty"":3}]","priority, gift",129.5,
A-1002,Ben Carter,Austin,"[{""sku"":""C"",""qty"":1}]",,42,[email protected]3
Step 3 – Download or Copy CSV
Download the JSON to CSV result as a UTF-8 .csv file, or copy the CSV text to your clipboard. When importing into a spreadsheet app, select a comma delimiter and UTF-8 if those settings are required.
One-Click Download: Save your JSON to CSV result as a comma-separated UTF-8 file
Copy to Clipboard: Instantly copy your JSON to CSV output for pasting into spreadsheets or apps
Spreadsheet Import: Use your spreadsheet app's CSV import options for the delimiter and encoding
One-click export - instant CSV download or copy
2 Options
Download CSV
Save as .csv file
Copy CSV
Copy to clipboard
Download or copy CSV, then select import settings in your spreadsheet app
JSON to CSV Converter FAQs
Common questions about converting JSON to CSV online
Simply paste or upload your JSON data in the browser and get an instant CSV preview—no Python, no installs, no sign-ups required. All processing runs locally on your device for speed and privacy. Click "Download CSV" to save the file or "Copy" to paste directly into spreadsheets. Visit JSON to CSV converter to get started.
Pasted JSON and uploaded files are parsed and converted in your browser; these conversion actions do not send the JSON input to a conversion server. If you load data from an external URL, our server proxy may fetch that resource.
For JSON to CSV conversion, paste a single JSON value: an array of objects (one CSV row per object) or a single object (one row). Columns include fields from all records in first-seen order. Nested objects become dot-path columns, such as user.name. Simple arrays become comma-separated values in one cell. Nested arrays containing objects, mixed values or other arrays are stored as complete JSON in one cell, without adding rows.
Nested objects are flattened into columns using dot-notation paths. For example, {"user": {"name": "John", "address": {"city": "NYC"}}} creates user.name and user.address.city columns. Nested object arrays are kept as complete JSON in a single cell: items: [{"sku":"A"},{"sku":"B"}] becomes an items column containing both objects, rather than separate items.sku columns. CSV quoting escapes the JSON quotes automatically.
The converter generates comma-separated UTF-8 CSV and quotes fields containing commas, double quotes or line breaks. Use your spreadsheet app's CSV import options, selecting UTF-8 and a comma delimiter if needed. Nested object arrays remain JSON text in one cell. The result of opening or pasting CSV depends on the app and its import settings.
There is no guaranteed maximum file size. Available browser and device memory limit JSON to CSV conversion. For larger inputs, start with a small JSON sample or split the data into smaller files before converting.
No installation required! The converter is completely web-based and works directly in your browser. Unlike desktop software or command-line tools (Python, Node.js), you don't need to download, install, or configure anything. Just open the page, paste JSON, and download CSV—it's that simple.
The JSON to CSV converter collects fields from every record, including fields that appear only in later records. Columns follow their first-seen order. A record that lacks a field gets an empty cell; null values and empty arrays also produce empty cells. Nested object arrays are stored as JSON in their own column, so their inner properties do not appear as separate columns. You do not need to put every key in the first record or move nested object arrays out of the record.
Not directly yet. The converter expects one JSON value, so a JSONL file with one object per line shows a syntax error. Convert the lines into a JSON array first with the JSON to JSONL converter (JSONL to JSON direction), or wrap the lines in square brackets and add a comma at the end of every line except the last. Then paste the array into the JSON to CSV converter to get one CSV row per line.
The converter includes automatic JSON validation. If your JSON has syntax errors (missing brackets, trailing commas, unquoted keys), an error message will appear with details about the issue. Fix the JSON syntax and the CSV preview will update automatically in real-time.
Yes! After conversion completes, click the "Copy" button to copy the entire CSV content to your clipboard. You can then paste it directly into Excel, Google Sheets, or any text editor—perfect for quick data transfers without creating intermediate files.
If you need cell formatting, multiple sheets, or formula support, use our JSON to Excel converter to download a .xlsx file directly. It handles nested data and preserves structure in a way that plain CSV cannot.
JSON EDITOR
Edit, format, and beautify JSON
JSON VALIDATOR
Validate, fix, and inspect JSON
JSON ANALYZER
Compare, measure, and map JSON
EXPORT & SHARE
Convert JSON to other formats
IMPORT TO JSON
Convert other formats to JSON
XML TOOLS
Convert, format, fix, and minify XML
CODE & FORMATTERS
Generate code and format other languages