Merge Columns in a CSV
Upload a CSV and combine several columns into a single column with the separator you choose. Great for building full names or addresses. Runs in your browser.
Using sample data
3 rows, 4 columns · Processed in your browser, never uploaded
Input preview
| first_name | last_name | city | state |
|---|---|---|---|
| Sarah | Johnson | Austin | TX |
| Michael | Chen | Seattle | WA |
| Emily | Watson | Denver | CO |
Want more than a quick fix?
Need smart merging — like building a clean mailing address with correct punctuation? The AI app handles formatting automatically.
How to merge columns in a CSV
- 1Upload your CSV file (or use the sample loaded above).
- 2Choose your options — columns and settings.
- 3Click "Merge columns" to process instantly in your browser.
- 4Download the clean CSV. Nothing is ever uploaded to a server.
Doing something more complex?
Read the guide: How to merge multiple columns into one in a CSV.
View guide →Need smarter csv transform?
Need smart merging — like building a clean mailing address with correct punctuation? The AI app handles formatting automatically.
Try AI transform free →FAQ
- Is the merge columns tool free?
- Yes. This tool is completely free, requires no account, and runs entirely in your browser. Your CSV file is never uploaded to a server.
- When should I use Magic CSV AI instead?
- Need smart merging — like building a clean mailing address with correct punctuation? The AI app handles formatting automatically.
- What file formats are supported?
- Upload any comma-separated CSV file. You can download the result as a clean CSV ready for Excel, Google Sheets, or database import.
More free CSV tools
Upload a CSV and instantly remove duplicate rows. Choose which columns define a duplicate, or match across every column. Your file never leaves your browser.
Remove Empty RowsUpload a CSV and strip out every blank row in one click. Perfect for cleaning up exports with scattered empty lines. Everything runs in your browser.
Delete ColumnsUpload a CSV and remove the columns you do not need. Select one or many, then download the trimmed file. Your data stays in your browser.
Split ColumnUpload a CSV and split a single column into multiple columns using any delimiter. Your file is processed in your browser and never uploaded.