slug: how-to-convert-json-to-csv title: How to Convert JSON to CSV (and Back) excerpt: Turn JSON into a clean spreadsheet, handle nested data the right way, and convert CSV back to JSON. Free, no sign-up, works on any device. content: JSON and CSV are the two formats data lives in most often, and at some point you need to move between them. Maybe an API handed you a JSON file and your boss wants it in a spreadsheet, or you have a CSV that a developer needs as structured JSON. Converting JSON to CSV in the browser is fast and private, and this guide walks through how to do it, how to handle nested fields, and how to go the other direction.
Why convert JSON to CSV?
JSON (JavaScript Object Notation) stores data as nested keys and values, which is ideal for code and APIs but awkward to read by hand. CSV (comma-separated values) lays data out as a flat grid of rows and columns that opens instantly in Excel, Google Sheets, or Numbers. Converting from JSON to CSV is really about flattening: taking a list of records and lining them up so each object becomes a row and each field becomes a column.
This is exactly what a free tool like JSON to CSV does. You paste or upload the JSON, it reads the structure, and it returns a CSV you can open in any spreadsheet app. There is nothing to install, no account needed, and the files you upload are deleted within an hour.
How to convert JSON to CSV
The whole process takes a few seconds, and because it runs in the browser, your data does not need to be emailed around or pasted into a random script you found online.
Handling nested data and arrays
The one place JSON to CSV gets tricky is nesting. CSV is flat: it has no concept of an object inside a cell or a list inside a column. JSON has both. When your data has nested fields, here is what generally happens and how to plan for it.
| JSON structure | What it becomes in CSV |
| --- | --- |
| Flat array of objects | One row per object, one column per key (ideal) |
| Nested object (address.city) | Often flattened to a dotted column like address.city |
| Array of values (tags) | Usually joined into one cell, separated by commas or semicolons |
| Array of objects inside a record | May be skipped, stringified, or need pre-flattening |
| Single object (not an array) | Becomes a single-row CSV |
The takeaway: the flatter your JSON, the cleaner your CSV. If you control the data, ask for a top-level array of objects with consistent keys. If you do not, expect some columns to hold combined values, and clean them up in your spreadsheet afterward. For deeply nested or irregular JSON, it can help to simplify the structure before converting rather than fighting the output later.
Converting CSV back to JSON
Developers often need the reverse: a spreadsheet exported as CSV that has to feed an app or API as JSON. The CSV to JSON tool reads your header row as the field names and turns each remaining row into a JSON object, producing an array you can drop straight into code. This round-trip is handy when a non-technical teammate edits data in a spreadsheet and you need it back in a structured format. If your data started as a different format, tools like Excel to CSV and XML to JSON cover the other common conversions, so you can chain steps without ever leaving the browser.
A quick tip for clean round-trips: keep your CSV headers simple, avoid extra commas inside cells unless they are quoted, and use UTF-8 encoding so accented characters and symbols survive the trip.
Frequently Asked Questions
Is converting JSON to CSV free?
Yes. The JSON to CSV tool is free to use with no sign-up and no watermark on your output. You can convert as many files as you need.
Will my data be private?
The conversion runs through the browser, you do not create an account, and uploaded files are deleted within an hour. For sensitive data, that is far safer than pasting it into an unknown online script.
What is the best JSON shape for a clean CSV?
A top-level array of objects where every object has the same keys. That maps perfectly to rows and columns. Nested objects and arrays still convert, but they get flattened or combined, which can make the result less tidy.
Can I open the CSV directly in Excel?
Yes. CSV opens in Excel, Google Sheets, and Numbers. If you want a true .xlsx file instead, take the CSV through CSV to Excel for a native spreadsheet.
How do I turn a spreadsheet back into JSON?
Export the spreadsheet as CSV, then use the CSV to JSON tool. Your header row becomes the field names and each row becomes an object in a JSON array.
Whether you are flattening API output for a spreadsheet or structuring a CSV for code, browser-based conversion keeps it fast, free, and private. Start with the tool that matches your direction and your data is ready in seconds. readTime: 4 min read internalLinks: ["/file/json-to-csv", "/file/csv-to-json", "/file/csv-to-excel", "/file/excel-to-csv", "/file/xml-to-json"] wordCount: 845