Menu
JSON Tools/JSON to CSVLocal. Private. Free.
YOUR DATA. A CLEARER VIEW.

JSON to CSV

Export an array of objects as CSV. Nested cells are serialized as JSON. Spreadsheet formula prefixes are escaped for safer opening in Excel.

No uploads33 toolsNo account needed

JSON to CSV

All tools ↓

Up to 5 MB per input. Drop a file here to open it locally.

Nested cells are serialized as JSON. Spreadsheet formula prefixes are escaped for safer opening in Excel.

Processed on this device. No input is saved.

Is JSON to CSV right for your task?

Export an array of objects as CSV.

What to provide
Use the sample below to check the expected input syntax.
What you get
Export an array of objects as CSV. The workspace displays the result or offers the relevant download.
Example input for JSON to CSV

Illustrative input, not a record of a completed test. Check the selected mode before running it.

[
  {"id":1,"name":"Alice","active":true,"profile":{"city":"上海"}},
  {"id":2,"name":"Bob","active":false,"profile":{"city":"London"}}
]

How to convert JSON to CSV

Export an array of objects as CSV.

  1. Paste your data into the input editor or select Open file, using the input format requested by this tool.
  2. Check your input and the supported features listed on this page before continuing.
  3. Select Run tool and inspect the output or any validation errors.
  4. Copy or download the result when it is ready. Review generated code or converted data before using it in another application.

Supported features and limits

Nested cells are serialized as JSON. Spreadsheet formula prefixes are escaped for safer opening in Excel.

Before you use the result

  • Compare the output column names and number of rows with the original records.
  • Nested structures do not map naturally to flat CSV. Inspect embedded objects, arrays, commas, quotes and multiline values before importing.

If JSON to CSV does not work as expected

Read the reported error location. Check quotes, delimiters and the selected mode; a file in another format needs the matching converter first. Repairs can change meaning, so review the differences.

Where your input is processed

The tool processes input in your browser. Loading the page and its processing libraries still needs network access. Site analytics and sharing services are separate from file processing; see the privacy explanation below. Privacy details.

Published by QoTool. About this site and its tool guides. Found an incorrect result? Report a problem with this tool with its settings and a non-sensitive example.

Explore JSON Tools

JSON Formatter

Format, compact or repair JSON while preserving number precision.

Format & Validate ↗

JSON Editor

Edit one document as code, a tree, a table or a grid.

Format & Validate ↗

JSON Validator

Check JSON syntax and locate parsing errors.

Format & Validate ↗

JSON Repair

Fix quotes, commas, comments and Python-style literals.

Format & Validate ↗

JSON Schema Validator

Validate a document against a supplied JSON Schema.

Format & Validate ↗

JWT Decoder & Verifier

Inspect JWT claims or verify a signature with your own key.

Format & Validate ↗

JSON Viewer

Read JSON with syntax colors and collapsible structure.

View & Explore ↗

JSON File Viewer

Open JSON, CSV, Excel or ZIP files locally and choose a document.

View & Explore ↗

JSON Tree Viewer

Search, expand and collapse nested JSON.

View & Explore ↗

JSON Table Viewer

Sort and filter JSON object arrays in a table.

View & Explore ↗

JSON Grid Viewer

Explore nested objects and arrays cell by cell.

View & Explore ↗

JSON Graph Viewer

Pan, zoom and fold a JSON node diagram; export SVG.

View & Explore ↗

JSONL Viewer

Read JSONL / NDJSON records while reporting malformed lines.

View & Explore ↗

JSON Diff Checker

Compare documents and list added, removed or changed values.

Compare & Search ↗

JSON Search & Replace

Find keys, string values or paths and replace matching text.

Compare & Search ↗

JSONPath Tester

Evaluate JSONPath selections and inspect matching paths and values.

Compare & Search ↗

JSON to YAML

Create readable YAML from JSON.

Convert ↗

YAML to JSON

Parse YAML and export a JSON document.

Convert ↗

JSON to CSV

Export an array of objects as CSV.

Convert ↗

CSV to JSON

Read CSV, TSV or Excel rows as a JSON array.

Convert ↗

JSON to Excel

Download a real XLSX workbook from JSON rows.

Convert ↗

Excel to JSON

Choose an XLSX/XLS workbook and export its worksheets.

Convert ↗

JSON to Markdown

Generate Markdown tables or nested lists.

Convert ↗

JSON to XML

Build XML elements, attributes and text from JSON.

Convert ↗

XML to JSON

Read XML elements and attributes into JSON.

Convert ↗

JSON Stringify & Escape

Escape raw text into a JSON string or decode it.

Convert ↗

JSON to TypeScript

Infer TypeScript types from JSON samples.

Convert ↗

Base64 Encoder / Decoder

Encode and decode Unicode text as Base64.

Convert ↗

JSON to XSD

Infer an XML Schema from a JSON sample.

XML & Schema ↗

XML to XSD

Infer element and attribute types from XML.

XML & Schema ↗

XSD to JSON

Create a sample JSON document from XML Schema.

XML & Schema ↗

XSD to XML

Generate sample XML from XML Schema.

XML & Schema ↗

XML / JSON / XSD Converter

Convert one source into two formats side by side.

XML & Schema ↗

Three steps, no uploads

Choose a tool, paste or open your data, then copy or download the result. File contents and verification keys are kept only in this page's memory.

Views show bounded previews for large documents; downloads contain the full processed output. Some conversions infer structure from samples and cannot preserve every format-specific feature.