JSON to CSV for Beginners: Get Your Data Into a Spreadsheet

You have been sent a .json file — or you copied some data from a website or API — and now you are staring at a wall of curly braces and quotes. You just want to open it in Excel. This guide explains what JSON is, why it exists, and the fastest way to turn it into a spreadsheet you can actually work with.

What Is JSON and Why Does It Look Like That?

JSON stands for JavaScript Object Notation. It is a way of storing structured data as plain text, and it is the most common format that websites, apps, and APIs use to pass data around.

A simple JSON file might look like this:

[
  { "name": "Alice", "age": 30, "city": "Austin" },
  { "name": "Bob", "age": 25, "city": "Denver" }
]

That is actually a table with two rows and three columns. The problem is that JSON is designed for machines to read, not humans. It is great for sending data between systems, but terrible for doing analysis in a spreadsheet.

CSV (Comma-Separated Values) is the opposite: plain text, one row per line, columns separated by commas. Every spreadsheet app in existence can open a CSV file instantly.

Converting JSON to CSV is just reformatting the same data into a shape your spreadsheet understands.

How to Convert JSON to CSV in Under a Minute (No Coding)

Here is the quickest approach — no software to install, no account to create:

1. Copy your JSON data. If you have a .json file, open it in any text editor (Notepad on Windows, TextEdit on Mac), select all, and copy. If someone sent you JSON in a message or email, just copy the text directly.
2. Open the free converter. Use the tool on this page.
3. Paste the JSON into the input box. You will see it appear on the left side of the tool.
4. Click Convert. The CSV output appears on the right.
5. Download the CSV file. Click the download button. The file saves to your Downloads folder.
6. Open in Excel or Google Sheets. Double-click the .csv file to open in Excel. For Google Sheets, go to File → Import → Upload and select the file.

That is the entire process. No Python, no JavaScript, no command line.

Sell Custom Apparel — We Handle Printing & Free Shipping

What If the JSON Does Not Look Like a Simple List?

Not all JSON is a clean array of rows. Here are the two most common situations you will run into:

The data is wrapped in an outer object:

{ "users": [ { "name": "Alice" }, { "name": "Bob" } ] }

In this case, copy just the array inside the outer object — everything between the square brackets [...] — and paste that into the converter instead of the whole thing. So you would paste: [ { "name": "Alice" }, { "name": "Bob" } ]

Records have nested objects:

[ { "name": "Alice", "address": { "city": "Austin", "state": "TX" } } ]

The converter handles this automatically using dot notation. The nested address fields become columns named address.city and address.state in your CSV. You can rename them in Excel after importing.

If you are not sure what you have, just paste it and try. The converter will show you the output immediately and you can see if it looks right.

Opening Your CSV in Excel and Google Sheets

Excel:

• Double-click the .csv file — Excel usually opens it automatically
• If the data appears in a single column instead of multiple columns, go to Data → Text to Columns → Delimited → Comma and follow the wizard
• If numbers are showing as text (left-aligned), select the column, right-click → Format Cells → Number to fix it

Google Sheets:

• Go to sheets.google.com and create a new sheet
• File → Import → Upload → select your .csv file
• Choose "Replace spreadsheet" or "Insert new sheet(s)" depending on what you need
• Make sure "Separator type" is set to Comma and click Import Data

Once it is in your spreadsheet, you can sort, filter, create pivot tables, and do everything you normally would with any data.

Common Mistakes (and How to Avoid Them)

Pasting only part of the JSON. JSON needs to be complete — every opening bracket or brace needs a matching closing one. If you accidentally cut off the end, the converter will show an error. Go back and make sure you copied everything.

The JSON has comments. Standard JSON does not support comments (lines starting with //). If your JSON file has them, they will cause a parse error. Remove the comment lines in a text editor first.

All your data appears in one row. This usually means you pasted a JSON object instead of an array. An object starts with {, an array starts with [. If your JSON starts with {, look inside it for an array key (like "data", "records", "items") and paste just the array value.

The file is huge and slow to paste. The converter works entirely in your browser, so very large files can be slow to paste. For files over 10 MB, a local script or desktop tool might be faster.

Frequently Asked Questions

Do I need to know programming to convert JSON to CSV?

No. The browser tool on this page requires no coding — paste your JSON and download the CSV. Programming is only needed if you want to automate the conversion or handle thousands of files.

Why can't Excel just open JSON files directly?

Excel can import JSON through Power Query (Data → Get Data → From File → From JSON), but the process is complicated for non-technical users. Converting to CSV first is simpler for most purposes.

What if my JSON has errors and the tool shows a red warning?

The most common causes are: missing a closing bracket or brace, having a trailing comma after the last item, or having comments in the JSON. Copy your JSON into a free JSON validator online to find the exact error location.

Is there a file size limit?

The tool runs in your browser with no server upload, so there is no hard limit. Practically, files up to several megabytes convert quickly. Very large files may be slow depending on your device.