JSON to CSV Converter
Paste a JSON array and download a clean CSV file ready for spreadsheets. Free to use without an account, email address, or payment. The result downloads immediately after processing.
Paste a JSON array and download a clean CSV file ready for spreadsheets.
Convert a JSON array of objects or arrays into a CSV file. Pick the delimiter and whether to include a header row. Handles unioned keys across rows so no column is silently dropped.
- Category: Text
- Availability: Free to use without an account, email address, subscription, or payment.
- Input: Entered in the browser
How it works
- Paste your JSON array into the editor.
- Pick the delimiter and whether to include a header row.
- Process and download the.csv file.
Use cases
- Turn an API JSON response into a CSV for a spreadsheet.
- Export a JSON dataset as CSV for a business analyst.
- Convert MongoDB or Firebase output to CSV for Excel.
- Prep a JSON list for import into a CRM that expects CSV.
Frequently asked questions
What JSON shape do I need?
A top-level JSON array. Each item can be an object (keys become column headers) or an array (positional values). Mixed objects/arrays in one input aren't supported.
What if my objects have different keys?
We take the union of all keys across the array, so a column that only appears in later objects still becomes a CSV column. Empty cells are written for rows that don't have that key.
Are special characters quoted correctly?
Yes. Values containing the delimiter, quotes, or line breaks are wrapped in quotes and internal quotes are doubled (the standard RFC 4180 behaviour).
Is there a size limit?
Up to 2 MB of JSON per conversion, plenty for most real-world exports.
Related tools
Using the interactive tool
Open the canonical HTML page to provide input and generate or download a result. This Markdown alternate contains the complete descriptive and instructional content, but it does not execute the interactive interface.