100% Client-Side • Free • Zero Server Transfer

JSON to CSV Converter Online

Free JSON to CSV converter online. Flattens nested objects into dot-notation columns, auto-detects headers and exports RFC 4180 CSV, TSV or Excel files.

JSON InputInput

CSV OutputOutput

In short
To convert JSON to CSV, paste an array of objects into the left pane. Every unique key across all objects becomes a column header, nested objects flatten to dot-notation columns such as user.name, and the RFC 4180 result appears on the right ready to open in Excel or Google Sheets.
Converting JSON to CSV means flattening a tree into a grid. JSON2X scans every object in your array to build the full column set, flattens nested objects into dot-notation headers such as address.city, and quotes and escapes fields according to RFC 4180 so the result opens cleanly in Excel, Numbers, and Google Sheets. The file is generated in the browser and downloaded directly from it.
How are nested objects handled?
By flattening. CSV has exactly two dimensions, so a nested object has to become additional columns: {"user":{"name":"Ada"}} becomes a column named user.name. Dot notation keeps the original path recoverable, which means the conversion is reversible — feed the CSV back through CSV to JSON and the nesting can be rebuilt. Arrays nested inside a row have no natural column representation and are serialised as a JSON string in a single cell.
What happens when objects have different keys?
The header row is the union of all keys, not the keys of the first object. A record that lacks a column simply gets an empty field there. This matters for real API data, where optional fields are common — a converter that samples only the first row silently drops columns. If you want to know which records are missing which fields before you convert, open the document in the tree viewer first.
Will the CSV open correctly in Excel?
The output follows RFC 4180: fields containing a comma, a double quote, or a line break are wrapped in double quotes, and embedded quotes are doubled. Output is UTF-8. Two Excel-specific caveats are worth knowing. Some Excel builds need a byte-order mark to detect UTF-8, so non-ASCII text can appear mangled on double-click — importing via Data → From Text/CSV and choosing UTF-8 avoids it. And Excel eagerly reformats values that look like dates or long numbers, which is why identifiers such as 00123 are best imported as text.
How to use the JSON to CSV
Takes under a minute. Nothing is uploaded — every step runs in this browser tab.
  1. Paste a JSON array
    Put an array of objects into the left-hand input pane. A single object is treated as a one-row table.
  2. Check the detected columns
    The header row is the union of every key seen across all objects, so records with missing keys still line up. Nested objects are flattened to dot notation.
  3. Review the CSV
    The right-hand pane shows the delimited result, with fields containing commas, quotes, or newlines quoted and escaped.
  4. Download for Excel
    Download the .csv file and open it in a spreadsheet, or copy the text straight into an existing sheet.
When to use it
  • Handing an API export to a colleague who works in Excel or Google Sheets
  • Loading JSON records into a BI tool or a database importer that only accepts CSV
  • Building a pivot table over data that arrived as an API response
  • Producing an attachment for a finance or ops report from a JSON extract
  • Turning a JSON log export into something you can filter and sort by hand
Step-by-step guides for this tool
Task-specific walkthroughs covering the most common ways this tool gets used.
JSON to CSV Converter: Flatten JSON Arrays to CSV InstantlyConvert JSON arrays to CSV spreadsheets online. Handles nested objects, custom delimiter, and header auto-detection. Free, 100% client-side, no upload required.JSON to Excel: Export JSON Arrays to Spreadsheet FormatConvert JSON to Excel format by exporting as CSV. Works with nested JSON objects, arrays, and custom delimiters. Opens directly in Excel and Google Sheets.Convert JSON to Excel / Google SheetsConvert JSON to CSV for Microsoft Excel, Google Sheets, and LibreOffice. Flatten nested arrays to spreadsheet-ready CSV with automatic columns.JSON to TSV ConverterConvert JSON to TSV online. Tab-separated output pastes straight into Excel and Sheets without an import wizard, and never collides with commas in your data.
Searches this page answers
  • json to csv online free
  • free json to csv converter
  • json to csv converter online
  • convert json to csv online
  • json to excel converter
  • json to tsv converter
  • convert json array to csv
  • flatten nested json to csv
  • json to spreadsheet
  • json to csv no upload
Frequently Asked Questions
How do I convert a JSON array into a CSV file?
Paste your JSON array of objects into the editor. The converter detects all unique column headers across all objects, flattens nested objects if desired, and generates standard RFC 4180 CSV.
How are nested JSON objects and arrays handled in CSV export?
You can enable "Flatten Nested Objects" to turn { user: { name: "Alice" } } into a column named user.name, or stringify sub-arrays as JSON strings within cells.
Can I open the generated CSV in Microsoft Excel or Google Sheets?
Yes. The downloaded .csv file is 100% standard RFC 4180 compliant with UTF-8 encoding, immediately opening into Excel, Numbers, and Google Sheets.
What is the maximum file size for browser CSV conversion?
The converter handles tens of thousands of rows smoothly within client memory.
Related Developer Tools
CSV to JSONParse CSV into JSON with type auto-detectJSON to SQLGenerate CREATE TABLE & INSERT statementsJSON to YAMLConvert JSON to clean YAML and vice versaJSON Multi-ConverterTS, Zod, Mongoose, SQL, OpenAPI, Schema & Mock
Last reviewed  by the JSON2X Engineering Team.