A CSV column combiner is a free online tool that merges two or three columns into one. Combine first and last names, join city and postcode, or glue SKU parts together: choose the columns in order, pick a separator, name the new column, and download the merged CSV.
How do I merge two columns in a CSV file?
Short answer: Paste your CSV, press Load columns, and pick the first and second columns in the order they should join. Type a separator (a space for names, a comma for city and region), name the new column, and press Combine columns. The merged CSV appears below, ready to copy or download.
Add the optional third column for compound values such as street, city, and postcode in a single address field.
What happens to empty cells when combining?
Short answer: Empty cells are skipped before joining, so a missing middle name never produces a doubled space or a trailing separator. A row where all chosen cells are empty becomes an empty merged cell, keeping the row aligned with the rest of the data.
This makes the combiner safe for real-world exports where some rows have missing values.
Should I keep the original columns?
Short answer: Drop them when the merged column replaces them for a final import, for example full name replacing first and last. Keep them when you want both forms available, such as a display name alongside the parts for filtering. The merged column is appended at the end when originals are kept.
Either way, headers, quoting, and row order are preserved exactly.
Frequently asked questions
Is this CSV column combiner free?
Yes. Combine unlimited columns with no account and no limits. It runs entirely in your browser.
How many columns can I merge?
Two or three. Pick a third column from the optional dropdown for compound values; leave it on None for a simple two-column merge.
Which separator should I use?
A space for full names, a comma for city and region, a hyphen for compound SKUs, or a pipe when values may contain commas. Type any text you like.
Does the merge handle quoted commas?
Yes. Fields are joined by their real values, then re-quoted properly, so a merged value containing the delimiter stays one field.
Is my data uploaded anywhere?
No. Combining happens locally in your browser, including uploaded files.