Convert JSON data to CSV format quickly and easily.
About JSON to CSV
APIs and NoSQL exports hand you JSON, but Excel, Google Sheets and most reporting tools want a flat CSV table. This converter takes a JSON array of objects, uses the keys of the first object as column headers and writes one CSV row per object, ready to open in a spreadsheet.
Paste the JSON into the box, type the output file name and click the button: the .csv file downloads straight away. Parsing is done by the browser's own JSON engine, so nothing is sent to a server and even large API responses stay on your machine.
How to use JSON to CSV step by step
Type the name of the output file (the .csv extension is added automatically).
Paste your JSON into the text area. It should be an array of objects; a single object is accepted and becomes one row.
Click "Convert and download CSV". If the JSON is not valid you get an error message instead of a file.
100% free and online: no payments, no software or extensions to install.
Privacy-first: processing happens in your browser, your data never leaves your device.
No sign-up: paste your data and get the result in one click.
Fast and reliable: handle small or large files in seconds, ready for Excel and other tools.
Common use cases
Turn the response of a REST API (Stripe, Shopify, HubSpot) into a CSV for a quick analysis in Excel.
Export a MongoDB or Firebase collection dump to a spreadsheet for a non-technical colleague.
Flatten a JSON list of products or users before importing it into a CRM that only accepts CSV.
Check the content of a JSON log file by viewing it as rows and columns.
Limits and tips
Columns come from the keys of the first object only. Keys that appear later but not in the first object are ignored.
Every string value is written with double quotes and numbers and booleans without them, because values are serialised with JSON.stringify. Null becomes an empty cell.
Nested objects or arrays are written as JSON text inside the cell; if they contain commas the row will have extra columns. Flatten nested data first if you need clean columns.
Lines are separated with CRLF (\r\n), which Excel on Windows expects.
Frequently asked questions
What is the difference between JSON and CSV?
JSON is a hierarchical text format with objects, arrays and typed values (string, number, boolean, null) used by APIs and configuration files. CSV is a flat table: one line per record, values separated by commas, no types and no nesting. Converting JSON to CSV means picking the keys as columns and writing each object as a row.
My JSON is an object, not an array. Does it work?
Yes. A single object is wrapped into an array and produces a header row plus one data row. An object whose values are themselves objects (for example a map keyed by id) will produce one row with the nested objects serialised as text.
Why does Excel show all my data in one column?
Excel in Spanish, French or German regional settings expects a semicolon as separator, but this file uses commas. Open the CSV with Data > From Text/CSV and choose comma, or run the result through the CSV to Delimited tool to switch to semicolons.
Does it handle JSON with nested arrays?
Only partially. Nested arrays and objects are kept as JSON text inside a single cell. If you need each nested field as its own column, flatten the structure first, for example with a small script or a JSON flattening library.
Is there a size limit?
The limit is your browser's memory. Files of several tens of megabytes convert in a few seconds on a modern laptop; for hundreds of megabytes a command-line tool such as jq or Miller is a better fit.
Related guides
Best free online CSV to JSON converters in 2026 (tested) — We compared six free CSV to JSON converters: CSV Creator, CSVJSON, ConvertCSV, TableConvert, Online CSV Tools and Mr. Data Converter. Privacy, quoting, nested output, limits.
Related tools
Other free utilities you may find useful
CSV to JSON — Convert CSV data to JSON format (array of objects).
Excel to CSV — Convert an Excel workbook (.xlsx, .xls, .ods) to UTF-8 CSV, choosing the sheet and the delimiter (comma, semicolon or tab).
Fixed-Width to CSV — Transform fixed-width text into a well-structured CSV file.