Subformer
Free · No signup · Runs in your browser
JSON
CSV

JSON to CSV Converter

Flatten a JSON array of objects into a CSV file - paste into Excel, Google Sheets, or any spreadsheet tool.

Why convert JSON to CSV?

JSON to CSV is the conversion of choice when you have structured data from an API and need to share it with someone who lives in Excel. Sales people, finance teams, and clients all expect CSVs they can open in their favorite spreadsheet program. This page converts in one click - no scripting required.

The input must be a JSON array of flat objects (records). We collect the union of keys to form the header row, then emit each record with proper CSV quoting. Nested objects and arrays become stringified JSON in their respective cells, which Excel will display as raw text. For truly nested data, flatten it first in your script. Everything stays in your browser.

JSON

About JSON

JSON (JavaScript Object Notation) is the lingua franca of structured data on the web. Arrays, objects, strings, numbers, booleans. Read by every modern programming language.

CSV

About CSV

CSV (Comma-Separated Values) is the simplest tabular format - plain text rows of comma-delimited values. Read by every spreadsheet program, scripting language, and data tool ever made.

How to convert JSON to CSV

  1. 01

    Drop your JSON file

    Drag a JSON onto the converter above, or click the box to pick one from your device.

  2. 02

    CSV is already selected

    We've preselected CSV as the output format. Change it from the dropdown if you want a different target.

  3. 03

    Convert and download

    Click Convert and wait for the progress bar to finish. Download the CSV when it's ready.

JSON to CSV FAQ

See all formats →