Skip to content

JSON to CSV Converter

Convert a JSON array to CSV for Excel, or CSV back to JSON — handles quoted fields, commas and line breaks.

About JSON to CSV Converter

This JSON to CSV converter turns a JSON array of objects into a CSV file you can open in Excel or Google Sheets, and converts CSV back into JSON. Paste your data or drop a .json or .csv file, choose the delimiter and options such as flattening nested objects, and check the preview table before copying or downloading.

Quoted fields, commas and line breaks inside values are handled correctly, so your columns stay intact. It is useful for developers, analysts and anyone exporting API data to a spreadsheet. The converter is free, needs no sign-up, and your data stays on your device.

How to use JSON to CSV Converter

  1. Pick the direction: JSON → CSV or CSV → JSON.
  2. Paste your data (or drop a .json / .csv file on the input).
  3. Choose the delimiter and options such as flattening nested objects.
  4. Check the preview table, then copy or download the result.

Frequently asked questions

What JSON shape is supported?

An array of objects works best — each object becomes a row and every key becomes a column. A single object or an array of arrays also works. Nested objects can be flattened to columns like address.city.

Will commas and line breaks inside values break the CSV?

No. Values containing the delimiter, quotes or line breaks are wrapped in double quotes and inner quotes are doubled, following RFC 4180.

Why does Excel show everything in one column?

Excel in some regions expects a semicolon. Choose “Semicolon” as the delimiter, or use Data → From Text/CSV in Excel and pick the comma.

How do I convert JSON to CSV for Excel?

Paste your JSON array, choose JSON → CSV and download the file. Open it in Excel and each key becomes a column.

How do I convert CSV to JSON?

Choose CSV → JSON, paste your CSV with a header row, and each row becomes a JSON object.

Can it convert nested JSON?

Yes. Turn on flattening and nested fields become columns such as address.city.

People also search for

json to csv converter online · json to csv converter online free · json to csv converter free · json to csv converter · json to csv online · json to csv online free · csv to json online · csv to json converter · json to csv · csv to json · can excel convert json to csv · how to json to csv

Related tools