Skip to main content

JSON to CSV Converter

Turn a JSON array of objects into a CSV table — headers detected automatically from the object keys, values escaped properly, and a UTF-8 BOM added so Excel opens Japanese and Chinese text correctly. All in your browser, nothing uploaded.

How it works

The tool takes an array of flat objects and produces a CSV file with one header row plus one row per object. Keys are unioned across objects (missing keys become empty cells), and values containing commas, quotes, or newlines are quoted and escaped per RFC 4180.

Where this saves time

  • API exports: most APIs return JSON arrays; spreadsheets expect CSV. This is the bridge
  • LLM output: batch jobs and structured-output responses often arrive as JSON arrays — convert to CSV for review in Excel or Sheets
  • Ad-hoc analytics: dump JSON logs into a table, then pivot in any spreadsheet tool

Input rules

  • Top level must be a JSON array of objects (not an array of arrays, not a bare object)
  • Nested objects and arrays are stringified into single cells — flatten them first if you need columns
  • One output column per distinct key; order follows first appearance

Pair with the JSON formatter to validate your input first, and the Base64 encoder if the CSV must travel inside another payload.

For the full conversion guide, read How to Convert JSON to CSV.