Free Tools /Development
CSV Column Mapper
Paste two column header lists and get confidence-scored field-mapping suggestions using real fuzzy matching, not just exact-name comparison.
How this tool works
Real fuzzy matching, not exact-match only
Uses Levenshtein edit-distance and common naming-convention normalization (removing underscores, spaces, case) to score every possible pairing, not just flag identical column names.
Confidence-scored suggestions
Every suggested mapping shows a confidence percentage, so you know at a glance which pairings are safe to trust and which need a manual look.
Handles common naming mismatches
Correctly scores "Full Name" against "full_name" or "fullName" as a strong match despite the different formatting, the exact case that breaks a naive exact-match approach.
Frequently asked questions
How does the confidence score actually work?
Each target column is compared against every source column using normalized Levenshtein similarity (case, spacing, and punctuation-insensitive) plus a bonus for exact substring containment. The highest-scoring pair becomes the suggestion, and its raw similarity score becomes the confidence percentage shown.
Why did it suggest a mapping I know is wrong?
Fuzzy matching works on how similar the names look, not what the data actually contains. "Country" and "County" are similar-looking strings but different fields entirely, always review suggestions below roughly 80% confidence rather than trusting them blindly.
Can this tool actually migrate my data, or just suggest the mapping?
This tool only suggests the column mapping itself, it does not move or transform your actual data rows. Use the confirmed mapping to configure the field-mapping step in your CRM's import tool or an n8n Set node.
What if a source column has no good match at all?
It is shown with a low confidence score and flagged for manual review rather than forced into an incorrect mapping, a genuinely unmapped field is safer than a confidently wrong guess.
Does this handle one-to-many mappings, like splitting "Full Name" into first and last name?
No, this tool suggests one-to-one column pairings only. A field that needs to be split or combined (like Full Name into First/Last) requires a transformation step, not just a rename, typically handled in an n8n Code or Set node after the initial mapping.
More free tools
Cron Expression Builder & Explainer
Turn any cron expression into plain English, or build one from scratch.
n8n Workflow JSON Validator
Paste your workflow JSON, catch orphaned connections and missing credentials before you import it.
n8n Expression Tester
Test {{$json.field}} style expressions against real sample data and see the exact output before pasting into n8n.