JSON to CSV
Convert a JSON array of objects to CSV online, ready for Excel.
Auto-fix broken JSON: When on, invalid JSON is repaired automatically before running: “Remove” drops the broken property, “Set null” keeps its key with a null value.
Output will appear here...About JSON to CSV
A JSON to CSV converter turns a JSON array of objects into comma-separated rows that open directly in Excel, Google Sheets, or any spreadsheet. Each object becomes a row and each property becomes a column, with a header row generated automatically from the keys. Nested objects are flattened into dotted column names (like address.city), so tree-shaped data still lands in a readable grid.
This converter runs online, entirely in your browser — the JSON is parsed and converted locally, so even private data never touches a server. You choose the delimiter (comma, semicolon, or tab, for tools and locales that expect a different separator), then copy the result or download it as a .csv file that opens in your spreadsheet with a double-click. It's the fastest path when someone asks for JSON data 'as a spreadsheet'. Need the reverse? Use the CSV to JSON converter, or check the result in the CSV Viewer before sending it on.
How to Use
- 1Paste a JSON array of objects (the typical shape of an API response or export) into the input.
- 2Choose your delimiter — comma for standard CSV, semicolon or tab if your spreadsheet locale expects it.
- 3The CSV appears instantly, with a header row built from the keys and nested objects flattened to dotted columns.
- 4Copy the output or download the .csv, then open it in Excel or Google Sheets with a double-click.
Common Use Cases
- Exporting API data into Excel or Google Sheets for analysis and reporting
- Handing JSON exports to non-developers who live in spreadsheets
- Building a quick report from JSON logs without writing a script
- Migrating data from a JSON-based tool into anything that imports CSV
Frequently Asked Questions
How are nested objects and arrays handled?
Nested values are flattened into columns using dotted key paths so the tabular output stays readable. Deeply nested arrays are serialized into a single cell so no data is lost during conversion.
Can I choose a different delimiter?
Yes. Comma is the default for standard CSV, but you can switch to semicolon or tab if your spreadsheet locale or target tool expects a different separator.
Can I use this to convert JSON to Excel?
Yes — CSV is the bridge. Convert your JSON here, download the .csv, and Excel opens it directly with each key as a column header. For repeatable imports inside Excel itself you can also use Power Query, but for a one-off export this is the faster route.
What JSON structure converts best to CSV?
A flat array of objects with the same keys — the classic API list response — converts perfectly: one object per row, one key per column. Single objects, nested structures, and mixed shapes still convert, but expect dotted column names and serialized cells where the tree doesn't fit the grid.
Is my JSON uploaded when I convert it?
No. The conversion runs entirely in your browser with JavaScript — nothing is sent to a server, so the tool is safe for private or sensitive data, and it keeps working offline once the page has loaded.
Is JSON to CSV free to use?
Yes. JSON to CSV is completely free with no sign-up, no subscription, and no usage limits. Every tool on CodeUtilityKit is free forever.
Is my data safe when I use JSON to CSV?
Absolutely. JSON to CSV runs entirely in your browser. Your input is processed locally with JavaScript and is never sent to, stored on, or logged by any server — so it is safe even for private or sensitive data.
Features
- Run JSON to CSV instantly, right in your browser
- 100% private — your data never leaves your device
- Copy the result to your clipboard in one click
- Free and unlimited with no account or sign-up
- Clear, friendly error messages when something is wrong
- Works on desktop and mobile, even offline after first load