Column Merger
Combine several columns into one with a custom separator.
Join first and last name, or build a full address from parts, without writing a CONCATENATE formula. Choose the separator, decide how blanks are handled, and place the merged column wherever you want in the sheet.
- Rating
- 4.8(1.4K)
- Monthly uses
- 176K
- Price
- Free
or drag it here
.xlsx, .xls, .csv · processed locally, never uploaded
Files stay on your device
What it does well
- Drag to reorder the columns being merged
- Skip-blanks mode that avoids “John , , Smith” output
- Keep or remove the source columns after merging
How to use Column Merger
- 1
Upload the file and select the columns to merge, in order.
- 2
Set the separator — a space, comma, dash or anything you type.
- 3
Decide whether to skip blanks or keep the gaps.
- 4
Apply and download the workbook.
Watch a walkthrough
Common problems and fixes
Extra separators appear where a column is empty.
Turn on “Skip blanks” so consecutive separators collapse into one.
Dates merge as serial numbers.
Switch from raw to formatted value mode, or run the Date Formatter on the column first.
Frequently asked questions
What people say
Small thing, but the error messages actually tell you what to fix. Column Merger flagged a hidden character that had been breaking my lookups for weeks.
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
Small thing, but the error messages actually tell you what to fix. Column Merger flagged a hidden character that had been breaking my lookups for weeks.
More clean & format tools
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
Browse Clean & Format