Merge Columns
Combine two columns into one using coalesce logic
CSV Input
Try a sample:
Drop a CSV file here or
Only the first file is used if multiple are dropped.
The request is made directly from your browser. No proxy is used.
Options
Provide CSV input above to select columns.
CSV Output
Select two columns to merge...
More Options
CSV Format
Input
How to Use This Tool
This tool merges two columns into a single new column. For each row, it picks the non-empty value. When both columns have values, you choose how to handle the conflict. The original columns are preserved.
- Provide your CSV — Paste CSV text into the input area, drop a CSV file onto the File tab, or enter a URL on the URL tab.
- Select two columns — Choose the first and second columns to merge.
- Name the new column — Optionally set a name for the merged column.
- Set conflict handling — Choose what happens when both columns have values in the same row.
- Get your output — Copy the result to your clipboard or save it as a .csv file.
FAQ
4 questionsDoes this tool upload my data?
No. It runs entirely in your browser using JavaScript. Your CSV data is never sent to a server.
How does the merge work?
For each row, if only one column has a value, that value is used. If both are empty, the result is empty. If both have values, the conflict rule you selected determines the result.
Are the original columns removed?
No. Both source columns are preserved. A new merged column is added at the end of the output.
What counts as 'empty'?
A cell is considered empty only if it contains no characters at all. Whitespace-only values like spaces are treated as non-empty.