JSON to CSV
See flatten and convert JSON arrays into CSV format. Perfect for importing data into Excel or Google Sheets.
Last updated: April 28, 2026
Waiting for input...Tool Settings
Nested objects are automatically flattened using dot-notation (e.g., "user.address.city"). This ensures your spreadsheet has a consistent column structure.
All processing happens locally in your browser. Large files are handled in memory and never uploaded to any server.
JSON to CSV
Transform your structured JSON data into a flat CSV format ready for spreadsheet analysis. Our converter intelligently flattens nested objects using dot-notation (e.g., 'user.name') and handles arrays of objects by creating a consistent header row based on all available keys in the dataset. When rows contain different fields, missing values are emitted as empty cells so every row lines up with the header. Arrays inside a row can be kept as JSON text, joined with a separator you choose, or expanded into indexed columns like 'tags.0'. Output is properly quoted and escaped, so commas, quotes, and line breaks inside values never break the table. You can pick the delimiter, decide whether to include a header row, and preview the result before downloading. Conversion runs locally in your browser.
Why This Tool Exists
What makes this useful — and why I built it this way.
Spreadsheet Ready Output: Convert list formats of JSON into grid CSV structures.
Auto Flatten Logic: Converts nested objects into clean database columns.
CSV Customizations: Set custom separators, line endings, and header formats.
Consistent Columns: The header is built from every key in the dataset, so differing rows still align.
Safe Escaping: Values containing commas, quotes, or line breaks are quoted correctly in the output.
When You'd Use This
Real situations where this tool saves the day.
Data Analysis: Convert database API outputs to open in Excel or Sheets.
Reporting Creation: Build flat reports from complex nested web databases.
Migration Prep: Prepare modern JSON feeds to import into legacy databases.
Survey Exports: Convert nested response objects into rows for pivot table analysis.
Database Loads: Produce flat files that match a table schema before running an import.
Using JSON to CSV
It's straightforward — here's how it works.
Paste an array of JSON objects into the converter.
Configure flattening options (depth, separators, and how arrays are handled).
Choose your delimiter and whether a header row is included.
Preview the CSV table to ensure columns are correct.
Download the .csv file for use in your spreadsheet software.
Questions People Ask
Honest answers about how this works.
How are nested objects handled?
Great question. Nested objects are flattened by default. For example, { 'person': { 'name': 'John' } } becomes a column named 'person.name'.
What happens to arrays inside a row?
You choose. Arrays can stay as JSON text in a single cell, be joined into one string with a separator such as a pipe, or be expanded into indexed columns like tags.0 and tags.1 using the width of the longest array.
Is my data sent to a server for conversion?
No. The JSON is parsed and the CSV is built inside your browser, then handed to you as a local download. Sensitive records, customer exports, and internal datasets are never transmitted or stored during conversion, and the page keeps nothing after you leave.
Will the CSV open correctly in Excel?
Yes. Fields containing commas, double quotes, or line breaks are quoted and escaped according to standard CSV conventions, and you can choose comma, semicolon, or tab delimiters to match your locale. The file downloads with a .csv extension ready to open.
Discover More Tools
Hand-picked utilities to speed up your workflow.