Home › Programmer & Developer Tools › JSON ↔ CSV Converter

JSON ↔ CSV Converter

Turn a JSON array into a spreadsheet-ready CSV: nested objects flatten to dot-notation columns, you choose exactly which columns to export, and the download opens cleanly in Excel. The reverse direction parses CSV (quoted fields included) back to a JSON array with optional type inference — all in your browser.

How to use JSON ↔ CSV Converter

  1. Paste a JSON array of objects — the CSV preview and the column chips appear instantly.
  2. Click column chips to exclude fields you don’t want; pick a delimiter (comma, semicolon, tab, pipe).
  3. Download the .csv (UTF-8 with BOM, so Excel shows accents correctly) or copy it. Switch direction for CSV → JSON.

Frequently asked questions

How do I convert JSON to CSV?
Paste a JSON array of objects and the CSV preview appears instantly. Pick the columns and delimiter you want, then download the Excel-ready .csv or copy it.
How do I convert CSV to JSON?
Switch the direction to CSV → JSON and paste your CSV (quoted fields with commas and newlines are supported) to get a JSON array, with optional type inference.
How is nested JSON handled in CSV?
Nested objects and arrays are flattened into dot-notation columns — {"address":{"city":"London"}} becomes an address.city column, and arrays get numbered like tags.0, tags.1.
Can I exclude some fields from the CSV?
Yes — every detected column appears as a chip above the editor; click to toggle it, or use All / None.
Why does my CSV open with broken characters in Excel?
Excel needs a byte-order mark to read UTF-8 — the downloads here include one, so accents and emoji display correctly.
Does CSV → JSON handle quoted fields with commas and newlines?
Yes — the parser implements the full CSV quoting rules ("" escapes, embedded delimiters and line breaks), and can infer numbers, booleans, and null while preserving leading-zero IDs as strings.

More Programmer & Developer Tools

  • JSON Validator — Validate, parse, and prettify JSON — load it from a URL or curl command, or convert a Python dict (single quotes, True/False/None) to JSON. Identifies syntax errors with precise line number reporting.
  • Code Beautifier — Automatically format your JavaScript, CSS, and HTML with customizable indentation and style rules.
  • Minifier — Reduce bundle sizes by removing whitespace, comments, and optimizing code structure for production.
  • SQL Formatter & Beautifier — Pretty-print and indent SQL queries across dialects (PostgreSQL, MySQL, T-SQL, BigQuery, and more) with configurable keyword casing.
  • XML Formatter — Beautify and validate XML with configurable indentation, or minify it to the smallest valid output — entirely in your browser.
  • JSON Diff — Compare two JSON objects (or Python dicts) structurally to spot added, removed, and changed keys — or switch to line and word mode for plain text and code.
  • RegEx Tester — Build and test regular expressions in real-time with syntax highlighting and match group visualization.
  • Base64 Converter — Quickly encode and decode strings or files to Base64 format for safe data transmission.