Helpful Toolbox

JSON ↔ CSV Converter

Flip JSON into CSV or back again — no spreadsheets were harmed in the process.

📖 How it works & FAQ

What JSON to CSV is for

JSON is how most APIs, databases, and config files hand you data. CSV is what spreadsheets speak. This tool bridges the two: paste an array of JSON objects and get a clean CSV table you can open in Excel, Google Sheets, or Numbers — and paste a CSV back to get structured JSON for your code. It works both directions, so it doubles as a quick sanity check when a file won't import cleanly somewhere.

When you'd reach for it

Common moments: an API returned JSON and your boss wants it in a spreadsheet; you exported contacts or orders as CSV and need JSON for a script; you're eyeballing an API response and a flat table is just easier to scan than nested braces. It shines on the everyday shape — an array of flat objects like [{"name":"Ada","age":36},{"name":"Grace","age":45}] — where each object becomes a row and each key becomes a column header.

A worked example and a gotcha

Given two objects with keys name and age, you get a header row name,age followed by one line per object. A tip worth knowing: any value containing a comma, quote, or line break gets wrapped in double quotes, and internal quotes are doubled — that's the CSV escaping rule, and it's why a field like "Smith, Jr." stays in one column. The gotcha is nesting: if an object holds another object or array, there's no single flat column for it, so deeply nested JSON is best flattened before you convert.

How to use it

  1. Choose your direction — JSON to CSV, or CSV to JSON.
  2. Paste your data into the input box (for JSON, an array of objects works best).
  3. Click Convert. The result appears instantly, formatted and ready.
  4. Copy the output or download it, then open it in your spreadsheet or drop it into your code.

FAQ

What JSON shape does it expect?
An array of objects, where each object is one row. The union of all keys becomes your column headers, and missing keys are left blank in that row.
Does it handle commas inside my values?
Yes. Fields with commas, quotes, or newlines are quoted and escaped per the CSV standard, so they stay in a single column.
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser — nothing you paste is sent to a server or stored by us.
Is it free?
Yes, completely free and ad-supported, with no sign-up or limits.