UlvixorMerge CSV Columns
Combine two or more columns of a CSV into a single new column, using the separator you choose (space, comma, hyphen, or a custom one), and decide whether to keep or remove the original columns. Everything is processed in your browser, with no file ever uploaded to a server.
How it works
- Paste your CSV with a header row into the input panel (or use the built-in example).
- Select the two or more columns you want to merge from the automatically detected list.
- Choose a preset separator or type a custom one, and set the name of the new column.
- Decide whether to keep or remove the original columns in the result.
- Copy the resulting CSV or download it as a .csv file.
Use cases
- Combine first-name and last-name columns into a single full-name column.
- Merge address fields (street, city, zip code) into one full-address column.
- Create a combined identifier from several columns of an exported CSV.
- Simplify a spreadsheet before importing it into a system that expects fewer columns.
Use cases
- Combine first-name and last-name columns into a single full-name column.
- Merge address fields (street, city, zip code) into one full-address column.
- Create a combined identifier from several columns of an exported CSV.
- Simplify a spreadsheet before importing it into a system that expects fewer columns.
Common mistakes
- Selecting a single column and expecting the tool to merge it with something.At least 2 columns need to be selected; the tool shows an error if you pick fewer than two.
- Using a name for the new column that already exists in the CSV.The tool detects the conflict and asks you to choose another name before generating the result, so it doesn't accidentally overwrite an existing column.
- Not realizing the merge order depends on the order you selected the columns in, not their original order in the CSV.Check the order in which you checked each column, since that's the order the values are merged in with your chosen separator.
Frequently asked questions
No. Merging columns happens entirely in your browser. Your CSV never leaves your device or gets uploaded anywhere.
Yes, you can select as many columns as you need (minimum two). They'll be merged in the order you select them, using your chosen separator between each value.
If you turn on 'Keep', the original columns stay in the CSV alongside the new merged column. If you choose 'Remove', only the new column takes their place.
You can choose between space, comma, hyphen, underscore, or no separator at all, or type your own custom separator (for example ' | ' or '/').
Alternatives
In a spreadsheet you can achieve the same thing with a formula like =CONCATENATE(A2," ",B2) or =A2&" "&B2. This tool applies the merge to every row of your CSV at once, with no formulas to write or drag down.