CSV column combiner: join first name and last name, or any columns, into one
In short: Upload a list, tick the columns to join, pick a separator and name the new column. Blank cells can be skipped so the result has no stray spaces or commas. Limit: It joins the text of the cells; it does not check or fix what they hold.
Upload a CSV or .xlsx file, or paste it with a header row. Tick two or more columns, such as First name and Last name, choose what goes between the values and name the new column. Blank cells can be left out so there is no doubled separator, and the joined columns can be removed. Download the new file.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Four example rows get a Full name column: Ava Stone, Ben Hart, Lin and Dev, with no stray space where a name was blank.
- Rows
- 4
- Joined
- First name, Last name
- Separator
- Space
What this means for you
Joined names are not working mailboxes; a check shows which addresses exist.
- Two or more columns
- Your separator
- Blanks skipped
- Source columns optional
- Columns
- CSV
- Names
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Joined the columns? Check the addresses in the list before the send.
- Download the new file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I join two columns of a CSV into one?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Tick the columns to join, in the order you want them.
- Choose the separator, name the new column and decide whether to leave out blank cells.
- Download the file, with the joined columns kept or removed.
Example
- You enter
- Four rows with First name and Last name columns, joined with a space into Full name, blank cells left out.
- You get
- 4 rows with a Full name column added: Ava Stone, Ben Hart, Lin and Dev. The two rows with one blank name cell have no stray space.
- Limits
- Runs in your browser; nothing is uploaded. It joins the text of the cells and does not guess a missing name.
How are the columns joined?
The new column is added at the end of the list. Each value is trimmed, then the values are joined in the order you ticked the columns, with your separator between them. First name Ava and Last name Stone with a space between give Ava Stone.
With leaving out blank cells on, a row with no last name gives just the first name, with no trailing space. With it off, the separator is still written, so a blank cell leaves a space or comma behind.
What can I join besides names?
Any columns: street, city and state into one address line with a comma between them; a city and a country; a campaign and a date into a tag. Type \t for a tab or \n for a line break as the separator.
To go the other way and split a full name into first and last, use split full name. To tidy first names for a mail merge, see the first name cleaner.
What does it not do?
It joins text and does not guess a name from an email address. It does not change the cells you join; they stay in the file unless you remove them. To rename, reorder or delete columns, use the CSV column editor. See also clean CSV columns before import.
Who uses this tool, and for what?
- Cold emailers
- Build a Full name column for a sending tool that wants one field.
- Marketers
- Join street, city and state into one address line for a mail-merge.
- Analysts
- Make a key column from two fields before matching against another list.
What can’t this tool tell you?
- It joins the text of the cells; it does not check or fix what they hold.
- Only the first sheet of a workbook is read.
- It adds one new column per pass.
- It does not check whether an address exists.
Common questions
- Where does the new column go?
- At the end of the list. Drag it where you need it with the CSV column editor, or in your spreadsheet.
- Can I join more than two columns?
- Yes. Tick as many as you like; they are joined in the order you tick them.
- What if one of the cells is empty?
- With leaving out blank cells on, it is skipped with no stray separator. With it off, the separator is still written.
- Can I use a tab or a line break as the separator?
- Yes. Type \t for a tab or \n for a line break.
- Does the list need an email column?
- No. Any CSV works. If it has a column of addresses, the check button under the result carries them across.
- Is my file uploaded?
- No. The file is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.