JSON to CSV

Convert JSON to CSV for Excel or Google Sheets: flattens nested objects, joins lists, and saves Hindi and ₹ correctly for Excel.

Runs in your browserNo sign-upWorks offline
Ctrl+Enter to run
Input121 characters
Output
✓ ReadySample content shown

What the JSON to CSV does

JSON to CSV turns JSON from an API, an export or a database into a table you can open in Excel, Google Sheets or Numbers. It accepts an array of objects, a single object, an object holding one list, or JSON Lines with one object per line. Every key found becomes a column, nested objects are flattened into columns such as address.city, and simple lists are joined with semicolons. The download is Excel-friendly, so Hindi, other scripts and ₹ display properly.

How to use it

  1. Paste JSON on the left.
  2. Choose the separator and how nested data is handled.
  3. Keep the Excel-friendly option on if the file will be opened in Excel.
  4. Copy the CSV, or download it.

Example

The sample with two people gives 2 rows and 5 columns: name, address.city, address.pin, skills and age. Priya’s skills list becomes “Excel; SQL”, and “Ravi, K” is wrapped in quotes because it contains a comma. Missing values, such as Ravi’s address, become empty cells.

Why Excel needs the option

Excel on Windows opens CSV files in an older encoding unless the file starts with a small marker (a byte order mark), so Hindi text and the ₹ sign turn into gibberish. The Excel-friendly download adds that marker; other apps simply ignore it.

In countries where the comma is the decimal separator, Excel expects semicolons between columns; choose Semicolon if columns appear merged.

Questions people ask

Is my data uploaded?

No. The conversion happens in your browser as you type, so data such as customer lists or keys never leaves your device.

What happens to lists of objects inside a record?

They are written into one cell as JSON text, so no data is lost. Simple lists of words or numbers are joined with semicolons.

Are columns in a fixed order?

In the order keys first appear in the data, so the first record decides most of the order.

Can it read JSON Lines?

Yes. One JSON object per line, as used by many logs and exports, works.

Related tools