JSON to CSV Converter — Free Online, No Signup

Convert JSON to CSV online free. Turn JSON arrays into Excel-ready CSV instantly. No upload, no signup — processed locally in your browser. Free online.

How to use

  1. Fill JSON Input — Paste a JSON array of row objects into JSON Input, or use Load sample JSON to try the supplied data. A single object is not accepted.
  2. Read CSV Output — CSV Output changes automatically as you type. There is no Convert button. Correct syntax errors before checking headers and rows.
  3. Check the columns — Compare the output with your original records. Look for blank cells, nested values and commas that might produce unexpected columns in a spreadsheet.
  4. Copy or Download — Use Copy to take the output as text, or Download to save converted.csv. Open the file in your destination program and check how it imports values.

Frequently asked questions

How are columns ordered?

Keys are collected across rows in first-seen order. JavaScript orders integer-like object keys numerically within each object. Later new keys are added as further columns.

What happens to missing values?

Missing keys, undefined values and null become empty cells. A false boolean becomes false, and a zero becomes 0; they are not treated as missing.

Does the tool explain JSON syntax errors?

No. It displays Invalid JSON format for parse failures. A non-array input shows JSON must be an array of objects; an empty array shows Array is empty.

Does it preserve spreadsheet cell types?

No. CSV is text without type metadata. Your spreadsheet decides whether values are dates, numbers or formulas. Inspect untrusted values before importing.

What Does This Tool Do?

This free online converter transforms JSON arrays into CSV (comma-separated values) format. JSON is how APIs and web applications store data. CSV is what spreadsheets and databases understand. This tool bridges the gap between the two.

When Would You Need to Convert JSON to CSV?

Data often comes in JSON format, but you need it elsewhere:

  • API exports: You pulled data from a REST API and need to analyze it in Excel.
  • Database imports: Your target system accepts CSV but your source provides JSON.
  • Report generation: Management wants spreadsheets, not JSON files.
  • Data migration: Moving data between systems that speak different formats.
  • Quick analysis: Google Sheets is faster for exploring data than writing code to parse JSON.
  • Sharing with non-technical colleagues: Everyone can open a CSV; not everyone knows JSON.

How Does It Work?

Paste your JSON array (e.g., [{"name": "John", "age": 30}, {"name": "Jane", "age": 25}]) into the input area. The tool automatically extracts all keys to create column headers. Each object becomes a row. String values containing commas, quotes or newlines are quoted. Headers and non-string values are not escaped; check them before copying or downloading.

Format Requirements

The tool expects a JSON array of objects. Each object represents a row, and each key becomes a column. Nested objects are converted to their string representation. For best results with deeply nested data, flatten it first or use a different approach.

Who Uses This Tool?

Business analysts exporting API data to spreadsheets. Developers creating data dumps for clients. Data scientists preparing datasets. Marketing teams analyzing campaign data. Product managers creating reports from analytics APIs.

Error Handling

If your JSON is invalid, the tool will show a clear error message. Common issues include missing brackets, trailing commas, or unquoted strings. Fix the JSON syntax and try again.

Local conversion

Conversion happens in JavaScript on your machine. The converter does not upload the pasted JSON.

Need to clean up your data first? Try our Remove Duplicate Lines tool. Working with PDFs? Check out PDF Compress.

Examples

Different keys in two rows

Input: [{"name":"Mina","qty":2},{"name":"Omar","price":5}]. CSV Output has these three lines: name,qty,price
Mina,2,
Omar,,5. The price column is added when the second object is inspected. Each missing value leaves an empty cell, so both rows have the same header positions.

Quoted text and a null value

Input: [{"item":"Pen, blue","note":"Say "Hi"","qty":null}]. The header is item,note,qty. The data row is "Pen, blue","Say ""Hi""",. The comma-containing string is quoted, embedded quotation marks are doubled, and the null quantity leaves a trailing empty cell. No extra data row is added.

Limits and notes

Nested objects are not flattened into dotted columns: String(value) produces [object Object]. Arrays also use String(value); [1,2] becomes 1,2 without CSV quoting and can shift columns. Flatten nested data yourself before conversion.

Only string values get comma, quotation-mark and newline escaping. Headers are joined without escaping, so keys containing those characters need cleanup. Keep each array entry a non-null row object; mixed entries are not reliably validated.

The page has no enforced text-length limit, but parsing and conversion run immediately in browser memory. This operation sends no conversion request. The download uses comma separators and newline-separated rows, with no option for semicolons or another delimiter.

Related free tools

  • XML Formatter & Minifier — Beautify or minify any XML — SOAP, RSS, SVG, sitemap. Browser-based parser.
  • XML to JSON Converter — Parse any well-formed XML into a clean JSON tree with attributes and arrays.
  • JSON to XML Converter — Convert JSON to well-formed XML — supports attributes, custom root, declaration.
  • CSV Viewer — Open CSV or TSV files in your browser — sort, search, paginate, export filtered view.
  • CSV to JSON Converter — Convert CSV data to JSON format. Useful for API development.
  • JSON Formatter — Format, beautify, or minify JSON with customizable indentation.
  • JSON Validator — Validate JSON syntax and find errors with line and column numbers.
  • HTML Minifier — Compress HTML by removing comments, whitespace, and line breaks.
  • CSS Minifier — Minify CSS by stripping comments, whitespace, and unnecessary characters.
  • JavaScript Minifier — Compress JavaScript by removing comments, whitespace, and empty lines.
  • Base64 Encoder/Decoder — Encode text to Base64 or decode Base64 back to text. UTF-8 support.
  • URL Encoder/Decoder — Percent-encode text for URLs or decode encoded URLs back to text.

Browse all free tools · Guides and tutorials · PDF tools · Developer tools · Text tools · SEO tools