๐โ๐ JSON to CSV
Convert JSON arrays to CSV free online. Opens directly in Excel or Google Sheets. Handles nested objects, no upload required.
๐โ๐ JSON to CSV
๐ง Loading toolโฆ
About the JSON to CSV Tool
API responses arrive as JSON, but the people who need to read them usually want a spreadsheet. Converting an array of JSON objects into CSV produces a file that opens straight into Excel, Google Sheets, or Numbers, where it can be sorted, filtered, and charted by anyone.
The converter reads your JSON array, derives column headers from the object keys, and writes properly escaped CSV rows. Values containing commas or quotes are quoted correctly so the file does not break when opened. It runs entirely in your browser, so API payloads containing real data stay private.
How to Use JSON to CSV
- Paste your JSON array of objects into the input area.
- Press Convert. Column headers are derived automatically from the object keys.
- Review the CSV output.
- Download it and open in Excel or Google Sheets.
When to Use This Tool
- Handing API output to colleagues who work in spreadsheets
- Preparing a data export for a report or presentation
- Loading JSON data into a tool that only accepts CSV import
- Creating a readable backup of structured data
- Analysing API results with spreadsheet formulas and pivot tables
Things Worth Knowing
- Input must be an array of objects. A single object or deeply nested structure needs flattening first.
- Nested objects and arrays are flattened or stringified, since CSV is strictly two-dimensional.
- Keys missing from some objects produce empty cells in those rows.
Quick Facts
| Tool name | JSON to CSV |
| Category | Data Converters |
| Price | Free โ no account, no trial, no watermark |
| Where it runs | Entirely in your browser (client-side) |
| Files uploaded | None โ your data never leaves your device |
| File size limit | None imposed; limited only by device memory |
| Works offline | Yes, once the page has loaded |
| Platforms | Windows, macOS, Linux, Android, iOS |
Frequently Asked Questions
What happens to nested JSON objects?
CSV is a flat format with no way to express nesting. Nested structures are either flattened into dotted column names or serialised into a single cell as text, depending on their depth.
Why does my CSV look wrong in Excel?
Usually a regional delimiter issue โ some locales expect semicolons rather than commas. Import via Data > From Text rather than double-clicking, and specify the delimiter explicitly.
Can I convert a single JSON object?
Wrap it in square brackets to make it a one-element array. CSV needs rows, and a bare object represents only one.
How are commas inside values handled?
They are quoted according to standard CSV escaping rules, so the file parses correctly in every spreadsheet application.