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.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
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
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