JSON, Data & Formatter Tools

Free JSON to CSV Converter

Convert arrays of JSON objects into delimited text formats. Choose comma (CSV) or tab (TSV) delimiters, toggle header rows on or off, and flatten nested fields using dot notation. The output is displayed as a preview table and is available for copy or download as a .csv file. Supports arrays of objects, arrays of primitives, and mixed structures.

Loading tool...

What is JSON to CSV Converter?

JSON to CSV Converter transforms JSON arrays into comma-separated or tab-separated values. It automatically detects fields from the first object, flattens nested properties using dot notation (user.address.city becomes user.address.city), and generates clean tabular output. You can toggle headers, choose your delimiter, and download the result as a ready-to-import CSV file.

quickAnswer

Paste a JSON array, choose comma or tab delimiter, toggle headers on or off, and preview the table output. Download the result as a CSV file. Nested fields are flattened using dot notation automatically.

Last updated: 2026-06-05

limitations

The converter requires a JSON array at the root level. Single objects or non-array JSON values cannot be converted directly -- wrap them in an array first.
Fields that differ between objects (inconsistent schemas) are handled based on the first object only. The tool does not merge schemas from all objects to create a union of all fields.
Deeply nested arrays inside objects are serialized as JSON text within a single cell rather than being expanded into additional columns. For fully normalized output, pre-process nested arrays before conversion.

Sources:MDN Web Docs · W3C Specifications · jquery.app on GitHub

How to use this tool

Paste a JSON array into the input area or load from a file. The tool automatically detects the array structure.
Choose your delimiter: comma for CSV (Excel-compatible) or tab for TSV.
Toggle Include Header Row on or off. Headers use dot notation for nested fields by default.
Preview the output table and copy the text or click Download CSV to save the file.

What you can use it for

Convert API JSON responses into CSV format for import into Excel, Google Sheets, or database tools.
Flatten nested JSON objects from NoSQL databases into flat rows for traditional spreadsheet analysis.
Export JSON data from web applications into delimited files for ETL pipelines and data migrations.

Use cases

Practical examples

example

Exporting API user data to CSV

A developer needs to analyze user data from a REST API that returns JSON. They paste the user array into the tool, set the delimiter to comma, enable headers, and download the CSV. The nested profile.city and profile.country fields are flattened to profile.city and profile.country columns automatically.

example

Preparing data for a bulk import

A marketing team maintains a product catalog in JSON. They need to upload it to a CMS that accepts CSV. The developer converts the JSON array with tab delimiter, downloads the TSV file, and the CMS import succeeds on the first try.

Common mistakes

Assuming all JSON arrays with mixed object shapes convert cleanly -- the tool uses the first object for column headers. Objects with extra fields in later rows produce sparse columns with empty cells.
Using commas inside cell values without quoting -- the tool quotes all fields that contain delimiters, newlines, or double quotes. Pre-check the output for proper quoting before importing into Excel or database tools.
Forgetting to check for deeply nested arrays within objects -- array properties are serialized as JSON strings in the cell rather than being spread across columns. Flatten nested arrays manually or choose a different export format.

verification

Paste a simple array like [{"name":"Alice","age":30},{"name":"Bob","age":25}], set delimiter to comma, enable headers. Confirm the output shows the header row name,age followed by the two data rows.
Toggle Include Header Row off and verify the output contains only data rows with no header line. Download and open the .csv in a spreadsheet to confirm proper column alignment.

FAQ

Questions about JSON to CSV Converter

Does this converter handle nested objects?

Yes. Nested objects are flattened using dot notation. For example, {"user": {"name": "Alice", "address": {"city": "Berlin"}}} becomes columns user.name and user.address.city. This preserves the nested structure in a flat table format compatible with spreadsheet applications.

Can I convert a single JSON object, not an array?

No. The converter expects a JSON array of objects at the root level. If you paste a single object, it will not produce the expected CSV output. Wrap a single object in an array -- [{ ... }] -- to convert it as a single-row CSV.

What happens if different items in the array have different fields?

The tool uses the first object in the array to determine the column headers. Any fields in subsequent objects that do not appear in the first object are omitted from the output. For best results, ensure all objects in the array share the same schema, or reorder the array so the object with the most fields comes first.

Related tools

More json, data & formatter tools

JSON, Data & Formatter Tools

JSON Formatter & Validator

Format, validate, minify, and tree-view JSON data. Detects trailing commas, shows error position with context. All processing happens in the browser -- no data sent anywhere.

Open tool

JSON, Data & Formatter Tools

YAML JSON Converter

Bidirectional YAML to JSON and JSON to YAML converter. Handles nested objects, arrays, and scalar values. Useful for config files, GitHub Actions, front matter, and Docker Compose.

Open tool

JSON, Data & Formatter Tools

JSONPath Tester

Test JSONPath expressions against JSON data. Supports dot notation, bracket notation, wildcards, array indices, and filter expressions. Shows matched values with paths.

Open tool

Also try

Encoders, Hash & Security Tools

COOP/COEP/CORP Header Builder

Build Cross-Origin isolation headers for SharedArrayBuffer, WebAssembly threads, and cross-origin security. Choose from presets with debugging checklists.

Open tool

Encoders, Hash & Security Tools

CORS Header Generator

Generate CORS HTTP headers for any origin, method, and credential configuration. Output in raw HTTP, Nginx, Apache, Express, or Cloudflare Workers format.

Open tool

Encoders, Hash & Security Tools

CSP Hash Generator

Generate CSP hash values for inline scripts and styles. Hash exact code content with SHA-256, SHA-384, or SHA-512 and get the matching CSP directive snippet.

Open tool