Convert JSON to CSV online

Why convert JSON to CSV

JSON is the native format of APIs and developer tools: it is machine-readable, hierarchical and compact. CSV is what analysts, accountants and product managers actually open every day in spreadsheets. When data arrives as JSON — from an API call, a webhook export or a no-code platform — converting it to CSV makes it immediately usable without writing any code.

Typical scenarios: product catalog from an e-commerce API, user list from a CRM, order export from a SaaS platform, log lines from a monitoring tool, or form submissions from a no-code backend.

Structure of a convertible JSON

The most reliable input is an array of objects where every object shares the same keys. Each object becomes one CSV row; each key becomes a column header.

[{"name":"Alice","age":30,"city":"London"},
 {"name":"Bob","age":25,"city":"Paris"}]

Produces:

name,age,city
Alice,30,London
Bob,25,Paris

If your JSON has a wrapper key (data, results, items, records), the converter extracts the inner array automatically.

Nested objects and dot notation

APIs frequently return nested objects. When flattening is enabled, each sub-property becomes a column using dot notation — readable and unambiguous.

[{"user":{"name":"Alice","email":"alice@example.com"},"order":{"total":49.9}}]

Flattened output:

user.name,user.email,order.total
Alice,alice@example.com,49.9

Choosing the right delimiter

The default comma works for most English-locale spreadsheets. Switch to semicolon when your version of Excel uses a comma as the decimal separator (common in France, Germany, Belgium). Use tab when field values contain commas — addresses, descriptions, prices — to avoid quoting conflicts.

• Comma — standard, works in Google Sheets and most CSV parsers.
• Semicolon — European Excel, SAP exports, accounting software.
• Tab — values that contain commas, copy-paste from spreadsheets.

Common mistakes to avoid

• Invalid JSON — missing quotes around keys, trailing commas, single quotes instead of double quotes.
• Empty array — produces a header row only, no data rows.
• Single object — valid, but produces only one CSV row. Wrap it in an array if you expect multiple rows.
• Inconsistent keys — objects with different keys produce sparse columns with many empty cells.

How to do it with Flowfiles

1. Open the JSON CSV tool.
2. Paste your JSON in the source editor.
3. Keep the JSON to CSV mode selected.
4. Enable flattening if your JSON has nested objects.
5. Choose comma, semicolon or tab depending on your target app.
6. Convert, then download or copy the CSV.