JSON to CSV converter

Paste JSON or open a .json file and get a CSV you can open in Excel or Google Sheets. Nothing leaves this device.

Separate columns with

Put nested fields in their own columns Make Excel show every letter correctly (adds a UTF-8 marker to the file)

JSON

Open a .json file

CSV

This tool runs in your browser and needs JavaScript. Turn JavaScript on and reload the page.

How to convert JSON to CSV

1
Paste or open JSON
Paste JSON into the first box, or open a .json file.
2
Check the columns
The CSV appears straight away, with one row for each record.
3
Download
Save the .csv file and open it in Excel, Numbers or Google Sheets.

How the JSON is turned into rows

A list of objects	One row per object and one column for every field found in any of them. Missing fields are left empty.
Nested objects	Become columns with dotted names, such as address.city. Turn this off to keep each nested object as JSON in one cell.
Lists inside a record	Kept as JSON text in one cell, for example ["red","blue"].
An object holding a list	API answers such as {"data": [ ... ]} use the list inside.
A list of lists	Each inner list is written as a row, as it is.
JSON Lines	Files with one JSON object per line work too.

Privacy: how this tool handles your data

When you use JSON to CSV, your browser reads your data on your device and the tool's code does the work in this tab. PageYak's server only sends the page and its code. It never receives your data, so there is nothing to delete afterwards.

How PageYak works explains this in more detail.

When to convert JSON to CSV

Opening API responses and exports in Excel or Google Sheets.
Sharing data with colleagues who do not read JSON.
Importing records into tools that only accept CSV, such as mail lists and accounting software.

Questions

Excel shows strange letters instead of Nepali or accents. Why?

Excel needs a small marker at the start of the file to know it is UTF-8. Keep the Excel option ticked and download the file again.

Excel put everything in one column. What now?

In some countries Excel expects semicolons. Choose Semicolon under Separate columns with, then download again.

Is my data uploaded?

No. The conversion runs in this browser tab, so it is safe for private data and works offline once the page has loaded.

What happens to nested objects?

Nested objects become columns with dotted names, such as address.city, so every value gets its own cell.

Can I open the CSV in Google Sheets?

Yes. Use File, Import, Upload and choose the CSV file.

Last updated 12 November 2026.