Developer

JSON to CSV Converter

Convert a JSON array to CSV for spreadsheets, or turn CSV back into formatted JSON.

Processed entirely in your browser. Nothing is uploaded.

Input

Output

Paste your data to convert it.

About

About this tool

JSON is how most apps and APIs exchange data, while CSV is the plain table format that Excel, Google Sheets, and many databases open directly. Moving data between the two by hand is slow and easy to get wrong.

This converter turns a JSON array of objects into CSV with one column for every key it finds, and turns CSV back into JSON with correct handling of quotes, commas, and line breaks inside values. It runs in your browser, so your data is not uploaded.

Quick guide

How to use

  1. Choose a direction: JSON to CSV or CSV to JSON.
  2. Paste your data, or select Use sample to see the expected shape.
  3. Pick a separator if your file uses semicolons or tabs, then check the result and select Copy or Download.
Ideas

When to use it

  • Open API results in Excel or Google Sheets
  • Turn a spreadsheet export into JSON for a website or app
  • Prepare test data for a database import
  • Clean up data that has commas or quotes inside the values
Common questions

Frequently asked questions

What JSON shape works?

An array of objects, such as [{...},{...}]. Each key becomes a column. An array of arrays also works.

What happens to nested objects?

They are placed in the cell as JSON text, so no data is lost.

What does the spreadsheet safety option do?

Spreadsheet programs can run text that starts with = + - or @ as a formula. The option adds a leading apostrophe to those text cells so they stay plain text.

Is there a size limit?

Input is limited to 1,000,000 characters so the page stays fast. Split very large files into parts.

Learn more

Read the guide

How to Convert JSON to CSV (and Back) Without Losing Data