What is JSON to Excel/CSV Converter?

This tool converts JSON arrays of objects into CSV (Comma-Separated Values) format that can be opened directly in Microsoft Excel, Google Sheets, or any spreadsheet application. It handles nested objects by flattening them with dot notation, properly escapes special CSV characters, and includes a UTF-8 BOM for correct encoding in Excel.

How to Use

Paste your JSON array of objects into the input area
Choose your preferred delimiter (comma, semicolon, or tab) and whether to include headers
Click "Convert" to generate the CSV output
Copy the output or click "Download CSV" to save the file

Why Use This Tool?

Flattens nested JSON objects using dot notation (e.g., address.city)

Handles special CSV characters (quotes, commas, newlines) with proper escaping

Includes UTF-8 BOM for correct character encoding in Excel

Supports multiple delimiters for different regional Excel settings

Download directly as a .csv file for immediate use

Tips & Best Practices

Use semicolon delimiter for European Excel versions that use comma as decimal separator
The BOM (Byte Order Mark) ensures Excel correctly recognizes UTF-8 encoding
Nested objects are flattened with dot notation — {address: {city: "NYC"}} becomes address.city
Arrays of primitives are joined with commas; arrays of objects are serialized as JSON strings

Frequently Asked Questions

What is CSV format?

CSV (Comma-Separated Values) is a plain text format for tabular data. Each row is on a new line, and columns are separated by a delimiter (usually a comma). It is widely supported by spreadsheet applications like Excel and Google Sheets.

Why does my CSV look wrong in Excel?

If special characters appear garbled, the file may not be recognized as UTF-8. This tool adds a BOM (Byte Order Mark) at the beginning of the file to help Excel detect the encoding. Also, try using semicolon as the delimiter if your regional settings use comma as the decimal separator.

How are nested objects handled?

Nested objects are flattened using dot notation. For example, {"address": {"city": "NYC", "zip": "10001"}} becomes two columns: "address.city" and "address.zip".

What happens with arrays?

Arrays of primitive values (strings, numbers) are joined with commas into a single cell. Arrays of objects are serialized as JSON strings. You can further process these in your spreadsheet application.

Is my data sent to a server?

No, all processing happens entirely in your browser. Your JSON data never leaves your device.

JSON to Excel/CSV Converter