CSV ↔ JSON Data Converter

Bidirectionally convert CSV tables into JSON arrays or transform JSON objects back to CSV with custom comma, semicolon, or tab delimiters.

Category: File & Data

How to Use CSV ↔ JSON Data Converter

  1. Paste your raw CSV table or JSON array/object into the text editor.
  2. Select the Conversion Direction (CSV to JSON Array or JSON Array to CSV).
  3. Choose your field delimiter: Comma (,), European Semicolon (;), or Tab (\t).
  4. Click Process to convert and copy or download your resulting dataset.

Related File & Data Tools

  • CSV to JSON Converter

    Convert tabular CSV spreadsheets with header rows into structured, pretty-printed JSON object arrays with full RFC 4180 quoted field support.

  • JSON to CSV Converter

    Flatten JSON arrays and nested objects into RFC 4180 compliant CSV spreadsheet rows using dot-notation column headers.

  • CSV Data Cleaner & Sanitizer

    Sanitize CSV datasets by removing duplicate rows, trimming cell whitespace, stripping blank lines, and normalizing RFC 4180 quotes.

  • CSV Column Extractor & Filter

    Extract, filter, or reorder specific columns from CSV datasets by header name or 1-based column index with full RFC 4180 quoted field support.

  • JSON to TypeScript Interface Generator

    Convert raw JSON payloads or API responses into clean, strictly-typed TypeScript interfaces, nested object types, and optional array item definitions.

Frequently Asked Questions

What is the difference between the Bidirectional CSV ↔ JSON Converter and the single-direction converters?

The Bidirectional CSV ↔ JSON Converter is an all-in-one workspace that supports switching between CSV-to-JSON and JSON-to-CSV modes on the fly, with configurable delimiter characters (comma ',', semicolon ';', and tab '\t') for European CSV exports and TSV files.

Why do European Excel CSV files use semicolons (;) instead of commas (,)?

In regions where the comma is used as the decimal separator for numbers (e.g., '19,99' instead of '19.99'), spreadsheet applications like Microsoft Excel use the semicolon (';') as the field delimiter to avoid ambiguity. Selecting Semicolon (;) in the CSV Delimiter menu parses and exports these files accurately.

How does JSON-to-CSV mode handle nested objects or missing keys across rows?

When converting JSON arrays to CSV, the engine flattens nested child objects into dot-notation column headers (such as 'author.name') and collects the complete union of keys across every object in the array so no fields from later rows are dropped.

Are quoted CSV fields with embedded delimiters or line breaks parsed properly?

Yes. The engine implements an RFC 4180 state-machine parser that preserves delimiters, spaces, and escaped double quotes ('""') inside quoted CSV cells.