Browser column cleaner

Column Mapper & Cleaner

Upload the main data file and a desired-columns list. The app matches columns by normalized names, uses fuzzy matching when needed, creates blank columns for missing fields, and exports clean Excel.

🔒 Files stay in your browser
STEP 01

Main Data File

No file selected
📊
Drop main data file here CSV, XLSX or XLS
First worksheet will be used. The file must have column headers.
STEP 02

Desired Columns File

No file selected
🧾
Drop desired-columns file here TXT, CSV, XLSX or XLS
TXT uses one column name per line. Spreadsheet files use the first column.
Same default as the Python version. Higher values require closer column names.
“Create blank column” matches the original desktop tool.

Map desired columns and generate output

Exact normalized matches are preferred. Otherwise the closest source column above the selected cutoff is used.

Reading files…
0
Output rows
0
Desired columns
0
Exact matches
0
Fuzzy matches
0
Missing columns
Desired Column Source Column Match Type Similarity
Normalization removes spaces, punctuation, underscores, and letter-case differences. For example, “Product ID”, “product_id”, and “ProductId” become the same normalized name.
Client-side processing • No spreadsheet data is uploaded by this page