How does this tool handle nested JSON objects when converting to CSV?

Nested JSON objects are flattened using dot notation. For example, {"user": {"address": {"city": "NYC"}}} becomes a column named 'user.address.city' with the value 'NYC'. This preserves the hierarchical structure while making the data compatible with flat CSV format. You can toggle flattening on or off in the options.

Can I convert CSV back to JSON with this tool?

Yes. This is a bidirectional converter. Switch to 'CSV to JSON' mode, paste your CSV data, and the tool will parse it into a JSON array of objects using the first row as property names. It supports automatic type detection for numbers, booleans, null values, and dates.

What delimiters are supported for CSV conversion?

The tool supports four delimiters: comma (standard CSV), tab (TSV), semicolon (common in European locales), and pipe. You can select the delimiter from the options panel before converting.

Is my data safe when using this converter?

Yes, completely. This tool runs 100% in your browser using client-side JavaScript. Your data never leaves your computer and nothing is sent to any server. You can even use it offline once the page is loaded.

How are arrays inside JSON objects handled?

Arrays inside JSON objects are serialized as JSON strings in the CSV output (e.g., [1,2,3]). This approach preserves the array data without losing information. When converting back from CSV to JSON, array-like strings are detected and automatically parsed back into arrays.

Can I preview the data before downloading?

Yes. The tool includes a data preview table that shows the parsed data in a scrollable, formatted table before you convert or download. This helps you verify the data structure and catch any issues before exporting.

JSON to CSV / CSV to JSON Converter

Convert between JSON and CSV formats with nested object flattening, data preview table, custom delimiters, and file download. Everything runs in your browser — your data stays private. See also our CSV Files Complete Guide.

Delimiter

Null Values

JSON Indent

Include headers Flatten nested objects Auto-detect types Detect ISO dates

Samples:

Input JSON

CSV Output

Converted output will appear here...

About JSON ↔ CSV Conversion

JSON (JavaScript Object Notation) and CSV (Comma-Separated Values) are two of the most widely used data interchange formats. JSON excels at representing hierarchical, nested data structures used by APIs and web services. CSV is the universal tabular format understood by every spreadsheet application, database, and data analysis tool.

This bidirectional converter handles the full complexity of real-world data: nested objects are flattened to dot-notation columns, arrays are preserved as JSON strings, missing keys across rows are filled correctly, and special characters in values (commas, quotes, newlines) are properly escaped following RFC 4180.

For a deeper dive into the CSV format, including advanced parsing techniques and edge cases, check out our CSV Files Complete Guide.

JSON to CSV Features

Flatten deeply nested JSON objects using dot notation (e.g., address.city)
Handle arrays of objects with varying keys — missing fields become empty cells
Arrays within objects serialized as JSON strings to preserve data
Custom delimiters: comma, tab, semicolon, or pipe
Configurable null value representation (empty, "null", "N/A")
Optional header row inclusion
Proper CSV escaping for commas, quotes, and newlines per RFC 4180

CSV to JSON Features

First-row header detection for property names
Automatic type detection for numbers, booleans, null, and dates
Handles RFC 4180 quoted fields with embedded commas and newlines
Supports comma, tab, semicolon, and pipe delimiters
Configurable JSON indentation (2 spaces, 4 spaces, tabs, minified)
ISO 8601 date string detection

Common Use Cases

Exporting REST API responses to Excel or Google Sheets
Preparing CSV data for database bulk imports (PostgreSQL COPY, MySQL LOAD DATA)
Converting spreadsheet exports to JSON for web applications
Sharing structured data with non-technical stakeholders
Transforming configuration files between formats
Data migration between systems that use different formats

JSON to CSV / CSV to JSON Converter

Data Preview

About JSON ↔ CSV Conversion

JSON to CSV Features

CSV to JSON Features

Common Use Cases

Frequently Asked Questions

JSON to CSV / CSV to JSON Converter

Data Preview

About JSON ↔ CSV Conversion

JSON to CSV Features

CSV to JSON Features

Common Use Cases

Related Tools

CSV Viewer

JSON Formatter

JSON to YAML

XML JSON Converter

Frequently Asked Questions