Developer Tools

JSON to CSV

Convert a JSON array of objects into a CSV file you can open in Excel or Google Sheets.

Share:
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.

How to Use This Tool

  1. 1Paste a JSON array of objects into the input area. Example: [{"name": "Alice", "age": 30}]
  2. 2Click Convert to CSV to generate the CSV output.
  3. 3Preview the CSV in the output area.
  4. 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.