NextTool

JSON to CSV

How to use

Flattens a JSON array of objects into CSV rows, automatically building a header from the union of every object's keys. Paste your JSON array and download the resulting CSV.

Excel & CSVLocal only

Step 2 of 3: Convert

  2. 2
  3. 3

Step 2 of 3 · Convert

JSON array of objects

Output delimiter

CSV output

When to use this
  • Turning an API response into a CSV file for a spreadsheet-based report
  • Exporting JSON test data into a format QA or business teams can review in Excel
  • Converting a JSON dataset into CSV for import into a BI or analytics tool
  • Flattening application logs stored as JSON objects into a tabular file for auditing

Free and private. Everything runs on your own device, with no account and no uploads.

This tool flattens a JSON array of objects into CSV rows, automatically detecting all unique keys across the array to build a complete header row, even if some objects are missing certain fields. It is useful for turning an API response or exported JSON dataset into a spreadsheet-friendly CSV file. The conversion is done entirely in your browser using JavaScript's built-in JSON parser.

No, the output is a plain CSV text file, not a binary Excel workbook; you can open it in Excel, but it is not the native .xlsx format.

The tool automatically collects every unique key across all objects to build the header row, leaving cells blank where a given object lacks that key.

Nested values are converted to their JSON string representation inside the cell since CSV has no concept of nested structures.

An error message is shown explaining that the input could not be parsed, so you can correct the syntax.

How it works
  1. 1

    Paste your JSON array

    Enter a JSON array of objects into the input textarea.

  2. 2

    Choose the output delimiter

    Pick comma, tab, pipe, or semicolon for the resulting file.

  3. 3

    Review the generated CSV

    Check that all fields and rows converted as expected.

  4. 4

    Copy or download the CSV

    Use the copy button or save the .csv file to your device.

More in Excel & CSV
CSV Viewer
View and browse CSV files in a clean table layout in browser
CSV Editor
Edit CSV data in an interactive spreadsheet-style table editor
CSV Cleaner
Remove extra spaces, fix encodings, and sanitize CSV data automatically
CSV to JSON
Convert CSV files to JSON arrays with configurable key mapping
Read about this
YAML, JSON and TSV: picking a format for config and interchange4 minThe JSON errors everyone hits, and what the spec actually says3 minConverting CSV to JSON without losing your data3 min
Pro tips
  • ·If your objects have inconsistent keys, check the header row afterward, missing fields just show up as blank cells, not errors.
  • ·Nested objects and arrays are stringified into the cell as-is, so flatten deeply nested data yourself first for cleaner columns.
  • ·Validate your JSON is a proper array of objects (not a single object or a string) before pasting it in.