MyKit.tools

JSON to CSV Converter

Convert JSON arrays to CSV format online. Handles nested objects with dot notation, supports comma/tab/semicolon delimiters. Copy or download the CSV.

When to Convert JSON to CSV

Convert JSON to CSV when you need to open data in a spreadsheet, import records into a database, generate reports, or share structured data with people who work in Excel or Google Sheets. CSV is the universal tabular format that virtually every data tool understands.

JSON is great for APIs and web applications, but most business users and analysts prefer working with rows and columns. Converting to CSV bridges the gap between developer-friendly JSON and the spreadsheet workflows that drive reporting, accounting, and data analysis across every industry.

How Nested JSON Objects Are Handled

Flat JSON arrays of objects convert cleanly into rows and columns. Each object becomes a row, and each key becomes a column header. Nested objects are flattened using dot notation, so an address object with a city field becomes a column called address.city.

Arrays nested inside objects are joined into a single cell value separated by semicolons. Deeply nested structures with three or more levels are serialised as JSON strings within the cell. For best results, flatten complex nested data before converting, or restructure your JSON so each record is a simple key-value object.

Delimiter Options Explained

DelimiterCharacterBest For
Comma,Standard CSV, Excel, Google Sheets, most tools
Tab\tTSV files, pasting into spreadsheets, avoiding comma conflicts
Semicolon;European locales where commas are decimal separators
Pipe|Data with commas and semicolons in values

Frequently Asked Questions

What JSON structures convert best to CSV?

An array of flat objects with consistent keys converts perfectly. For example, [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}] produces a clean two-column CSV. Objects with varying keys still work, but missing values become empty cells. Deeply nested or irregular JSON may need restructuring first.

How are special characters handled in the output?

Values containing the delimiter character, double quotes, or newlines are automatically wrapped in double quotes following the RFC 4180 CSV standard. Double quotes inside values are escaped by doubling them. This ensures the CSV can be parsed correctly by any compliant reader.

Is my data processed on my device?

Yes. The conversion runs entirely in your browser using JavaScript. No data is uploaded to any server. Your JSON stays on your device.

Related Tools