FixThatAppAll Tools
Developer

JSON to CSV Converter

Convert JSON arrays into downloadable CSV data.

How This Tool Works

The JSON to CSV Converter transforms a JSON array of objects into CSV format — ready for opening in Excel, Google Sheets, or importing into a database. The first row of the CSV output is the header row containing all unique keys from the JSON objects. Common uses: exporting API response data for analysis in a spreadsheet, converting database query results for reporting, and preparing data for import into systems that accept CSV.

How to Use

  1. Paste a JSON array of objects in field A — format: [{...}, {...}, {...}].
  2. Click Run. The CSV output appears with headers in the first row.
  3. Copy the CSV and paste into a text file saved as .csv, then open in Excel or Google Sheets.
  4. If objects have different keys, missing values in some rows will be blank in the CSV.

Common Questions

What if my JSON objects have different keys?

The converter uses all unique keys across all objects as the CSV header. Objects missing a key will have a blank value in that column. This matches the behavior of most database export tools.

How do I open the CSV in Excel with correct encoding?

If your data contains non-ASCII characters (accented letters, CJK): save as UTF-8 CSV, then in Excel use Data → Get Data → From Text/CSV and specify UTF-8 encoding during import. Double-clicking a UTF-8 CSV in Windows opens it in the default (Windows-1252) encoding and garbles special characters.

What is the difference between CSV and TSV?

CSV uses commas as delimiters; TSV (Tab-Separated Values) uses tabs. TSV is preferred when data values frequently contain commas (e.g. addresses, descriptions). Both are supported by Excel and most import tools.

Read the full guide →