Free Online JSON to CSV Converter

Convert JSON to CSV format instantly. Handles nested objects. Works offline.

JSON Input
or

Click to upload or drag & drop a .json file

Or paste JSON
CSV Output
Enter JSON to convert

How the JSON to CSV Converter Works

Our converter transforms JSON arrays and objects into properly formatted CSV files. It automatically handles nested objects by flattening them with dot notation, making complex JSON structures spreadsheet-ready.

Automatic Flattening

Nested objects are flattened automatically. For example, a nested address object becomes separate columns like "address.city" and "address.country", preserving all your data in a flat structure.

Privacy First

All conversion happens locally in your browser. Your JSON data is never uploaded to any server, making this tool safe for converting sensitive business data, API responses, or personal information.

Frequently Asked Questions

The converter works best with arrays of objects, where each object represents a row. Nested objects are flattened using dot notation (e.g., "address.city" becomes a column header).

Nested objects are flattened automatically. For example, {name: "John", address: {city: "NYC"}} becomes columns "name" and "address.city". Arrays within objects are joined with semicolons.

Yes! A single object is converted to a CSV with one data row. The object keys become column headers and values become the row data.

All conversion happens locally in your browser using JavaScript. Your JSON data is never sent to any server, making it safe for sensitive or confidential data.

More Free Online Tools

Text Cleaner
Strip formatting, fix quotes, convert case
QR Generator
Create QR codes, download PNG/SVG
Unit Converter
PX to REM, Hex to RGB, Unix to Date
JSON Formatter
Format, minify, validate JSON
Base64 Encoder
Encode and decode Base64
Text Diff
Compare text side by side
The Complete Guide

About the JSON to CSV Converter

JSON is the language of APIs. CSV is the language of spreadsheets. Every developer eventually needs to bridge the two: exporting an API response to Excel so your marketing team can filter it, migrating data from a NoSQL store to a spreadsheet for analysis, or preparing bulk-upload files for services like Mailchimp or Salesforce.

Our JSON to CSV converter takes any JSON array of objects and produces a CSV file with columns automatically derived from the object keys. Nested objects are flattened using dot notation (e.g., `user.address.city` becomes a single column). Arrays inside cells are joined with a configurable separator. Everything runs in your browser using pure JavaScript — no upload, no size limit beyond your machine's memory.

You control delimiter (comma, tab, semicolon, pipe), quoting rules (RFC 4180 or Excel-compatible), header row inclusion, and column ordering. The output is CSV strict enough to pass parsers built into pandas, Excel, and Postgres COPY FROM.

How to use JSON to CSV Converter

1

Paste JSON

Paste any JSON array of objects into the input. It can come from a REST API response, a MongoDB export, or a database query. Nested objects and arrays are handled automatically.

2

Configure options

Pick your delimiter (comma is default; use semicolon for European Excel). Choose whether to include a header row. Set the nested-object flattening depth if you want to keep them as JSON strings instead.

3

Click Convert

The CSV output appears instantly with columns derived from union of all object keys. Cells are properly quoted per RFC 4180: commas and quotes inside values are escaped.

4

Preview or download

The preview table shows the first 20 rows. Click "Download CSV" to save the full result as a .csv file, ready for Excel, Google Sheets, Numbers, or any spreadsheet.

5

Import into your tool

Open the CSV in Excel (double-click), Google Sheets (File → Import), pandas (`pd.read_csv`), or PostgreSQL (`COPY tablename FROM 'file.csv' CSV HEADER`).

Common Use Cases

API response to Excel

Export a JSON response from a REST API (like Stripe payments or GitHub issues) to a spreadsheet for team review.

Database migration

Pull JSON from MongoDB with `mongoexport --jsonArray`, then convert to CSV for import into PostgreSQL, MySQL, or BigQuery.

Bulk uploads

Many services (Mailchimp, Salesforce, HubSpot) accept CSV bulk uploads for contacts, leads, or products. Convert your JSON list to their expected format.

Data analysis in pandas

While pandas can read JSON directly, CSV is more portable across machines and easier to inspect in a text editor mid-pipeline.

Reporting for non-developers

Product managers and analysts live in spreadsheets. Convert JSON reports to CSV so they can filter, pivot, and chart without needing JSON.

Legacy system integration

Older enterprise systems (SAP, Oracle) often only accept flat CSV. Flatten your modern JSON API responses before feeding them in.

Frequently Asked Questions

By default they're flattened with dot notation: `{user: {name: "Alice"}}` becomes a column `user.name`. Alternatively, you can serialize them as JSON strings in a single cell — useful when you want to preserve the original shape.

Related Tools You May Like

CSV to JSON →

Reverse — go from CSV back to JSON.

JSON Formatter →

Format & validate JSON before converting.

JSON to YAML →

Convert JSON to YAML config format.

Related searches:

json to csv
json to excel
convert json to csv
json to spreadsheet
json to xlsx
json array to csv
nested json flatten
json export