Column Mapper

Pick a destination (HubSpot, Shopify, a generic contact list) and the tool maps your columns to the expected names. Exact matches and known aliases are detected automatically. You review the mapping, fix any mistakes, and download a file whose columns match what your import needs.

Drop a CSV or Excel file here

.csv, .xlsx, .tsv

Your file stays on your device. Column mapping runs in your browser — nothing is uploaded.

How it works

Step 1
Upload your file
CSV or XLSX. The file is read and processed in your browser — nothing is uploaded.
Step 2
Pick a destination
Choose HubSpot Contacts, Shopify Products, a generic contact list, or set up custom targets.
Step 3
Review & download
Auto-detected matches are pre-filled. Adjust any columns, then download the re-mapped file.

What it checks and fixes

Synonym matching

Common aliases like 'fname' → 'First Name', 'mobile' → 'Phone', 'organisation' → 'Company Name' are matched automatically.

Fuzzy matching

Columns with similar but not identical names (like 'E-mail Address' → 'Email') are suggested with a confidence score.

One-to-one assignment

Each source column is used at most once. The best match wins — no double assignments.

Multiple templates

HubSpot Contacts, Shopify Products and a generic CRM contact list are built in. More destinations are coming.

Why column names matter for imports

Most import tools match columns by name. If your file says 'E-mail' and the importer expects 'Email', the column is skipped or the import fails. Renaming manually is tedious and error-prone, especially with 20+ columns.

This tool does the renaming for you, using a database of common aliases and fuzzy matching. You still review every mapping before anything changes.

How auto-detection works

Each source column is compared against every expected column name plus its aliases. Exact name matches score 1.0. Known synonyms (like 'fname' for 'First Name') score 0.95. Partial token overlap and Levenshtein distance handle the rest.

Scores above 0.9 are auto-filled ('detected'). Scores between 0.6 and 0.9 are shown as suggestions. Below 0.6, the column is left unmapped — it's better to leave it blank than to guess wrong.

Frequently asked questions

Is my data uploaded?

No. Column mapping runs entirely in your browser. Your file stays on your device.

Does it rename my data, or just the headers?

Only the headers are renamed. Your data values are moved to the correct columns unchanged.

Can I add my own destination template?

Custom templates aren't built yet. Use the generic contact list and adjust the mapping manually for now.

What if my file has extra columns?

Columns that don't map to any expected field are left out of the downloaded file. The original file is untouched.

CSV Cleaner — Find duplicates, invalid emails and inconsistent formats — fix them in minutes.
Excel Cleaner — Clean .xlsx data without formulas or macros — leading zeros stay intact.
Remove Duplicates from CSV — Deduplicate by whole row, email, ID or several columns — you choose what to keep.
Remove Duplicates from Excel — Finds the duplicates Excel misses — and shows exactly which rows go.
Remove Duplicate Emails — One row per email address — even when capitals and spaces hide the duplicates.
Phone Number Normalizer — Convert messy phone numbers to one international format — +919876543210.
Date Format Standardizer — Mixed date formats to one — without guessing whether 03/04 is March or April.
Fix CSV Encoding — Garbled accents in Excel? Get clean UTF-8 that opens correctly everywhere.
Compare CSV Files — Find added, removed and changed rows between two versions of a file.
Merge CSV Files — Stack rows or join by a key — combine two files in seconds.
Validate CSV Data — Set rules for each column and find every row that breaks them.
Convert Excel to CSV — Upload an .xlsx and download a clean CSV — encoding, dates and leading zeros handled.
Convert CSV to Excel — Upload a CSV and get a clean .xlsx — leading zeros, dates and encoding handled.
CSV Viewer — Open any CSV in a clean table — encoding and delimiters detected automatically.
Remove Empty Rows — Find and remove blank, partial and whitespace-only rows in one click.
GSTIN Validator — Check GSTIN format in bulk — state code, PAN, entity code and check digit.
PAN Validator — Check PAN format in bulk — catch typos, truncation and invalid patterns.
Format Indian Phone Numbers — Normalize messy Indian phone numbers to +91 E.164 — in seconds.