Convert JSON arrays and objects into formatted CSV or TSV with automatic header detection.
Loading tool
About JSON to CSV
Convert a JSON array of objects, a single object or an array of arrays into CSV or TSV. Columns are collected from every row, nested objects can be flattened into dot-path columns like address.city, and arrays can be joined, split into indexed columns or kept as JSON strings. Fields containing the delimiter, quotes or line breaks are quoted RFC 4180 style, and a table preview shows the result before you download it.
Common uses
- Open an API response in Excel or Google Sheets
- Export a JSON data dump as TSV for pasting into a spreadsheet
- Flatten nested JSON records into columns for analysis
- Produce semicolon-delimited CSV for locales that use a comma as the decimal separator
FAQ
- How are nested objects converted to CSV?
- With flattening on, each nested key becomes its own column named by its path, such as address.city. With flattening off, the nested object is written into one cell as a JSON string.
- What if objects have different keys?
- The header is the union of keys across all rows, in the order they first appear. Rows that lack a key get an empty cell in that column.
- Will Excel open the CSV correctly?
- Usually yes. If special characters look wrong or lines run together on Windows, try the CRLF line ending option, or use a semicolon delimiter if your Excel locale expects one.