JSON Input
CSV Output
Frequently asked questions
When would I convert JSON to CSV?
JSON is great for APIs but hard to analyse in spreadsheet tools. Converting to CSV lets you open data in Excel, Google Sheets, or import it into databases like PostgreSQL and MySQL. It is also the standard format for data science workflows in Python and R.
What happens to nested objects in JSON to CSV conversion?
Nested objects are flattened using dot notation. For example, {"address": {"city": "London"}} becomes an address.city column. Arrays of primitives are joined into a single cell, while arrays of objects use the first item's keys as column headers.
What delimiters can I use?
The most common delimiter is a comma (CSV), but tabs (TSV), semicolons, and pipes are also supported. Semicolons are common in European locales where commas are used as decimal separators. Tabs are useful when values might contain commas.