Does type coercion work for CSV → JSON?

Yes. With the 'Coerce types' toggle on, strings like '42', '3.14', 'true', 'false', and 'null' become actual numbers, booleans, and null. Turn it off if you need every field as a string (e.g., preserving phone numbers with leading zeros).

Which CSV delimiters are supported?

Comma (default), Tab (for TSV files), Semicolon (common in European locales), and Pipe. Pick from the dropdown. The delimiter applies to both parsing and CSV output.

What about quoted fields and multi-line cells?

Fully supported. The parser follows RFC 4180: fields in double quotes can contain delimiters, newlines, and escaped quotes (two consecutive double quotes). Leading/trailing whitespace in quoted fields is preserved exactly.

What if my JSON has missing keys across rows?

The CSV output includes the union of all keys from all objects. Rows missing a key get an empty cell for that column. This is the most compatible behavior with Excel and Google Sheets.

Does it work offline?

Yes. Once the page loads, all parsing and serialization runs in your browser. No network calls. Safe for internal data.

CSV ↔ JSON Converter

Paste CSV, get JSON. Paste JSON, get CSV. Client-side, RFC 4180 compliant CSV parser handles quoted fields, escaped quotes, and multi-line cells. Type coercion for CSV → JSON (numbers, booleans, null) is toggleable. Works with arrays of objects or arrays of arrays. Delimiters: comma, tab, semicolon, pipe. Everything runs in your browser — handy for quick data ports during API work or log analysis.

Delimiter:Header rowCoerce typesPretty

CSV input

JSON output

[
  {
    "name": "Alice Nakamura",
    "age": 29,
    "email": "alice@example.com",
    "country": "JP",
    "active": true
  },
  {
    "name": "Bob Silva",
    "age": 34,
    "email": "bob@example.com",
    "country": "BR",
    "active": true
  },
  {
    "name": "Chen Wei",
    "age": 41,
    "email": "chen@example.com",
    "country": "CN",
    "active": false
  },
  {
    "name": "Diego Martinez",
    "age": 27,
    "email": "diego@example.com",
    "country": "MX",
    "active": true
  },
  {
    "name": "Emily Stone",
    "age": 38,
    "email": "emily@example.com",
    "country": "US",
    "active": true
  }
]

Notes

• Fully client-side — no uploads
• RFC 4180 CSV: quoted fields, escaped quotes, multi-line cells
• Type coercion: numbers, booleans, null (opt-in for CSV→JSON)
• JSON→CSV supports array-of-objects or array-of-arrays
• Delimiters: comma, tab, semicolon, pipe
• Missing object keys are filled with empty cells

Frequently Asked Questions

Does type coercion work for CSV → JSON?: Yes. With the 'Coerce types' toggle on, strings like '42', '3.14', 'true', 'false', and 'null' become actual numbers, booleans, and null. Turn it off if you need every field as a string (e.g., preserving phone numbers with leading zeros).
Which CSV delimiters are supported?: Comma (default), Tab (for TSV files), Semicolon (common in European locales), and Pipe. Pick from the dropdown. The delimiter applies to both parsing and CSV output.
What about quoted fields and multi-line cells?: Fully supported. The parser follows RFC 4180: fields in double quotes can contain delimiters, newlines, and escaped quotes (two consecutive double quotes). Leading/trailing whitespace in quoted fields is preserved exactly.
What if my JSON has missing keys across rows?: The CSV output includes the union of all keys from all objects. Rows missing a key get an empty cell for that column. This is the most compatible behavior with Excel and Google Sheets.
Does it work offline?: Yes. Once the page loads, all parsing and serialization runs in your browser. No network calls. Safe for internal data.

Related Tools

Markdown Editor

Free online Markdown editor with live preview. Write and preview Markdown in real-time with GitHub Flavored Markdown support.

WYSIWYG Markdown Editor

Rich text WYSIWYG editor that outputs clean Markdown. Free online visual Markdown editor.

Markdown to HTML

Convert Markdown to clean HTML code instantly. Free online Markdown to HTML converter with copy and download options.

HTML to Markdown

Convert HTML to clean Markdown instantly. Free online HTML to Markdown converter. Paste HTML and get Markdown output.

About CSV ↔ JSON Converter

Convert CSV to JSON and JSON to CSV with smart type coercion. Supports comma, tab, semicolon, pipe delimiters. RFC 4180 compliant. Free, no signup. This tool runs entirely in your browser, so your content is not sent to a server. MarkdownMe provides free, fast, and reliable Markdown tools for developers, writers, and anyone who works with Markdown.