JSON to CSV Converter

Convert a JSON array of objects into an Excel-friendly CSV with automatic column headers.

Runs in your browser Free

Delimiter Include header row

JSON input

CSV

Processed locally in your browser.

Turn API data into a table

To analyse orders, users or products from an API in Excel, import them into Google Sheets or build a report, you need to convert JSON to CSV. This tool turns an array of objects into a table of rows and columns.

Smart conversion

Column headers are collected from every object; missing fields stay empty
Nested objects and arrays are kept as JSON text in the cell
Values with commas, quotes or line breaks are escaped correctly

Excel compatibility

Excel in many European locales uses a comma as the decimal separator and expects semicolon-separated CSV. Choose the semicolon separator so the file opens in the right columns.

How to use JSON to CSV Converter

Paste the JSON array of objects.
Choose the separator.
Check the CSV preview.
Download or copy the CSV.

Why use this tool?

Move API data into spreadsheets without writing code; your data stays in your browser.

FAQ

Will it open correctly in Excel?

Yes. In locales that use a comma as decimal separator, choose the semicolon separator.

Can I convert a single object?

The tool expects an array; wrap a single object in square brackets [ {...} ] to convert it.

Special characters look garbled in Excel.

Open the file with Excel's 'Data > From Text' import and choose UTF-8.

Related tools

Private

CSV to JSON Converter

Convert CSV data into a JSON array of objects, using the header row as keys.

Open tool

Private

JSON Formatter and Validator

Pretty-print messy or minified JSON and find errors with line and column details.

Open tool

Private

JSON Minifier

Remove all unnecessary whitespace from JSON for smaller, faster-to-transfer data.

Open tool

Private

Word Counter

Count words, characters with and without spaces, sentences, paragraphs and reading time instantly.

Open tool