Handitab

JSON to CSV

Convert a JSON array of objects to CSV that opens in Excel or Google Sheets, flattening nested objects into dot-separated columns.

About JSON to CSV

JSON to CSV conversion turns a list of objects into a table with one row per object and one column per key. This tool flattens nested objects into dot-notation columns such as address.city, uses the union of all keys as the header, and leaves missing values empty. Arrays are written as JSON text in a single cell. Fields that contain the delimiter, quotes, or line breaks are quoted as in RFC 4180.

Also known as: JSON to CSV Converter, JSON to Excel/CSV.

How to use JSON to CSV

  1. Type or paste into the "JSON (array of objects)" box, or press "Use example" to try it with sample data.
  2. Set "Column delimiter" if the defaults do not fit.
  3. The result appears below and updates as you type.
  4. Copy the result with the copy button, or download it as a file where that is offered.

Questions about JSON to CSV

Why does Excel put all my CSV data in one column?

Excel uses the list separator from your regional settings. In many European locales that is a semicolon, so a comma-separated file is not split. Choose the semicolon delimiter here, or import the file through the Data tab.

Runs in your browser. Page last updated .

More encoding and data tools

All 28 encoding and data tools
JSON to XMLConvert JSON to indented XML with a root element name you choose, turning object keys into elements and arrays into repeated elements.Number Base ConverterConvert a whole number between binary, octal, decimal, hexadecimal, and base 36, with no size limit and support for negative values.Text to Hex ConverterConvert text to hexadecimal, showing each UTF-8 byte as two hex digits separated by spaces, ready to paste into code or a hex editor.TSV ↔ CSVConvert tab-separated TSV to comma-separated CSV or the other way around, with the input delimiter detected from the first line.TSV to JSON ConverterConvert tab-separated values (TSV) to a JSON array of objects, using the first row as keys and turning numeric cells into numbers.URL DecoderDecode a percent-encoded URL or query string back to readable text, turning %XX escapes and plus signs into their original characters.