JSON to CSV Converter — Download as CSV

Delimiter

Nested objects

Filename

JSON input

0 bytes

Preview

About the JSON to CSV Converter

JSON (JavaScript Object Notation) is the standard format for APIs and web services, but spreadsheet tools like Excel, Google Sheets, and data analysis libraries expect flat CSV files. This converter bridges the gap — paste any JSON array of objects and get a properly formatted CSV ready to open in any spreadsheet application.

Supported input

Array of objects — the most common API response format: [{"key":"value"}, ...]
Nested objects — flattened to dot-notation columns (address.city) or kept as JSON strings
Mixed keys — if objects have different keys, all unique keys are collected as headers; missing values become empty cells

Delimiter options

Standard CSV uses commas, but some locales (particularly European countries) use semicolons to avoid conflicts with decimal notation. Tab-separated values (TSV) are useful for pasting directly into spreadsheets. Pipe-separated format is common in data pipelines.

Privacy

All conversion runs locally in your browser using JavaScript. Your JSON data is never uploaded to any server.

Frequently Asked Questions

What JSON structure works with this converter?

The converter expects a JSON array of objects, where each object represents a row. All objects should share the same keys, which become the CSV column headers. For example: [{"name":"Alice","age":30},{"name":"Bob","age":25}].

How are nested objects handled?

Nested objects are flattened using dot notation. For example, a nested key like address.city becomes a column named address.city in the CSV output. Arrays within objects are serialised as JSON strings in the cell. You can also choose "Stringify" mode to keep all nested values as raw JSON strings.

Can I change the CSV delimiter?

Yes. The tool supports comma (standard CSV), semicolon (common in European locales), tab (TSV format), and pipe-separated values. Choose the delimiter before converting.

Is my data sent to a server?

No. All processing happens entirely in your browser using JavaScript. Your JSON data never leaves your device.

What happens if my JSON has inconsistent keys?

The converter collects all unique keys across every object in the array and uses the full union as headers. Missing values for a given row are left as empty cells in the CSV.

Text & Dev tools

JSON Formatter CSV to Table PHP Unserializer URL Encoder Hash Generator Case Converter Text Diff JSON to CSV