JSON ⇄ CSV Converter

Q: How to handle nested arrays in JSON?

Use the Array path field to point to the exact location (e.g. data.users).

Q: Why does the CSV export include a UTF-8 BOM?

The BOM tells Excel the file is UTF-8 encoded, so accents display correctly.

Q: Is my data sent to a server?

No, everything is processed locally in your browser.

Bidirectional conversion with automatic flattening, table preview, and advanced options. 100% client-side.

📄 JSON

Drag & drop a JSON file here or click to select

Array path:

Flatten objects

📊 CSV

Drag & drop a CSV file here or click to select

Delimiter:

First row as headers

Null values:

Table Preview

Rows: 0 Columns: 0 Size: 0 bytes

No data

JSON / CSV Converter: Everything You Need to Know

This tool lets you easily switch between JSON (used by APIs) and CSV (Excel, Google Sheets) formats. With automatic flattening of nested objects, you can process complex data in one click.

Frequently Asked Questions

How to handle nested arrays in JSON?

Use the "Array path" field to point to the exact location of your array. For example, if your JSON structure is { "data": { "users": [ ... ] } }, enter data.users. The tool will automatically extract the target array.

Why does the CSV export include a UTF-8 BOM?

The BOM (Byte Order Mark) tells Excel that the file is UTF-8 encoded. Without it, Excel may display accents and special characters incorrectly. Our "Download CSV" option automatically adds this BOM for perfect compatibility with Excel.

How are null or empty values handled?

You can choose in the dedicated dropdown how to represent null, undefined, or empty strings during CSV → JSON conversion: empty string, "null", or zero.

Can I convert a CSV file with a delimiter other than comma?

Yes, you can choose from comma, semicolon, tab, or pipe. Automatic detection is also active: if you paste data without specifying, the tool tries to guess the delimiter.

Is my data sent to a server?

No, everything is processed in your browser. No data leaves your computer.