JSON Input

CSV Output

What is JSON to CSV Converter?

Need to get your JSON into Excel or Google Sheets? This tool converts your JSON (JavaScript Object Notation) data into CSV format. Great for importing into spreadsheets, doing analysis, or just working with your data in a way that makes more sense.

CSV is the format nearly every spreadsheet, database and reporting tool can import, and RFC 4180 is the closest thing it has to a spec. This converter takes a JSON array of objects, collects every key it finds as a column header, and turns each object into a row. Fields containing the delimiter, quotes or line breaks are quoted the RFC 4180 way. Big integers like 8901240544102066246 keep every digit.

Everything happens in your browser, so your data stays private. Pick a delimiter in the output header (semicolon is what Excel expects in countries that write decimals with a comma), then copy or download the file.

How to Use JSON to CSV

Follow these steps to convert JSON to CSV for Excel and spreadsheets. Each step uses the actual buttons and panels on this page.

Paste JSON Array or Upload

Paste a JSON array of objects into the left JSON Input panel, or click Upload to load a file. Click Sample to see an example. Input format:

[{"subscriberId": "SUB-1001", "plan": "Unlimited 5G", "dataUsage": 45.2}, {"subscriberId": "SUB-1002", "plan": "Family Plan", "dataUsage": 120.5}]

Keys become column headers and each object becomes a row. Nested objects and arrays are written into the cell as JSON text. A single object gives a one-row CSV; plain values in an array go into a "value" column.

View CSV Output

The right CSV Output panel shows the result automatically. Use the Delimiter menu to switch between comma, semicolon, tab and pipe. The downloaded file opens in Excel and Google Sheets. Invalid JSON shows an error.

Download or Copy

Click Download to save the file (converted.csv, or converted.tsv for tab), or Copy to copy it to your clipboard. The download starts with a UTF-8 byte order mark, so Excel shows accented names like "München" correctly. Use Clear on the input panel to start over.

When You'd Actually Use This

Data Analysis

Convert JSON API responses or database exports to CSV for analysis in Excel. Great for creating pivot tables, charts, or doing calculations on your data.

Excel Import

Import JSON data into Excel or Google Sheets. Many business users prefer working with spreadsheets, and CSV is the universal format for data import.

Data Migration

Migrate JSON data to systems that require CSV format. Many legacy systems, reporting tools, or data warehouses accept CSV imports.

Sharing with Non-Developers

Share JSON data with team members who don't work with code. CSV files open in Excel, making data accessible to everyone without technical knowledge.

Common Questions

Is my JSON data stored?

No. Everything happens right in your browser. Your JSON never leaves your computer.

What JSON formats work?

Arrays of objects work best, like [{"sku":"SKU-101","qty":2},{"sku":"SKU-244","qty":1}]. A single object is turned into a one-row CSV. Plain values in an array (["read","write"]) go into a single "value" column. A bare string or number at the top level isn't a table, so you'll get an error.

How are nested objects handled?

They're not flattened into extra columns. Nested objects and arrays are written into their cell as compact JSON text, like {"city":"Austin","zip":"78701"}, quoted so the CSV stays valid. You can parse those cells later, or flatten the JSON before converting if you need separate columns.

Can I convert CSV back to JSON?

Yes. Use the CSV to JSON converter to turn CSV files back into JSON.

What if my JSON has different keys?

The converter collects all unique keys from all objects and creates columns for each. Objects missing certain keys will have empty cells in those columns.

Does it work with large datasets?

Yes, within reason. It all runs in your browser, so speed depends on your device. Typical API exports convert as you type; very large files take longer, mostly because the editor has to render all that text.

Other JSON Tools You Might Need

Conversion is just one JSON task. Here are other tools that work well together: