Skip to content
JSON Converters

JSON to CSV

Turn JSON into a CSV file for Excel or Google Sheets.

  • Free
  • No sign-up
  • Runs in your browser
Output

Converted output will appear here.

What does JSON to CSV do?

JSON to CSV turns JSON into CSV with a header row and one line per record — it opens directly in Excel or Google Sheets. Paste your data, press Convert, then copy the result or download it as a file.

It works best on a list of similar records: each record becomes one row and each field becomes a column.

What you can use

Valid JSON: an object {…} or, for table-style output, an array of objects [{…}, {…}]. Keys and text values need double quotes, and trailing commas are not allowed.

Example

Input

[
  { "name": "Asha", "city": "Pune" },
  { "name": "Ben", "city": "Leeds" }
]

Output

name,city
Asha,Pune
Ben,Leeds

Each object becomes a row; the keys become the header.

How to use JSON to CSV

  1. Step 1

    Paste your JSON into the input box, or use “Load example” to see the expected shape.

  2. Step 2

    Press Convert. If the input isn’t valid, an error message tells you what is wrong and where.

  3. Step 3

    Copy the CSV output or download it as a file.

Good to know

  • Most errors are a missing comma, a trailing comma after the last item, or single quotes instead of double quotes. The error message points to where parsing stopped.
  • Tables are flat. Nested objects and lists don’t map neatly to columns, so for the cleanest output keep each record one level deep.
  • Values containing commas, quotes or line breaks are wrapped in double quotes, which is what Excel and Google Sheets expect.
  • Big inputs (several MB) work, but the browser may pause for a moment while it converts.

Your privacy

Everything happens in this browser tab: what you paste is converted by JavaScript on your device and never sent to our server. Closing the tab clears it. Even so, don’t paste live passwords, API keys or customer records into any website.

Related tools

All JSON Converters
JSON to JavaTurn JSON into a Java class with typed fields.JSON to XMLTurn JSON into well-formed XML.JSON to YAMLTurn JSON into clean YAML for config files.JSON to TSVTurn JSON into tab-separated rows that paste into a spreadsheet.JSON to TextTurn JSON into plain, readable text.JSON to ExcelTurn JSON into spreadsheet rows and columns.

Guides for this tool

All guides

Frequently asked questions

Is JSON to CSV free?

Yes. JSON to CSV is completely free, with no sign-up, no watermark and no daily limit.

Is the data I paste sent to a server?

No. Conversion runs in JavaScript inside this browser tab and nothing you paste is sent or stored. Even so, avoid pasting live passwords, API keys or private customer data into any website.

Why do I get an error?

Almost always the input isn’t quite valid: a missing comma or quote in JSON, an unclosed tag in XML, or a tab in YAML. The error message shows where parsing stopped — fix that spot, or press “Load example” to compare with input that works.

Does it work on my phone?

Yes. It works in any modern browser on Android, iPhone, tablets and computers — nothing to install.