Explore all Text & Data Tools

JSON to CSV Converter Online – Free, Fast & Privacy-First

Convert JSON to CSV or CSV to JSON instantly in your browser. Clean tabular preview, custom delimiters, nested object flattening, and instant file export.

Input JSON0 lines • 0 chars
Output CSV0 lines • 0 chars
RunMacro Bot
⚡ No-Code Data Extraction

Automate Web Scraping Directly into Excel & CSV

Tired of manually downloading JSON and converting files? Use RunMacro's no-code web automation to scrape tables, product lists, and APIs directly into clean CSV spreadsheets on a schedule.

How to Convert JSON to CSV or CSV to JSON

1

Select Conversion Mode & Paste Data

Choose JSON to CSV or CSV to JSON, then paste your data, upload a file, or load sample records.

2

Configure Options & Delimiters

Select comma, semicolon, or tab separators, and toggle nested object flattening if working with hierarchical JSON.

3

Preview Table & Export

Review the interactive tabular grid, copy the converted text to your clipboard, or download as a .csv or .json file.

Realistic JSON to CSV Conversion Scenarios

Transforming API payloads into spreadsheet tables, flattening nested objects, and formatting exports.

Convert User API Array to Excel-Ready CSV

Example 1
Configuration:Delimiter: Comma (,) | Flatten Nested Objects: ON
Input Data
[{"id": 101, "name": "Nguyen Van A", "email": "a@example.com", "role": "admin"}, {"id": 102, "name": "Tran Thi B", "email": "b@example.com", "role": "editor"}]
Output Result
id,name,email,role
101,Nguyen Van A,a@example.com,admin
102,Tran Thi B,b@example.com,editor
Analysis & Interpretation: Automatically extracts keys as the header row and converts each object into a structured table record ready for import into Microsoft Excel or Google Sheets.

Flatten Deeply Nested JSON Objects into Flat Columns

Example 2
Configuration:Delimiter: Comma (,) | Flatten Nested Objects: ON
Input Data
[{"orderId": "ORD-9821", "customer": {"name": "Le Hoang", "city": "Da Nang"}, "totals": {"amount": 250, "currency": "USD"}}]
Output Result
orderId,customer.name,customer.city,totals.amount,totals.currency
ORD-9821,Le Hoang,Da Nang,250,USD
Analysis & Interpretation: Flattens nested object properties into dot-notated column names (customer.name, totals.amount), preserving hierarchy while maintaining a clean tabular format.

Delimiters & Flattening Options Guide

Configure output separators, nested object handling, and bi-directional mode.

Field Delimiter

Comma (,)

Choose column separator: Comma (,), Semicolon (;), or Tab (\t for TSV format).

Impact: Comma is standard for international formats and Google Sheets; semicolon is preferred for European Excel locales; Tab is ideal for direct clipboard pasting.

Flatten Nested Objects

true

Recursively unwraps child objects into separate columns using dot notation (user.address.city).

Impact: When enabled, all nested fields become table columns. When disabled, child objects remain serialized JSON strings inside a single table cell.

Bi-Directional Mode (JSON ⇄ CSV)

JSON → CSV

Easily switch between converting JSON to CSV or parsing raw CSV tables back into clean JSON arrays.

Impact: Enables round-trip conversions between spreadsheet exports and REST API payload requirements.

Technical Considerations & Best Practices

Understanding browser memory limits, heterogeneous structures, and RFC 4180 escaping.

Heterogeneous Keys Across Array Objects

If the first object has fewer keys than subsequent objects, simple parsers might miss late-appearing columns.

Recommended Workaround: RunMacro collects the union of all keys across all records before generating headers, filling missing values with empty cells.

Browser Memory Limit on Large Files (> 10MB)

Client-side processing stores parsed objects in browser RAM. Converting huge files with over 100,000 deep records can cause UI thread latency.

Recommended Workaround: Split large datasets into 2,000–5,000 row chunks, or use RunMacro Desktop to stream and process files without memory constraints.

Multiline Strings and Double Quotes in Cell Values

Text cells containing commas, line breaks (\n), or quotes can misalign spreadsheet rows if not properly escaped per RFC 4180.

Recommended Workaround: The converter automatically wraps complex values in double quotes ("...") and escapes inner quotes (""), ensuring seamless spreadsheet imports.

Key Capabilities of JSON & CSV Converter

Bi-Directional Conversion

Seamlessly switch between JSON to CSV and CSV to JSON with instant parsing.

Nested Object Flattening

Automatically flattens nested hierarchies into dot-notation columns like user.name.

Live Tabular Preview

Inspect clean spreadsheet-like rows directly inside your browser before exporting.

100% Client-Side Privacy

Your data is processed in-memory in your browser. Zero transmissions to remote servers.

Frequently Asked Questions

Clear answers about using this tool and automating workflows with RunMacro.

Is my data secure when converting JSON to CSV online?

Yes. All parsing, delimiter formatting, and file generation happen 100% client-side in your browser using JavaScript Web APIs. No data is ever transmitted, logged, or stored on RunMacro servers.

How does nested JSON object flattening work?

When flattening is enabled, nested object keys are combined using dot-notation (e.g. {"user": {"email": "test@example.com"}} becomes a CSV column named "user.email"). This prevents nested objects from appearing as unreadable [object Object] text.

Can I import CSV files with semicolons into Excel?

Yes. In European locales where commas represent decimal separators, Excel expects semicolons as CSV delimiters. You can select Semicolon (;) before exporting.

How can I automate scraping web data directly to CSV?

RunMacro allows you to record web scraping workflows or automate Chrome browser actions to extract tables and data directly into CSV or Excel on scheduled intervals without manual conversion.

Related Free Tools

Explore other helpful browser-based utilities in the same category.