Convert JSON to CSV Online
Convert JSON data to CSV for spreadsheets, reporting, and import tools. The standard conversion runs in the browser and turns rows into comma-separated columns. It is free, supports batches, and keeps your data local unless a server fallback is needed.
Convert .JSON to .CSV
Select a file to begin. Processing details and limits are listed below.
How to convert JSON to CSV
- 1
Add JSON files
Drop a .json file into the uploader. The browser parses the top-level array or single object.
- 2
Convert rows to columns
Run the conversion. Flat keys become columns, and nested objects are serialized into cell text.
- 3
Download the CSV
Download the CSV and open it in a spreadsheet. Check column order and nested values before importing.
JavaScript Object Notation vs Comma-separated values
| Spec | JavaScript Object Notation | Comma-separated values |
|---|---|---|
| MIME type | application/json | text/csv |
| Format type | data | data |
| Standard | ECMA-404 and RFC 8259 | RFC 4180 |
| First release | 2001 | 2005 (RFC 4180); earlier usage predates the RFC |
| Browser support | All current major browsers | Text display and browser spreadsheet apps |
| Contents | Text-based data interchange format with objects, arrays, strings, numbers, booleans, and null. | Plain-text rows and columns separated by a delimiter, usually commas, with optional quoting and a header row. |
About JavaScript Object Notation
Readable, language neutral, easy to parse, and the default format for most web APIs. No comments or binary data, no schema by itself, and large nested documents can be hard to edit by hand.
Format referenceAbout Comma-separated values
Simple, human-readable, small, and supported by virtually every spreadsheet and database tool. No standard type system, delimiter and quoting conventions vary, and nested or hierarchical data does not fit naturally.
Format referenceWhy convert JSON to CSV?
- Open API output or exported JSON in Excel, Numbers, LibreOffice, or Google Sheets.
- Hand tabular data to a colleague who needs a spreadsheet rather than a code file.
- Import JSON records into a database or reporting tool that accepts CSV.
- Create a compact review file for a dataset without writing a parser.
Will quality change?
There is no image or audio quality loss, but structure can change. A JSON array of flat objects maps cleanly to rows and columns. Nested objects are serialized into cell text, arrays may be flattened into a cell representation, and the key order determines column order. JSON-specific types such as null and nested structures may not survive as native spreadsheet types.
Processing and limits
- Processing
- Browser first, server fallback
- Engine
- Browser JavaScript with Papa Parse
- Maximum size
- Browser conversion is limited by available memory. The server fallback accepts MP3 uploads up to 100 MB per file.
- Batch support
- Yes, multiple JSON files can be queued.
- Quality controls
- No quality slider. The main variable is how nested objects and arrays are represented in CSV cells.
The JSON is read and converted in the browser. Rows are created from the top-level array, objects become columns, and nested objects are stringified for the cell. If a server fallback is needed, the structured-data converter handles the same transformation.
- Nested objects are stored as serialized text, not as separate relational tables.
- Deeply nested arrays can produce unwieldy cells or lose the original hierarchy.
- CSV cells do not preserve JSON types such as null, nested booleans, or object identity.
Platform compatibility
CSV opens in Excel, Numbers, LibreOffice Calc, Google Sheets, database import wizards, and most analytics tools. That makes it a practical bridge between JSON APIs and spreadsheet users.
When not to convert
- Use JSON or NDJSON when the destination needs nested structures or strict type fidelity.
- Do not flatten a hierarchical dataset if relationships between records must remain explicit.
- For very large datasets, use a database import or streaming tool rather than a browser conversion.
Frequently asked questions
- Can nested JSON become proper CSV columns?
- Nested objects are serialized into cell text rather than expanded into multiple relational tables. For deep hierarchies, normalize the data before converting.
- Does JSON to CSV lose data types?
- CSV is text-based, so numbers, booleans, and null values are written as text. Spreadsheet software may infer types differently when it opens the file.
- What JSON shape works best?
- An array of flat objects with consistent keys produces the cleanest table. A single object becomes one row, and mixed shapes can produce sparse columns.
- Is the JSON uploaded to a server?
- The browser path keeps the standard conversion local. If the local parser cannot complete, the structured-data server fallback can process the file over HTTPS.
- Can I convert multiple JSON files?
- Yes. Queue multiple files and download the resulting CSV files individually or as a ZIP.
- Why are some cells empty?
- Different objects may have different keys. CSV needs one header row, so missing keys become empty cells in the affected rows.