Skip to main content
ToolsBay

Runs in your browser — nothing is uploaded · verify

JSON to CSV — free, and it runs in your browser

Flatten a JSON array of objects into CSV rows.

  • Every key found anywhere in the array becomes a column, so no record loses a field.
  • Nested objects are flattened into dotted column names rather than dropped.
  • Values containing commas, quotes or newlines are escaped correctly.

JSON input

Tab indents · Esc then Tab to leave1 line

CSV output

1 line

  • 70 tools

    Free, with no account and no watermark

  • 0 bytes

    Of your files or text uploaded — this tool runs in the tab

  • No queue

    The work happens in this tab, not in a line behind other users

Three steps, nothing to install

JSON to CSV in three steps

  1. JSON123456Paste it in — it never leaves the tab

    Paste the JSON array

    An array of objects — the shape almost every API returns for a list.

  2. JSONCSVConverted on your own device

    Flatten it into rows

    Every key found across the records becomes a column, so a record missing a field gets an empty cell rather than shifting the row.

  3. Copy CSV

    Take the CSV

    Copy it, or download a .csv that opens directly in Excel, Numbers or Sheets.

Why use JSON to CSV

  • Escaping done right

    A value containing a comma, a quote or a line break will break a naively-written CSV. Fields are quoted and doubled per RFC 4180 so the file opens correctly.

  • Parsed, not pattern-matched

    The input is read with a real parser and the output is written from what it found, rather than by rewriting the text with regular expressions.

  • Your text stays in the page

    What you paste is not transmitted or stored, so an API response full of customer records, a token or an internal query never leaves your machine.

Frequently asked questions

Yes. A bare object is treated as a single row. Many converters reject anything that is not an array, which is a common source of confusion when you have one record.

Turning JSON records into a spreadsheet

JSON is a tree; CSV is a grid. Converting between them means deciding what to do with everything that does not fit in a grid, and those decisions are where converters differ.

This one flattens nested objects into dotted columns, keeps arrays whole as JSON inside a cell, and builds the header from the union of all keys so records with different shapes still line up. Values are quoted per RFC 4180 — a field containing a comma, a quote or a line break is wrapped in quotes, and embedded quotes are doubled — so the output opens correctly in Excel, Google Sheets and Numbers.

Choosing a delimiter

Comma is the default and the standard. Semicolon matters in practice because Excel in many European locales, where the comma is the decimal separator, expects it — open a comma-delimited file there and every row lands in one column. Tab-separated output avoids the question entirely and is the safest choice for data full of punctuation.

To inspect or repair the JSON before converting, use the JSON formatter or validator. For XML output instead, use JSON to XML.

Often used alongside

  • JSON Formatter

    Pretty-print JSON with the indentation you choose, or minify it.

  • JSON to XML

    Convert JSON structures into equivalent XML markup.

  • XML Beautifier

    Format, minify and check XML without mangling CDATA or attributes.

  • XML to JSON

    Convert XML documents into readable JSON.

  • Regex Tester

    Test regular expressions live with match highlighting and groups.

  • SQL Formatter

    Indent and align SQL for PostgreSQL, MySQL, SQLite, BigQuery, Snowflake and SQL Server, with keywords capitalised.

Related guides

More tools

70 tools, none of which want your file

Everything this tool does happens in the page you are looking at. No account, no upload, no watermark.

Browse all toolsRead the guides