EN TR
  1. Home
  2. Data converter
  3. JSON to CSV

Convert JSON to CSV

Counter JSON → CSV
Drop your files here .json

    Convert API data to CSV to review or report on it in Excel; nested fields open out into their own columns.

    • Free
    • No sign-up
    • Batch conversion

    Why convert JSON to CSV?

    To convert JSON files to CSV, drop them on the counter above. JSON is written for machines; it is hard to open in a spreadsheet or share with non-technical people. Nearly every program, database, bank and e-commerce system can import CSV.

    Most files convert in seconds: no queue, no email address, and the CSV result saves straight to your computer or phone.

    How to convert JSON to CSV

    1. Add your JSON files

      Drag your JSON files onto the counter or pick them with Choose files. You can add several at once.

    2. Check the settings

      The defaults suit most cases. Change quality, size or other options if you like; after a change, one click converts again.

    3. Conversion starts by itself

      Each file is converted to CSV and its row is stamped CONVERTED.

    4. Download your CSV file

      Get the file with Download. With several files you can download them all as one ZIP.

    JSON vs CSV

    PropertyJSONCSV
    Full nameJavaScript Object NotationComma-Separated Values
    TypeDataSpreadsheet
    Multiple sheetsNoNo
    Nested structureYesNo
    Plain textYesYes
    Created byDouglas Crockford (RFC 8259)RFC 4180
    Year2001—
    Extensions.json.csv
    MIMEapplication/jsontext/csv

    About the formats

    JSON

    JavaScript Object Notation

    JSON is the lightweight text format web services and apps use to exchange data. It nests objects, arrays, numbers and strings.

    All JSON conversions

    CSV

    Comma-Separated Values

    CSV stores each table row as a line of text, with cells separated by commas or semicolons. Nearly every program and database can import and export it.

    All CSV conversions

    Frequently asked questions

    Is converting JSON to CSV free?

    Yes, completely free. No account, no daily limit, no watermark and no queue.

    Does it work on a phone?

    Yes. It works on iPhone, iPad and Android, with no app to install.

    Is there a file size limit?

    There is no size limit set by us. Files of hundreds of MB convert too; very large files take longer and are handled more comfortably on a computer than on a phone.

    Other conversions
    Family Give → Get What you gain
    CSV JSON API-ready data
    JSON XLSX formulas and many sheets
    JSON YAML readable config file
    JSON XML for enterprise integrations
    JSON TOML strictly typed config
    XLSX CSV imports into any system · Excel sheets carried over
    TSV CSV imports into any system · tab-separated data read
    XML CSV imports into any system · tags and attributes kept
    XLS CSV imports into any system · old Excel file read
    ODS CSV imports into any system · LibreOffice sheet read