JSON to CSV

Export JSON data to CSV format for easy analysis in Excel.

Conversion Settings

Delimiter

Nested Mode

Include Header

JSON Input

CSV Output

Usage

JSON vs CSV

JSONJSON (JavaScript Object Notation) is a lightweight data interchange format that supports nested objects and arrays, suitable for passing complex data structures between programs.
CSVCSV (Comma-Separated Values) is a simple tabular data format, one record per row, fields separated by commas, suitable for analysis in tools like Excel.

Nested Data Handling

Flatten: Connect nested object properties with . as column name, e.g. address.city.
JSON String: Serialize nested objects as JSON string in a single cell.
Ignore: Skip nested objects, keep only top-level fields.

Download & Encoding

Downloaded CSV files automatically include a UTF-8 BOM header to ensure Chinese characters display correctly in Excel. Supports custom delimiters (comma, semicolon, Tab, pipe) for different regional Excel settings.