JSON ↔ CSV
Convert between JSON and CSV formats
How to use JSON ↔ CSV
- Choose the conversion direction: JSON to CSV or CSV to JSON.
- Paste your data into the input area.
- Select a delimiter if needed (comma is default).
- Click Convert to see the result. Copy or download the output.
When to convert between JSON and CSV
JSON and CSV are the two most common data interchange formats. JSON is structured and supports nesting, making it ideal for APIs and configuration. CSV is flat and tabular, making it ideal for spreadsheets and database imports.
Converting JSON to CSV is common when you need to open API data in Excel, import records into a database, or share data with non-technical colleagues. Converting CSV to JSON is common when preparing data for a web application or API.
This tool handles nested JSON by flattening objects with dot notation and properly escapes CSV fields containing delimiters or quotes.
Frequently Asked Questions
What JSON structure is supported?
The JSON to CSV converter expects an array of objects, like [{name: "Alice", age: 30}, {name: "Bob", age: 25}]. Each object becomes a row, and keys become column headers.
How are nested objects handled?
Nested objects are flattened using dot notation. For example, {address: {city: "NYC"}} becomes a column named "address.city".
Can I change the CSV delimiter?
Yes. You can choose comma, semicolon, tab, or pipe as the delimiter.
Is the data sent to a server?
No. Everything is processed in your browser. Your data never leaves your device.