JSON to CSV Converter Online — Excel Headers & Nested Values

Example: JSON array to CSV with column headers

Paste a JSON array containing objects with simple properties:

[
  {"name":"Vika","city":"Kyiv"},
  {"name":"Alex","city":"Lviv"}
]

The resulting CSV has columns for name and city, with one data row per object:

name,city
Vika,Kyiv
Alex,Lviv

Open the output in Excel or import it into another data tool. Check the import separator, encoding and column types rather than assuming your spreadsheet will guess them correctly.

How to convert JSON to CSV in the browser

1. Open the interactive JSON to CSV tool and paste valid JSON, beginning with an array of objects.
2. Choose comma, semicolon or tab as the output delimiter.
3. Run the conversion and review the generated header columns and escaped values.
4. Copy the CSV or download it. Import it with appropriate text data types in your target application.

The converter processes input locally in your browser tab. It does not send your JSON text to a separate conversion server. Keep confidential customer data out of examples shared in public places.

Nested JSON objects and arrays

JSON supports nested structures, whereas CSV stores a flat row of fields. When the JSON input has an object or array inside a property, the nested value is serialized into a JSON-formatted string inside the corresponding CSV cell. It is not automatically expanded into separate columns.

[
  {"id":"A1","details":{"country":"UA","active":true}}
]

If you need columns such as details.country and details.active, flatten the nested data according to your own schema before exporting, or use a purpose-built data transformation.

Why Excel shows unexpected values after import

Identifiers lose leading zeros

Values such as "000123" may be auto-converted by Excel to 123. Specify a text column type on import whenever those zeros carry meaning.

Commas inside CSV cells

CSV encodes special characters by quoting fields when needed; a value such as "Alex, Jr" must stay in one column. Do not split CSV text with a simple comma-based string split.

Semicolon or tab separators

Different Excel regional settings use different list separators. If CSV opens in one column, import the file with the correct separator or regenerate it using the selected delimiter.

Inconsistent object keys

Check columns when some JSON records omit properties or include unexpected fields. Decide in advance which keys your reporting system requires and confirm the generated header matches that schema.

Related JSON and Excel tools

Use the CSV to JSON converter for the reverse direction, or the JSON formatter to validate source syntax first. Need a tailored import/export process for many files? Request a quote for Excel data automation; submitting an inquiry is free.