MyScripter
Tools

JSON to CSV Converter

Need to turn JSON API responses, database exports, or config files into spreadsheet-friendly CSV? Paste your JSON and get a clean CSV with configurable delimiters, nested object flattening, and array expansion. Everything processes in your browser — your data never leaves your device.

JSON to CSV Converter

How to Use This Tool

  1. Paste your JSON data (array of objects or single object) into the input.
  2. Configure delimiter (comma, semicolon, tab) and flattening depth.
  3. Preview the generated CSV with headers and values.
  4. Copy the CSV to clipboard or download as a .csv file.

Features

  • Flattens nested JSON objects with dot-notation headers
  • Expands arrays into multiple rows or joined columns
  • Configurable delimiter (comma, semicolon, tab for Excel EU)
  • Handles mixed-type arrays and null values gracefully
  • Download as .csv file or copy directly to clipboard
  • Client-side only — no data uploaded to any server

Example

Flat JSON array to CSV

Convert a simple array of user objects to CSV format.

Sample

[{"name":"Alice","age":30,"city":"Berlin"},{"name":"Bob","age":25,"city":"Munich"}]

What you get

name,age,city Alice,30,Berlin Bob,25,Munich

Nested JSON with dot-notation flattening

Nested objects are flattened using dot-separated column headers.

Sample

[{"user":{"name":"Alice","address":{"city":"Berlin","zip":"10115"}},"role":"admin"}]

What you get

user.name,user.address.city,user.address.zip,role Alice,Berlin,10115,admin

Frequently Asked Questions

How does the converter handle nested JSON objects?
Nested objects are flattened using dot-notation for column headers. For example, {"user":{"name":"Alice"}} becomes a column "user.name" with value "Alice". You can configure the maximum flattening depth.
What happens with JSON arrays inside objects?
You can choose between two modes: "expand" creates multiple rows per array item, or "join" combines array values into a single cell separated by a delimiter (default: pipe |).
Is my data uploaded to a server?
No. All conversion runs entirely in your browser using JavaScript. Your JSON data never leaves your device — check the Network tab to verify.
Can I use semicolons as delimiter for European Excel?
Yes. Select "semicolon" from the delimiter dropdown. European versions of Excel use semicolons as the default CSV separator, so this ensures your file opens correctly with proper column separation.

Related Tools

CSV to JSON Converter

Transform CSV spreadsheet data into structured JSON arrays instantly.

XML to CSV Converter

Flatten XML documents into clean CSV tabular data for spreadsheets.

CSV to SQL INSERT Converter

Generate SQL CREATE TABLE and INSERT statements from CSV data.

XML to JSON Converter

Convert XML documents to clean, structured JSON with one click.

JSON to Shopify Product Schema Converter

Convert JSON product data to Shopify-compatible schema format.

CSV to Airtable Schema Mapper

Map CSV data to Airtable fields with automatic type detection.

Markdown to Notion-Ready Table Converter

Convert Markdown tables into Notion-ready format instantly.

SQL Query to Python DataFrame Script

Generate Python pandas scripts from SQL queries.

Robots.txt Generator for E-commerce Sites

Generate production-ready robots.txt files tailored for e-commerce platforms.