How do I convert JSON to CSV online?

Paste your JSON data into the input box or upload a .json file. The converter automatically parses the payload, detects array structures or root wrappers like {"data": [...]}, flattens nested fields, and generates a formatted CSV ready to copy or download.

Is my JSON data uploaded or sent to an external server?

No. To ensure maximum data privacy and security, all parsing, filtering, flattening, and CSV formatting calculations execute entirely within your browser memory. No data is ever sent to a remote server.

How does the converter handle nested JSON objects?

You can choose your preferred nested object strategy: flatten using dot notation (e.g. user.address.city), flatten using underscore notation (user_address_city), stringify the object into a JSON string, or skip nested objects entirely.

How are JSON arrays converted into CSV fields?

Array properties can be joined with commas, joined with semicolons, stringified into JSON array syntax, or flattened into individual indexed columns (e.g. tags_0, tags_1).

What JSON formats can be converted to CSV?

The converter supports arrays of objects (e.g. [{"name":"A"}, {"name":"B"}]), root objects with nested array properties (e.g. {"data": [...]}), and single flat objects. If a JSON payload contains only primitive values, clear feedback is displayed.

Can I customize delimiters for European Excel or TSV format?

Yes. You can switch delimiters between Comma (,), Semicolon (;) for European Excel compatibility, Tab (\t) for TSV files, or Pipe (|) for database imports.

Can I select, reorder, or rename columns before exporting?

Yes. Under the Column Settings tab, you can toggle individual columns on or off, rename headers dynamically (e.g. map "customer.email" to "Email Address"), and alphabetize column ordering.

How are quotes, commas, and special characters escaped in CSV?

Fields containing quotes, commas, or newlines are wrapped in double quotes according to standard RFC 4180 CSV specifications. Internal quotes are escaped as double-quotes (""). You can also enable "Quote All Text" for strict quoting.

Can I open the downloaded CSV file in Microsoft Excel or Google Sheets?

Yes! The generated CSV files use standard UTF-8 encoding and RFC 4180 formatting, ensuring seamless opening in Microsoft Excel, Google Sheets, Apple Numbers, and LibreOffice Calc.

What is the maximum file size for converting JSON to CSV?

The tool comfortably converts files up to 5MB to 10MB directly in your browser. Processing speed depends on your device CPU and available memory.

JSON to CSV Converter - Convert JSON to CSV & Excel Online

#	Columns
No CSV data converted yet. Paste JSON or choose a sample preset.

Why Convert JSON to CSV?

JSON (JavaScript Object Notation) is the universal format for web APIs, serverless functions, and document databases (such as MongoDB). However, business intelligence tools, data science pipelines (Pandas/R), and spreadsheet software like Microsoft Excel and Google Sheets require structured tabular 2D rows and columns. Converting JSON to CSV transforms complex semi-structured data into flat tables ready for pivot analysis, reporting, and database imports.

Handling Nested Objects & Dot Notation

JSON data frequently contains nested sub-objects (e.g. <code>{"user": {"address": {"city": "New York"}}}</code>). This tool provides multiple strategies: flattening with dot notation (<code>user.address.city</code>), flattening with underscores (<code>user_address_city</code>), JSON stringifying the object as a literal cell value, or ignoring nested objects entirely.

Array Serialization & Row Expansion

Arrays inside JSON objects (such as tags, items, or IDs) do not naturally fit a single tabular cell. You can join array elements with commas (<code>item1, item2</code>), semicolons, or pipes, stringify arrays as raw JSON strings, or unroll/expand array indices across separate columns.

RFC 4180 Escaping & Excel Compatibility (UTF-8 BOM)

Proper CSV formatting adheres to RFC 4180 specifications. Cells containing delimiters, line breaks, or quotation marks are automatically wrapped in double quotes, and internal quotes are escaped by doubling (<code>""</code>). When opening CSV files in Microsoft Excel with non-ASCII or international Unicode characters (such as European accents, Hindi/Devanagari, or CJK characters), enabling the UTF-8 BOM ensures Excel decodes characters without text distortion.

Column Reordering, Renaming & Exclusion

Use the Column Mapping tab to customize the schema before exporting. You can exclude unneeded telemetry keys, rename raw database identifiers to human-readable table headers, and reorder columns using move controls.

100% Client-Side Privacy & Security

All parsing, normalization, mapping, grid rendering, and CSV generation happen exclusively inside your web browser. Your private JSON payloads, customer records, and database dumps are never transmitted to any remote server or third-party log. Companion tools include the <a href="/json-formatter" class="text-brandBlue-400 hover:underline font-semibold">JSON Formatter</a>, <a href="/csv-to-json" class="text-brandBlue-400 hover:underline font-semibold">CSV to JSON Converter</a>, and <a href="/xml-formatter" class="text-brandBlue-400 hover:underline font-semibold">XML Formatter</a>.

JSON to CSV Converter

Invalid JSON Syntax

Complete Guide to JSON to CSV Conversion & Tabular Mapping

Why Convert JSON to CSV?

Handling Nested Objects & Dot Notation

Array Serialization & Row Expansion

RFC 4180 Escaping & Excel Compatibility (UTF-8 BOM)

Column Reordering, Renaming & Exclusion

100% Client-Side Privacy & Security

Questions, answered

Related guides

How to Read and Debug JSON Returned by an AI Model

JSON to CSV Conversion: When and How to Convert Structured Data Correctly

GPT-6 Astra API Cost Explained: How Token Pricing Actually Works

Time Zone Converter: How to Schedule Meetings Across Time Zones Without Confusion

What do you need to work out next?

Invalid JSON Syntax

Complete Guide to JSON to CSV Conversion & Tabular Mapping

Why Convert JSON to CSV?

Handling Nested Objects & Dot Notation

Array Serialization & Row Expansion

RFC 4180 Escaping & Excel Compatibility (UTF-8 BOM)

Column Reordering, Renaming & Exclusion

100% Client-Side Privacy & Security

Questions, answered

Related guides

How to Read and Debug JSON Returned by an AI Model

JSON to CSV Conversion: When and How to Convert Structured Data Correctly

GPT-6 Astra API Cost Explained: How Token Pricing Actually Works

Time Zone Converter: How to Schedule Meetings Across Time Zones Without Confusion

Related Developer Tools

What do you need to work out next?

Enjoying JSON to CSV Converter?