CSV, JSON & Markdown Table Converter

Convert bidirectionally between CSV or TSV spreadsheets, JSON arrays, and Markdown tables with strict RFC 4180 quote handling.

RFC 4180 Parser · Markdown Table · Excel BOM

Loading tool workspace...

Overview of the Online CSV ↔ JSON & Markdown Table Converter

Moving tabular datasets between spreadsheets, REST APIs, database seed scripts, and GitHub documentation is an everyday engineering and operations workflow. You might need to turn a product catalog exported from Excel or Google Sheets into a structured JSON array, flatten an API JSON payload back into a downloadable CSV report, or render rows cleanly as a GitHub-Flavored Markdown table.

Naive converters built around line.split(',') shatter immediately whenever real-world cells contain commas ("Austin, TX"), multi-line notes, or escaped quotes. AllUtility’s CSV ↔ JSON Converter implements a pure TypeScript IETF RFC 4180 finite-state machine parser, executing every file read, preview, and download 100% locally inside your browser with zero server uploads.

RFC 4180 State-Machine Parsing & Key Features

Under IETF RFC 4180, fields containing delimiters, line breaks (CRLF / LF), or double-quote characters are enclosed in double quotes ("..."), with literal quotes escaped as "". Rather than splitting lines blindly, our character-by-character state machine tracks quoted vs. unquoted states accurately across arbitrary multi-line cells.

  • Tri-Format Bidirectional Conversion: Seamlessly transform datasets across CSV / TSV ↔ JSON (Pretty-printed or Minified) ↔ Markdown Table formats in real time.
  • Automatic Delimiter Detection: Automatically detects comma (,), tab (\t TSV pasted directly from Excel/Sheets), and semicolon (; standard in European locales), with manual override controls.
  • First-Row Header Toggle: Switch effortlessly between keyed arrays of objects ([{ "id": "101" }]) when row one contains column headers, or 2D arrays of arrays ([["101"]]) for headerless matrices.
  • Live Table Preview & Excel-Safe File I/O: Upload .csv, .tsv, .json, or .md files via native FileReader, inspect top rows in a tabular preview grid, and export .csv files prepended with a UTF-8 BOM (\uFEFF) so Microsoft Excel renders international characters cleanly.

Step-by-Step Usage Guide

  1. Paste Data or Upload a Local File: Drop raw CSV, TSV, JSON, or Markdown table text into the editor—or load a local file directly from disk without uploading anything over the network.
  2. Verify Delimiter & Header Mode: Confirm the auto-detected delimiter (,, \t, or ;) and toggle First Row as Header depending on whether your first line defines field names.
  3. Select Target Output Format: Choose JSON (Pretty / Minified), CSV / TSV, or Markdown Table as your target output representation.
  4. Preview, Copy, or Download: Inspect the live top-rows preview table to confirm column alignment, then copy the result to your clipboard or download the converted file in one click.

Practical Conversion Example & Data Integrity Tips

Quoted commas and international text survive round-trip conversion without shifting columns:

Input CSV:
id,customer,location
101,"Ada Lovelace","London, UK"

Converted JSON (First Row as Header):
[
  {
    "id": "101",
    "customer": "Ada Lovelace",
    "location": "London, UK"
  }
]
  • Preserve Leading Zeros in Codes & IDs: Postal codes (02139), phone numbers, and SKU identifiers lose leading zeros if eagerly coerced to numbers in spreadsheets. Verify string preservation when preparing database import payloads.
  • Copy-Pasting Straight from Spreadsheets: Selecting cells in Excel, Numbers, or Google Sheets and pasting directly into the input pane inserts tab-separated (\t) text, which our delimiter detector recognizes automatically—no intermediate file export required.

Frequently Asked Questions

How does this converter handle commas and line breaks inside quoted CSV cells?

Because it uses a dedicated IETF RFC 4180 finite-state machine rather than regex or split(','), any comma, newline, or escaped double quote ("") inside a "..." quoted field is preserved as part of that single cell without breaking column alignment.

Why does the CSV download include a UTF-8 BOM (\uFEFF)?

Without a Byte Order Mark, Microsoft Excel on Windows and macOS frequently misinterprets UTF-8 CSV files using legacy system codepages, corrupting Korean, Chinese, Japanese, and accented European characters. Prepending \uFEFF tells Excel to open the file in UTF-8 immediately on double-click.

Can I convert a JSON array directly into a GitHub Markdown table?

Yes. Paste an array of JSON objects (or upload a .json file) and select Markdown Table output. Keys from your JSON objects become the table header row automatically, with pipes inside cell values safely escaped so your README or pull-request table renders cleanly.

Are confidential customer spreadsheets or JSON exports uploaded to any server?

Never. Local files are read strictly in-memory through your browser's native FileReader API, and downloads are synthesized locally via Blob URLs. Zero bytes of your dataset ever leave your device.