How to Split a Full Name Column Into First Name and Last Name

Your CRM export has a "Full Name" column. Your import template wants "First Name" and "Last Name" in separate columns. This mismatch is one of the most common friction points in any data migration — and it has nothing to do with the data itself. It is just a structural problem.

The CSV Column Mapper handles this with its column split feature. You choose the "Full Name" column, set the delimiter (a space), and the tool creates two new columns — one for the first name, one for the last name. No formulas, no Python, no spreadsheet gymnastics.

This guide walks through the split process, common edge cases like middle names and hyphenated surnames, and how to finish the column layout for a clean import.

Why CRMs Want Separate Name Fields

Most CRMs — Salesforce, HubSpot, Mailchimp, Klaviyo, ActiveCampaign — store first and last name as separate properties. When you import a list with a combined "Full Name" column, the import either fails, or the entire name ends up jammed into the first name field.

The reason CRMs separate names is personalization. When a system sends "Hi John," it pulls from the first name field specifically. A full name field breaks that. It also breaks alphabetical sorting by last name, filtering by surname, and any merge field that references first name only.

Splitting the column before import fixes all of this at the source. You bring clean, correctly structured data in — rather than fixing individual records after the fact.

Step-by-Step: Split a Name Column

Open the CSV Column Mapper and upload your CSV file.

1. Find the Full Name column in the column list
2. Click the Split icon on that column
3. Set the delimiter to a space character
4. Name the two output columns "First Name" and "Last Name"
5. Delete the original Full Name column if you no longer need it
6. Drag the new columns into the position your import template expects
7. Download the updated CSV

The split happens in your browser — nothing is uploaded to a server. Your CSV stays private throughout.

Sell Custom Apparel — We Handle Printing & Free Shipping

Middle Names, Suffixes, and Edge Cases

A space delimiter splits on the first space, giving you "John" and "Smith" for "John Smith." But "John Michael Smith" becomes "John" and "Michael Smith" — the middle name attaches to the last name.

Common edge cases to know before splitting:

• Middle names: If your data has "First Middle Last," you may want to split into three columns or accept that middle names go with last name
• Hyphenated last names: "Mary Jones-Williams" splits cleanly on space — "Mary" and "Jones-Williams" — hyphens are not treated as delimiters
• Suffixes like Jr. or III: "Robert Smith Jr." splits into "Robert" and "Smith Jr." — the suffix stays with the last name, which most CRMs handle fine
• Single-name entries: A row with just "Madonna" will put the full value in the first output column and leave the second blank

For most contact lists, these edge cases affect a small fraction of rows. Clean the outliers manually after import if the volume is low enough.

Finishing the Column Layout

After splitting, you likely need to match the exact column order your import template expects. Most CRM import wizards are column-position-sensitive or column-name-sensitive — or both.

With the Column Mapper still open, drag the First Name and Last Name columns into the correct positions. Rename any other columns that need to match the import template. Then delete columns that are not needed for the import — the tool lets you remove any column with one click.

This all happens in a single pass: split, rename, reorder, delete, download. You do not need to open Excel, run a formula, or write a script. The resulting CSV is ready to upload directly into your CRM's import tool.

Other Column Changes Needed Before Import

Splitting a name is usually one of several structural fixes an exported CSV needs before it can be imported elsewhere. Other common issues:

• Column names use spaces or special characters that the target system does not accept — rename them
• Columns are in the wrong order — drag them into position
• The source CSV has extra columns the target does not need — delete them
• Two separate columns (city and state) need to be combined into a single address field — use the merge feature

The CSV Column Mapper handles all of these in one place. You do not need multiple tools or multiple passes through the file.

Frequently Asked Questions

What delimiter should I use to split a full name column?

A single space works for most names formatted as "First Last." If names are formatted as "Last, First" (common in contact exports), use a comma as the delimiter instead.

What happens if a name cell is empty?

Empty cells stay empty after the split. Both the first name and last name output columns will be blank for that row — no error, no data loss.

Can I split into more than two columns?

The split feature creates two columns. For three-part names, split on the first space to get first name and "rest of name," then handle middle names as part of last name or clean them separately.