Clean Messy CSV & Excel Files Online
Drop your raw CRM, Stripe, or mailing list export below. Inspect missing values under More Tools → Column Stats, click Trim, normalize Case, and click Deduplicate without touching Excel formulas.
Drop XLSX, CSV, TSV, Markdown (.md), or JSON here
Runs locally inside browser memory. Multi-sheet workbooks open into tabs automatically.
Combine Two or More Columns
Merge 2+ columns cleanly without writing formulas.
Split Column by Delimiter
Remove Duplicate Rows
Find & Replace
Sort Rows
Filter or Delete Matching Rows
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
1. Trim Spaces & Blank Rows
Strips invisible leading/trailing spaces ("Austin, TX ") so filters, joins, and deduplication stop missing near-identical rows.
2. Preserve Leading Zeros
Opening a CSV in desktop Excel strips zeros from 02134 ZIP codes and numeric IDs. Browser memory keeps raw strings untouched.
3. Key-Based Deduplicate & Sort
Deduplicate whole rows or specific email/SKU columns, then sort cleanly while pinning Row 1 headers in place.
