// FREE IT TOOLS

JSON to CSV Converter

Convert JSON arrays to RFC 4180 compliant CSV — flattens nested objects with dot-notation keys, serialises arrays and objects, and handles booleans and nulls with proper quoting. All processing happens in your browser.

// EXAMPLES

// JSON INPUT

Nothing is sent to the server — all processing happens in your browser.

// CSV OUTPUT

Paste JSON in the input panel to get started

What is JSON?

JSON (JavaScript Object Notation) is a lightweight, text-based data interchange format that is easy for humans to read and write, and easy for machines to parse and generate. It is built on two structures: a collection of name/value pairs (object) and an ordered list of values (array). JSON has become the de-facto standard for REST APIs, configuration files, and data exchange between systems.

Why Convert JSON to CSV?

While JSON is perfect for APIs and modern applications, CSV remains the universal language of spreadsheets, databases, and legacy tools. Converting JSON arrays to CSV bridges the gap between modern data formats and the tools your business already uses.

Spreadsheet Import:Excel, Google Sheets, and LibreOffice Calc all open CSV natively. Convert API responses or exported JSON data into a format that non-technical stakeholders can view and edit immediately.
Data Analysis:Data science tools like pandas, R, and SQL databases often expect tabular input. Flattened CSV with dot-notation keys maps cleanly to table columns for analysis and reporting.
Legacy Systems:Enterprise tools, ERPs, and older ETL pipelines frequently require CSV input. Converting JSON to RFC 4180 compliant CSV ensures your modern data feeds into legacy workflows without friction.

Frequently Asked Questions

Is my data sent to a server?: No. All conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device. Nothing is transmitted over the network.
How are nested objects handled?: Nested objects are flattened using dot-notation keys. For example, a user object with an address.city field becomes two columns: address.city and address.postcode. This keeps every value in a single row without losing structure.
What happens to arrays and objects inside values?: Arrays and objects that cannot be flattened into scalar columns are serialised back to JSON strings inside the CSV cell. This preserves the full data structure while keeping the output valid RFC 4180 CSV.
What if my input is not a JSON array?: The converter requires a JSON array of objects. A single object or primitive value will show a clear error message. Wrap your object in square brackets to convert it.

// DATA INTEGRATION

Need Help with Data Integration?

DMC IT Services designs, builds, and manages data pipelines and integrations for SMBs across London, Cambridge, Hertfordshire, and Bedfordshire — from API connectivity and ETL workflows to database design and legacy system modernisation.

Talk to an Engineer

← Back to all free tools

What is JSON?

Why Convert JSON to CSV?

Spreadsheet Import:Excel, Google Sheets, and LibreOffice Calc all open CSV natively. Convert API responses or exported JSON data into a format that non-technical stakeholders can view and edit immediately.
Data Analysis:Data science tools like pandas, R, and SQL databases often expect tabular input. Flattened CSV with dot-notation keys maps cleanly to table columns for analysis and reporting.
Legacy Systems:Enterprise tools, ERPs, and older ETL pipelines frequently require CSV input. Converting JSON to RFC 4180 compliant CSV ensures your modern data feeds into legacy workflows without friction.

Frequently Asked Questions

Is my data sent to a server?

No. All conversion happens entirely in your browser using JavaScript. Your JSON data never leaves your device. Nothing is transmitted over the network.

How are nested objects handled?

Nested objects are flattened using dot-notation keys. For example, a user object with an address.city field becomes two columns: address.city and address.postcode. This keeps every value in a single row without losing structure.

What happens to arrays and objects inside values?

Arrays and objects that cannot be flattened into scalar columns are serialised back to JSON strings inside the CSV cell. This preserves the full data structure while keeping the output valid RFC 4180 CSV.

What if my input is not a JSON array?

The converter requires a JSON array of objects. A single object or primitive value will show a clear error message. Wrap your object in square brackets to convert it.