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 (\tTSV 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.mdfiles via nativeFileReader, inspect top rows in a tabular preview grid, and export.csvfiles prepended with a UTF-8 BOM (\uFEFF) so Microsoft Excel renders international characters cleanly.
Step-by-Step Usage Guide
- 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.
- 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. - Select Target Output Format: Choose JSON (Pretty / Minified), CSV / TSV, or Markdown Table as your target output representation.
- 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.