How do I convert JSON to CSV online?

Paste your JSON, review how nested fields flatten in the preview table, choose a delimiter, and download the CSV.

What JSON shape works best for CSV conversion?

An array of flat objects is ideal: each object becomes a row and each key becomes a column. A single object becomes one row. If objects have different keys, the converter builds the full column set from every object and leaves blanks where a key is missing.

How are nested objects and arrays handled?

Nested objects are flattened with dot-notation column names, so address.city becomes its own column. Arrays are joined into one cell with a semicolon separator. You can turn flattening off if you prefer nested values serialised as JSON text in a single cell.

Will the CSV open correctly in Excel?

Yes. Values containing commas, quotes or line breaks are wrapped in double quotes with inner quotes doubled, following standard CSV rules, so Excel and Google Sheets read the columns correctly. Pick the semicolon delimiter if your Excel locale expects it.

My JSON is one object, not an array. Can I still convert it?

Yes. A single JSON object converts to a one-row CSV with a header row. An object with nested sections flattens the same way, which is handy for turning a config or profile response into a quick spreadsheet.

Is my data uploaded to a server?

No. The conversion runs entirely in your browser, so API responses containing customer or internal data never leave your machine.

DEVELOPER TOOLS · FREE ONLINE TOOL

JSON to CSV Converter

Convert JSON arrays into spreadsheet-ready CSVAPIs speak JSON, but the people who need the data often live in spreadsheets. This converter turns an array of JSON objects into a proper CSV file in one step: object keys become the header row, each object becomes a data row.

✓ Free to use✓ No sign-up✓ Ready in your browser

// JSON TO CSV CONVERTER · GET STARTED

Use JSON to CSV Converter

Convert JSON arrays into spreadsheet-ready CSV

JSON input

DelimiterFlatten nested objects (dot columns)

// JSON TO CSV CONVERTER · HOW IT WORKS

How to use the JSON to CSV Converter

Paste your JSON

Paste a JSON array of objects (or a single object).

Set the CSV options

Choose the delimiter and flattening options.

Copy or download

Copy the CSV or download it as a .csv file.

// JSON TO CSV CONVERTER · ABOUT THIS TOOL

About the JSON to CSV Converter

APIs speak JSON, but managers, clients and finance teams speak spreadsheets. This converter turns an array of objects into a tidy CSV with a header row built from every key and your choice of delimiter, opening cleanly in Excel or Google Sheets. Nested objects become dot-notation columns and arrays become readable single cells. Everything runs locally in your browser, so production API responses and customer exports stay safe.

Where it helps most

The unglamorous backbone of data handoffs.

Management reports

Exporting analytics events for a report without writing a throwaway script each time.

Client handoffs

Sending a customer list to a marketing colleague who will never touch an API directly.

Log archiving

Archiving JSON logs in a spreadsheet format that auditors can filter and search.

Legacy system imports

Generating a CSV import file for a legacy system that predates JSON entirely, no custom code needed.

Conversion done right

Structural mismatches handled.

Aligned columns

Objects with different key sets still produce aligned columns, with blanks where a field is missing.

Safe quoting

Values with commas, quotes or line breaks get properly quoted so spreadsheets parse them back into single cells.

Nested values

Nested objects and arrays are flattened into readable representations instead of breaking the row layout.

JSON to CSV Converter: private by design

Conversion runs in your browser. Your data never leaves your device, no signup needed.

// JSON TO CSV CONVERTER · COMMON QUESTIONS

JSON to CSV Converter FAQs

How are nested objects handled in the conversion?

Nested objects and arrays are flattened into the cell rather than breaking the row structure, so each top-level object still becomes exactly one CSV row. Deeply nested data produces wider, sparser tables, which is a sign the source JSON may need simplifying first.

What happens when my objects have different keys?

Can I open the result directly in Excel or Google Sheets?

Is it safe to convert JSON containing private data?

tools-guide

WHOIS Lookup: Find Out Who Owns Any Domain Instantly

Free WHOIS lookup for any domain. Check the registrar, registration and expiry dates, name servers and the full WHOIS record instantly, no sign-up needed.

Read article →