How to Merge Two CSV Columns Into One (Free)

By ZeroFee Tools · October 4, 2026 · 7 min read

Spreadsheet data often arrives split into more columns than you need. A contact export keeps first name and last name apart, but your email platform wants a single full-name field. A supplier feed separates city and postcode, but your shipping labels need them together. Manually joining thousands of rows with copy and paste is slow and invites typos. A CSV column combiner merges two or three columns into one: choose the columns in order, pick a separator, name the new column, and download the merged file.

Merging is the mirror image of splitting, and data projects usually need both. Analysts combine name parts for mail merges, shop owners join SKU segments for marketplace uploads, and marketers build full addresses for direct mail. Merged columns also simplify pivot tables and reports. If your columns need dividing instead, use the CSV column splitter, and run the result through the CSV cleaner before importing it anywhere.

How do I merge columns in the right order with the right separator?

Select the columns in the order they should read, first name before last name, street before city, and choose the separator your destination expects: a space for names, a hyphen for SKU parts, a comma for address lines. The order and separator define the merged value. Preview the result before downloading the file.

Column order is everything. For a full name, the first-name column must come before the last-name column, or you get Doe John instead of John Doe. For an address, the natural reading order is street, then city, then postcode. The tool lets you pick the columns in the exact sequence they should join, so think about how the merged value will be read before you press the button. A quick way to verify order is to read three merged rows aloud; reversed names and jumbled addresses are obvious to the ear.

The separator shapes the result too. Names join with a space, city and postcode often join with a space as well, but SKU parts might join with a hyphen, like SHOE-RED-42. Pick the separator your destination expects. A marketplace that parses SKUs on hyphens will reject the same parts joined with spaces, so check the import specification first. When the destination is a marketplace, copy the separator rule from its seller documentation rather than guessing.

What happens to empty cells when columns are combined?

Empty cells are skipped before joining, so gaps never create doubled spaces, doubled hyphens, or trailing separators. The merged value contains only the parts that exist, and sorting the new column afterwards reveals which rows were incomplete. Fill or exclude those rows deliberately before importing.

Real data has gaps. A contact without a middle name, a product without a colour variant, an address without a second line. A naive join would produce John Doe with a doubled space or SHOE--42 with a doubled hyphen, and those artefacts break matching and look unprofessional in a mail merge. These artefacts also break exact-match lookups, so a file with doubled separators will fail the same VLOOKUPs that clean data passes.

This tool skips empty cells before joining, so a missing middle name never produces a doubled space or a trailing separator. The merged value contains only the parts that exist, cleanly separated. After merging, sort by the new column and scan the top and bottom: unusually short values flag the rows that were missing data, which you can then fill or exclude deliberately instead of discovering them after the import.

Should I keep the original columns after merging?

Keep the originals while verifying the merge, since they are your audit trail for spotting bad source data. Delete them once the merged column has survived sorting, filtering, and a test import, so the final file matches what your destination expects.

Keep the originals while you are still checking the merge. They are your audit trail: if a merged value looks wrong, you can compare it against the source columns instantly. This matters most when the source data had inconsistencies, like a first-name column that occasionally holds a full name. This is especially important when the source data came from another team, since you cannot assume their columns were consistent.

Drop them when the merged column replaces them for a final import. A CRM that expects one full-name field will be confused by leftover first-name and last-name columns, and they bloat the file. The right moment to delete is after the merged column has survived a sort, a filter, and a test import. Until then, the originals cost nothing and save you from re-running the merge.

How to use the CSV Column Combiner in 4 steps

1. Paste your CSV and press Load columns. Drop the file into the tool so it can read the headers and list the available columns.
2. Pick the columns in order. Choose the first, second, and optionally third column in the sequence they should join, such as first name then last name, or street then city then postcode.
3. Choose a separator and name the new column. Use a space for names, a hyphen for SKU parts, or a comma for address lines. Give the merged column a clear name like full name.
4. Download the merged CSV. Check that the merged values read correctly, then download. Keep the original columns until the merge is verified, then remove them for the final import.

5 practical tips for clean column merges

• Check the import spec first. Your destination decides the separator. A marketplace that parses SKUs on hyphens needs hyphens; an email tool that displays names needs spaces. Match it before merging.
• Merge in reading order. First name before last name, street before city before postcode. Read three merged rows aloud; if they sound wrong, the column order is wrong.
• Handle three-part values in one pass. Street, city, and postcode can merge together with the same separator. Doing it in one pass keeps the operation reversible and the audit trail simple. Fewer passes mean fewer chances to introduce errors.
• Sort the new column to spot gaps. After merging, sort ascending. The shortest values reveal rows that were missing parts, which you can fill or exclude before import.
• Pair with the splitter for reshaping. Split a bad combined column with the column splitter, fix the pieces, then recombine them correctly. The two tools together reshape almost any column layout.

Frequently asked questions