Tool Factory

JSON to CSV Converter

Convert JSON to CSV in your browser. Paste an array of objects, a single object, or an array of arrays — then copy or download. Files never leave the device.

  • JSON → CSV
  • Client-side
  • Copy or download

Paste JSON or open a local .json file. Arrays of objects, a single object, and arrays of arrays become CSV in this tab. Nested values are stringified into cells. Nothing is uploaded.

Paste JSON or choose a file to see CSV columns, a preview, and download.

A JSON to CSV converter (also searched as json to csv or convert json to csv) answers a practical question: how do I get API-shaped data into a spreadsheet without uploading it somewhere? Paste JSON here, or open a local .json file, and get comma-separated rows with a header line.

Arrays of objects become one row per object, with columns from the union of keys in first-seen order. A single object is one row. Arrays of arrays use the first all-string row as headers when present. Nested values stay in one cell as JSON text so the sheet remains flat.

Everything stays on your device. There is no upload, no queue, and no account. If the JSON will not parse, you get an error instead of a broken file.

Going the other way into a workbook? Use the CSV to Excel converter. Need a spreadsheet turned into a document instead? Use the Excel to PDF converter. For photos, try the PNG to JPG converter, the HEIC to PNG converter, or the HEIC to PDF converter. Browse more converters on the Convert hub. For pretty-printed queries, open the SQL formatter. For tokens, use the JWT decoder. For campaign URLs, try the UTM builder.

How to use the JSON to CSV converter

  1. Paste JSON into the box, or choose a local .json file.
  2. Confirm the column list and CSV preview look right.
  3. Copy the CSV, or download a .csv file for Excel or Sheets.
  4. If JSON is invalid or the shape is not tabular, fix the error message and try again.

Frequently asked questions

What is a JSON to CSV converter?

A JSON to CSV converter turns JSON data into comma-separated values you can open in Excel, Google Sheets, or any spreadsheet. This page maps objects to columns and rows in your browser, then lets you copy or download the CSV.

Does this JSON to CSV converter upload my data?

No. Pasted JSON and local .json files are parsed in this tab. Nothing is sent to a server or stored on our side, and there is no account.

What JSON shapes can I convert to CSV?

Use an array of objects (one row per object), a single object (one row), or an array of arrays. For arrays of arrays, if the first row is all strings it becomes the header row; otherwise columns are named column_1, column_2, and so on.

How are nested objects and arrays handled?

Nested objects and arrays are stringified into a single cell with JSON text so the table stays flat. Escape rules follow common CSV practice: commas, quotes, and newlines inside a cell are wrapped in double quotes.

Why convert JSON to CSV?

APIs and exports often return JSON, while reporting, filters, and pivot tables expect a spreadsheet. Converting here gives you a downloadable .csv without installing desktop software or pasting into a third-party upload tool.

Can I convert a local .json file?

Yes. Choose a .json file from your device. The file is read in the browser, converted the same way as pasted text, and never uploaded. Very large files may be slow in the tab — keep them under about two million characters.

What if my JSON is invalid?

If the text is not valid JSON, you get a clear parse error instead of a broken download. Trailing commas, single-quoted keys, and incomplete brackets are common causes — fix the JSON, then convert again.

Is the CSV Excel-friendly?

Yes. The output uses a header row, comma separators, RFC 4180-style quoting, and a trailing newline. Open the file in Excel, Google Sheets, Numbers, or any tool that reads CSV.

Other tools