About Column Merger
Merge two or more columns into a single combined column using custom separators or templated format strings (e.g. {0} - {1} ({2})). Ideal for combining First and Last Name, Address components, or product codes.
Key Capabilities & Features
- Multi-select any combination of columns to merge together
- Custom separator string (e.g. space ' ', comma-space ', ', hyphen ' - ')
- Advanced templated syntax support: format values using placeholders like {0} - {1} ({2})
- Specify a new custom column header for the merged output
- Removes the original individual columns and replaces them with the unified column
- Zero data transmission: 100% private in-browser computation
How to Use Column Merger
1
Select Columns
Choose two or more columns to merge from the selection list.
2
Configure Separator or Template
Specify the character separating values or enter a template string like {0} {1}.
3
Merge & Download
Click 'Merge Selected Columns' to produce the updated dataset.
Privacy & In-Browser Execution Guarantee
100% client-side privacy. All calculations, parsing, and charting execute locally in your browser with zero server uploads.
Frequently Asked Questions
Can I merge more than two columns at once?
Yes! You can select 3, 4, or more columns to combine into a single column.
How does template merging work?
You can use {0}, {1}, {2} to represent each selected column, allowing custom formatting like '{0}, {1} ({2})'.
Related Tools in this Suite
Column Splitter
Split a single column into multiple columns by delimiter or fixed character width
Data Cleaner
Clean messy spreadsheets: trim whitespace, strip invalid chars, normalize casing, and fill nulls
CSV Editor
Interactive spreadsheet editor to modify, add, and delete CSV cells with formula calculations
Sort CSV
Sort CSV spreadsheet data by numeric, alphabetical, date, or length order