JSON to CSV Converter (and YAML)

Convert JSON to CSV, CSV with comma, semicolon or tab separators to JSON, or export JSON-style YAML (output only). Data is converted in your browser.

What this tool does

Convert JSON object arrays to CSV, parse CSV into JSON, or export parsed data as YAML written in JSON-style flow syntax (valid YAML 1.2). YAML cannot be used as input. The supported JSON table model is a flat array of objects, not an arbitrary nested database export.

Practical use cases

  • Turn a small flat object list into a CSV table
  • Inspect a comma-, semicolon- or tab-separated CSV export as JSON
  • Export table data as JSON-style YAML that YAML 1.2 parsers accept

Example

Input: JSON [{"name":"Ada","role":"Editor"}]

Expected output: A CSV table with name and role columns and one data row

Limits to know

  • Nested objects and arrays are written into the CSV cell as JSON text
  • YAML is output only; it is written as indented JSON (flow style) rather than YAML block style
  • CSV does not reliably preserve every original JSON type; parsed CSV values are always strings
  • The CSV separator is detected only from the header line and output CSV always uses commas
  • Spreadsheet applications may interpret formula-like cells; review untrusted exports before opening them

Common problems

A comma creates an extra column

Use properly quoted CSV fields; embedded quotes must be escaped according to CSV rules.

JSON input is rejected

Provide valid JSON with a flat array of objects for table export; remove trailing commas and comments.

Frequently asked questions

What JSON structure can be converted to CSV?

An array of objects, such as [{"name":"Ada"}]. Every key found in any object becomes a column, missing values become empty cells, and nested objects or arrays are written into the cell as JSON text.

Does it read semicolon- or tab-separated CSV?

Yes. The separator is detected from the header line (comma, semicolon or tab), and quoted fields with commas, quotes or line breaks are supported. CSV output always uses commas.

Why are numbers in my JSON output in quotes?

CSV has no data types, so every value read from CSV becomes a string. The first row is used as the column names, which must be unique, and every row must have the same number of columns.

Can I convert YAML to JSON?

No. YAML is available only as an output. It is written in JSON-style flow syntax, which is valid YAML 1.2, rather than the indented block style.

Is my data uploaded?

No. Parsing and conversion run in your browser, and nothing is sent to a server.

Tool-specific privacy note

Conversion is performed in the browser. Avoid pasting production personal data into a shared device.

How to use this tool

  1. Select the source and target formats and paste data; the CSV separator is detected from the header line.
  2. Convert and inspect headers, quoting and data types.
  3. Copy the result and validate it in the receiving application.

Try a sample file

Sample JSON table

Contains two fictional rows. For CSV conversion, check the name and role columns.

Related tools

SQL Formatter

HTML Entity Encoder

User-Agent Parser

HTTP Status Explorer