JSON to CSV
Convert a JSON array of objects into a CSV spreadsheet
JSON Input
CSV Output
JSON to CSV — Complete Guide & Instructions
MakeCard JSON to CSV flattens a JSON array of objects into a comma-separated spreadsheet you can open in Excel, Google Sheets or import into a database. Paste the array, press Convert, and the output appears with headers derived from the object keys — ready to copy or download as a .csv file. It is a fast bridge between API responses and spreadsheet work.
How to Use JSON to CSV
- 1 Paste your JSON array of objects into the JSON Input box — e.g. [{"name":"Asha","age":28}].
- 2 Click “Sample” if you want to test the converter with example data first.
- 3 Press “Convert to CSV”.
- 4 Review the generated CSV in the output card — headers come from object keys.
- 5 Click “Copy” or “Download .csv” to take the spreadsheet with you.
Key Features & Capabilities
- Converts arrays of flat JSON objects into properly delimited CSV rows.
- Header row generated automatically from object keys.
- Correct quoting of values that contain commas or quotes.
- One-click copy plus a real .csv file download.
- Sample data button and readable error messages for malformed JSON.
Supported Formats & Specifications
| Parameter | Specification |
|---|---|
| Input | JSON array of objects — [{"key":"value"}, …] |
| Output | RFC-style CSV text + downloadable .csv file |
| Headers | Derived from object keys automatically |
| Processing | Client-side conversion, instant for typical payloads |
Practical Everyday Use Cases
- Turning a REST API response into an Excel-readable report.
- Converting exported Firebase or MongoDB documents for spreadsheet analysis.
- Preparing product or contact JSON data for bulk CSV import tools.
- Sharing machine-readable records with colleagues who only use Excel.
- Quick sanity-viewing of a data export before writing conversion code.
Pro Tips for Best Results
- The input must be an array of objects — wrap a single object in [ ] brackets first.
- Keep object keys consistent across rows; missing keys simply produce empty cells.
- Flatten nested objects before converting — nested structures do not map cleanly to columns.
- After download, open in Excel via Data → From Text/CSV if characters look garbled (UTF-8 encoding).
Common Problems & Solutions
Check for trailing commas, single quotes instead of double quotes, or a bare object — the input must be a valid JSON array.
Objects with different key sets produce sparse columns; normalize the objects so every row shares the same keys.
Your regional Excel may expect semicolons — import via Data → From Text/CSV and choose comma as the delimiter.
Privacy & Security
100% Client-Side Execution
Conversion happens in your browser — pasted JSON and generated CSV data are never uploaded or stored.
Frequently Asked Questions
Everything you need to know about using JSON to CSV
Paste a JSON array of objects into the input, press Convert to CSV, then copy or download the result — the header row is built from the object keys automatically.
Yes — download the .csv file and open it directly, or use Excel's Data → From Text/CSV import to control encoding and delimiters.
This converter is designed for flat objects. Flatten nested fields first (e.g. "address.city") or they will not map cleanly to single columns.
Most failures come from invalid JSON — trailing commas, single-quoted strings or a non-array root. The error message points at the issue.
Related FreeToolsBazaar Tools
Ready to Use JSON to CSV Converter?
100% free, browser-based, and private. No installation, registration, or file upload to external servers required.
Start Using JSON to CSV