How to Convert JSON to CSV: A Practical Guide for Non-Developers

To convert JSON to CSV, paste your JSON into a free online converter, or use a short Python script or Excel's Power Query, and save the result as a CSV file you can open in any spreadsheet. Someone sends you a file full of curly braces and quotation marks, calls it JSON, and asks you to pull the numbers into a spreadsheet. If that sounds familiar, you are in the right place. JSON is fantastic for software, but it is not something most people want to read by hand or analyze in Excel. The good news is that converting it into a friendly spreadsheet format is usually quick and free. This guide walks through what JSON and CSV are, why you would convert one to the other, and three practical ways to do it, from a one click online tool to a short Python script.

What Are JSON and CSV?

JSON (JavaScript Object Notation) is a text format that stores data as labeled fields, often nested inside one another, which makes it perfect for apps and websites to pass information around. The JSON format is documented by MDN Web Docs. CSV (comma separated values) is a plain table where each line is a row and commas separate the columns, which is exactly what spreadsheets like Excel and Google Sheets love to open.

Put simply, JSON is built for programs and CSV is built for people who want rows and columns. The JSON data format is standardized as ECMA-404 by Ecma International. Converting between them is just reshaping the same information so a different tool can read it comfortably.

Why Convert JSON to CSV?

JSON is everywhere because APIs, databases, and web services hand back their data in it. But once you have that data, you usually want to actually do something with it, and that often means a spreadsheet. Here are the most common reasons people make the switch.

• Open the data in Excel or Google Sheets to sort, filter, and total it
• Share it with colleagues who do not work with code or raw JSON
• Import it into another tool such as a CRM, an email platform, or accounting software that expects CSV
• Run quick analysis, build charts, or create pivot tables without writing any code

CSV is the universal handshake between systems. Almost every program that handles data can read it, which is why it is the format people reach for when they need to move information from one place to another.

The Easiest Method: A Free Online Converter

If you just want the job done, an online converter is the fastest route and it does not require installing anything. The steps are simple: you open the tool, paste your JSON or upload the file, and download the CSV that comes back. From there you double click the file and it opens straight into your spreadsheet program.

The one quality worth checking is whether the conversion happens in your browser rather than on a remote server. A browser based tool never uploads your data, which matters a lot when the file contains customer details, sales figures, or anything private.

How Does Nested JSON Become Columns?

Here is the part that trips people up. JSON can nest data inside data, but a CSV is a flat grid with no nesting at all. So a converter has to flatten the structure, and it is worth understanding how that works so the output does not surprise you.

Imagine a record with a nested address that contains a city and a zip code. Because CSV cannot nest, the converter typically spreads those nested fields into separate columns using a dotted name, so you end up with columns called address.city and address.zip. Each nested value gets its own clearly labeled column.

Lists are handled a little differently. If a record contains a list of items, a tool will either expand that list into several rows or join the values into a single cell. Either way, the takeaway is the same: nested and repeating data gets unrolled into a flat table, and a good converter labels everything clearly so you can still tell what came from where.

The Python Method

If you do this often, or you want it to run automatically as part of a larger process, a short script is a great option. Python makes it easy, and you do not need to be an experienced programmer to use these snippets. The cleanest approach uses the popular pandas library, which can read JSON and write CSV in just a couple of lines.

import pandas as pd

df = pd.read_json("data.json")
df.to_csv("data.csv", index=False)

That reads a file called data.json, builds a table, and writes data.csv next to it. The index=False part just tells pandas not to add an extra numbering column. If your JSON has nested fields, pandas also offers pd.json_normalize, which flattens them into dotted columns for you.

If you would rather avoid installing anything extra, Python's built in json and csv modules can do the job too. This version reads a list of records and writes them out as a CSV.

import json, csv

with open("data.json") as f:
    rows = json.load(f)

with open("data.csv", "w", newline="") as f:
    writer = csv.DictWriter(f, fieldnames=rows[0].keys())
    writer.writeheader()
    writer.writerows(rows)

This assumes rows is a list of objects that share the same fields, which is the most common shape. It takes the column names from the first record, writes a header line, and then writes every record as a row.

The Excel or Google Sheets Method

You can also stay inside the tools you already know. Modern Excel has a feature called Power Query that reads JSON directly. Go to the Data tab, choose Get Data, then From File and From JSON. Pick your file and Excel opens an editor where you can convert the data into a table, expand any nested fields with a click, and then load it into a sheet. Once it is in a sheet, you save it as CSV with Save As and choosing the CSV format.

In Google Sheets, the simplest path for small files is a free add on from the Google Workspace Marketplace that imports JSON, since Sheets does not read JSON out of the box. After importing, you flatten and tidy the columns, then use File, Download, and Comma Separated Values to export your CSV. For a one off file, honestly, the online converter above is faster than wrestling with an add on.

Tips for Nested Data and Large Files

A few habits will save you headaches, especially as your files get bigger or messier.

• Before converting, check that your JSON is a list of records that share the same fields, since uneven records produce gaps in the table
• Expect nested objects to become dotted columns, and decide whether you actually need every nested field or just a few
• For very large files, prefer a Python script over a browser tool, because scripts handle big data more reliably and will not freeze your tab
• If numbers, dates, or leading zeros look wrong after opening in a spreadsheet, format the column rather than blaming the conversion, since spreadsheets sometimes reinterpret values
• Keep the original JSON file as a backup until you have confirmed the CSV looks correct

Most of the time, conversion is genuinely a few seconds of work. The cases that take longer are deeply nested structures and enormous files, and even those become straightforward once you know to flatten the data and reach for a script when the file is heavy.