JSON to CSV

Upload

CSV Output

Delimiter:,

Enter JSON on the left to auto-convert to CSV

Ready

CSV to JSON

PDF to Excel

Excel to CSV

JSON Formatter

HTTP Request Tester

Markdown to HTML

Features

Smart flattening: automatically expands multi-level nested JSON structures into 2D tables, supports custom expansion depth
Perfect Excel compatibility: supports adding BOM, completely solving Chinese character garbled text when Excel opens UTF-8 files
Custom delimiters: supports comma, semicolon, tab and other delimiters, meeting different systems' import needs
Formula escaping protection: automatically handles fields starting with equals signs, preventing Excel from misidentifying them as formulas
Local fast processing: pure browser-side computation, protecting sensitive business data and privacy

FAQ

What if the exported CSV file shows garbled text when opened in Excel?

This tool supports adding a BOM (Byte Order Mark) by default. When exporting a CSV file, check the 'Add BOM' option to perfectly solve the Chinese character display issue when Excel opens UTF-8 encoded files, ensuring data displays correctly.

How are nested objects or arrays in JSON handled?

The tool offers smart flattening options. You can choose to expand nested JSON objects or arrays into separate columns, or serialize them as JSON strings into a single cell, meeting different data processing and import needs.

Does it support custom delimiters like semicolons or tabs?

Absolutely. Besides standard comma separation, you can customize the delimiter to use semicolons (;), tabs, or other characters in the settings, perfectly adapting to CSV parsing standards in different regions or systems.