JSON • JSONL • SQL INSERT • YAML • XML • HTML
Spreadsheet to JSON, JSONL, SQL & YAML Converter
Turn any Excel, CSV, TSV, or Markdown table into structured developer formats with automatic key deduplication and SQL-safe quoting. Click Export Format > Open Live Format Preview to inspect output before downloading.
A1
fx
Drop XLSX, CSV, TSV, Markdown (.md), or JSON here
Runs locally inside browser memory. Multi-sheet workbooks open into tabs automatically.
1r × 1c used
Count: 0
Sum: 0
Avg: 0
Zero Uploads
Combine Two or More Columns
Merge 2+ columns cleanly without writing formulas.
Preview
Split Column by Delimiter
Remove Duplicate Rows
Find & Replace
Sort Rows
Filter or Delete Matching Rows
Quick Cleanup:
Fill, Prefix / Suffix & Extract Column
Merge Multiple Files / VLOOKUP Join Sheets
Append rows from multiple files/tabs or join two sheets by a key column.
Option A: Stack / Append All Open Sheet Tabs
Option B: VLOOKUP / Left-Join Two Sheets by Key
Format Preview & Export Converter
Column Profiler & Quick Summary
| Col | Header | Filled | Blank | Unique | Dupes | Min / Max / Avg |
|---|
Paste CSV, TSV, Markdown Table, JSON, or HTML
Confirm Action
Developer-Safe Conversion Rules
- Leading-Zero Protection: ZIP codes (`02134`) and padded IDs (`0045`) remain quoted strings in JSON, SQL, and YAML instead of corrupting into octal or truncated numbers.
- Duplicate Header Safety: Repeated header labels automatically suffix (`amount`, `amount_2`) so object keys never silently overwrite adjacent columns.
- JSON to Excel / CSV: Drop or paste `.json` or `.jsonl` payloads straight onto the grid to inspect nested objects or export back to `.xlsx` and `.tsv`.
