jquery.app
English
EnglishDeutschFrancaisEspanol日本語Nederlands

HTML 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.

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.

How to use this tool

  1. Paste a JSON array into the input area or load from a file. The tool automatically detects the array structure.
  2. Choose your delimiter: comma for CSV (Excel-compatible) or tab for TSV.
  3. Toggle Include Header Row on or off. Headers use dot notation for nested fields by default.
  4. 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

  1. 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.
  2. 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 html tools

Html

ARIA Live Region Generator

Generate accessible ARIA live region HTML snippets with role, aria-live, aria-atomic, and aria-relevant attributes. Includes optional JavaScript update function.

Open tool

Html

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

Also try

Also try

Seo

AI Crawler robots.txt Builder

Build a robots.txt policy for AI crawlers. Choose from open, selective, or strict presets and block specific AI training bots while allowing search engines.

Open tool