Skip to main content
Developer Tool

JSON/CSV Converter

Turn a JSON array into a spreadsheet-ready CSV, nested fields flattened into columns, or a CSV into JSON, as you type.

Direction
Delimiter
Input
Result

The result will appear here

Learn more

JSON and CSV: what to know

From an API to a spreadsheet

Export a list of orders, users or products from an API and open it in Excel or Google Sheets, or turn a spreadsheet export into JSON for a script or a fixture. Each object of the array becomes a row and each key a column.

Nested data, delimiters and Excel

Nested objects are flattened into columns named with dots (address.city), arrays are written as JSON text in their cell. Choose ; as the delimiter if your Excel uses French or other European settings; the downloaded file starts with a UTF-8 marker so accents survive. “Protect for Excel” stops cells beginning with =, + or @ from running as formulas.

How it works

JSON/CSV Converter in 3 steps

  1. Paste your data

    Paste your JSON array or CSV data into the input panel. Choose the conversion direction using the toolbar.

  2. Choose direction

    Select JSON → CSV or CSV → JSON. The row count is displayed as you type.

  3. Copy the result

    The converted output appears instantly. Click the copy button to copy it to your clipboard.

Practical guides

Get the most out of JSON/CSV conversion

How it works

JSON and CSV are two fundamental data formats. JSON is used for APIs and structured data, while CSV is the universal format for spreadsheets, databases, and data import/export.

This converter lets you switch between both formats instantly, which is useful for preparing API data for spreadsheets, importing CSV data into applications, or transforming datasets.

Quick & easy

Privacy & security

This converter runs entirely in your browser. No data is ever sent to a server — the conversion happens locally using JavaScript.

Customer and order exports stay on your device: the conversion runs in your browser.

Runs in your browser
Frequently asked questions

JSON/CSV Converter — FAQ

Everything you need to know about converting JSON and CSV