What if my JSON isn't an array?

The tool will treat a single object as one row. If you want multiple rows, wrap your objects in [ ].

How are nested objects handled?

They're flattened using dot notation, so { "user": { "name": "Sam" } } becomes a column called user.name.

What happens if some objects are missing keys?

The CSV will still include those columns; missing fields just become empty cells.

Are values with commas or quotes escaped?

Yes. Values containing commas, quotes, or newlines are wrapped in double quotes and inner quotes are doubled. That's the standard CSV escape rule.

Will the CSV open correctly in Excel?

Yes. The output uses UTF-8 and standard delimiters, so Excel, Google Sheets, and Numbers all read it without issues.

Can I use a different delimiter, like a semicolon?

The default is a comma since it matches the CSV name. Some European spreadsheet locales prefer semicolons, so you can find/replace before importing if needed.

JSON to CSV Converter Online

What is JSON to CSV Conversion?

JSON to CSV conversion turns structured JSON data into a flat table of comma-separated values. JSON is great for APIs and nested objects, but if you want to open the same data in Excel, Google Sheets, or pass it to a data analyst, CSV is what they actually want. A json to csv converter takes care of flattening nested fields and putting everything into rows and columns. If you've ever had to manually copy fields out of an API response into a spreadsheet, that's exactly the problem this tool solves.

Why Convert JSON to CSV?

CSV is the universal language of spreadsheets and data tools. Power BI, Tableau, pandas, R, SQL imports all read CSV without complaining. Most analysts, marketers, and operations folks work in spreadsheets, not JSON viewers. Converting json to csv online removes the friction between developers (who get JSON from APIs) and the rest of the team (who need rows and columns). Use a json to csv tool when you need to export API data for reporting, hand off datasets to non-technical teammates, bulk-import data into Excel, Google Sheets, or a database, or prepare data for machine learning workflows.

How Our JSON to CSV Converter Works

The converter looks at your JSON array, takes the keys from each object as column headers, and lays each object out as a row when you click Convert. Nested fields get flattened using dot notation (address.city, address.zip) so nothing is lost. Special characters like commas and quotes inside values are escaped automatically, so the CSV stays valid. Like the rest of the tools here, the json to csv conversion runs entirely in your browser. Your data doesn't get uploaded.

Features You Get

Smart header detection: pulls column names from your JSON keys automatically.
Nested object flattening: handles deep structures with dot notation.
Proper escaping: quotes, commas, and line breaks inside values are escaped the right way.
One-click copy: paste the CSV straight into Excel or Google Sheets with the Copy button.
Upload support: load a .json file from your device or drag-and-drop it into the input.
No file size lock-in: works in-browser, so it scales with your machine.

How to Use the Tool

Paste a JSON array into the input editor, or use the Upload File button to load a .json file.
Click the Convert button to generate the CSV output.
Check the headers and a couple of rows to make sure the structure looks right.
Click the Copy button and paste the CSV directly into Excel, Google Sheets, or any text editor.

Common Use Cases

Reporting: export API data to share with stakeholders in spreadsheet form.
Data analysis: load CSV into pandas, R, or Excel for charts and pivots.
Database imports: most database tools accept CSV out of the box.
Migration: move data between SaaS tools that don't share an API.

Example Conversion

Input (JSON)

[
  { "name": "Alice", "age": 30, "city": "Berlin" },
  { "name": "Bob", "age": 25, "city": "Madrid" }
]

Output (CSV)

name,age,city
Alice,30,Berlin
Bob,25,Madrid

Frequently Asked Questions

Related Converters

CSV to JSON JSON to YAML JSON to XML