Developer Tools
JSON to CSV
Convert a JSON array of objects into a CSV file you can open in Excel or Google Sheets.
12 lines • 145 chars
Paste a JSON array of objects, keep line numbers visible, and convert or download CSV without leaving fullscreen mode.
Quick examples
CSV Output • 2 rows converted
name,role,city Aisha,Admin,Dubai Omar,Editor,Lahore
Usage notes
- Input must be an array of flat objects — nested objects are stringified.
- Headers are derived from the first object's keys.
- Download button creates a .csv file ready for spreadsheets.
Related pages
How to Use This Tool
- 1Paste a JSON array of objects into the input area. Example: [{"name": "Alice", "age": 30}]
- 2Click Convert to CSV to generate the CSV output.
- 3Preview the CSV in the output area.
- 4Click Download .csv to save the file, ready for Excel or Google Sheets.
Frequently Asked Questions
- What JSON format is required?
- The input must be a JSON array of objects. Each object represents one row, and the keys of the first object become the CSV column headers. Example: [{"name": "Alice"}, {"name": "Bob"}]
- How are nested objects handled?
- Nested objects and arrays are converted to their string representation in the CSV output. For best results, flatten nested data before converting.
- Does this handle special characters?
- Yes. Values containing commas, double quotes, or newlines are properly escaped according to the CSV specification (RFC 4180).
- Can I open the CSV in Excel?
- Yes. The downloaded .csv file can be opened directly in Microsoft Excel, Google Sheets, LibreOffice Calc, or any spreadsheet application.
- Is there a row limit?
- There is no strict limit, but very large datasets (tens of thousands of rows) may take a moment to process in the browser.