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.

When to convert JSON to CSV

JSON to CSV conversion is most useful when passing API response data to business stakeholders who work in Excel, when importing data into a database via bulk CSV load, or when visualising data in a tool (Google Data Studio, Tableau) that expects flat tabular input. The conversion works well for flat arrays of objects; nested or irregular JSON requires flattening decisions.

API to spreadsheet — convert JSON API responses to CSV for Excel analysis by non-technical colleagues
Database import — MySQL LOAD DATA INFILE and PostgreSQL COPY expect CSV format
Data visualisation — Tableau, Power BI, and Google Looker Studio prefer flat CSV over nested JSON
Flat vs nested — arrays of simple objects convert cleanly; nested objects require choosing a flattening strategy

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.

Related tools

JSON Formatter CSV to Table JSON ↔ YAML XML Formatter