CSV Column Merger
Combine selected CSV columns into a new field
CSV Column Merger — what it does
Combine two or more CSV columns into a single new field using any separator you choose, and optionally drop the source columns from the output. It handles the everyday joins that spreadsheets make tedious: first and last name into a full name, street and city into one address line, or several codes into a composite key.
When this tool helps
- Building a full-name column from separate first and last name fields before a mail merge.
- Creating a composite key such as region-year so two datasets can be joined on a single field.
- Flattening address parts into one line for a shipping label export that expects a single address field.
How to use it
- Choose the CSV file.
- Select the columns to combine, in order.
- Set the new column name and the join separator.
- Decide whether to remove the source columns, then download the result.
Accuracy, limits, and good practice
- A space separator suits names, a hyphen or underscore suits keys, and a comma inside a value forces quoting in the output.
- Blank source cells produce doubled separators such as two spaces; clean missing values first if the result feeds a label or a key.
- Keep the source columns when the merged field is for display only — you will usually want the components back later for sorting.
Frequently asked questions
Where does the new column appear?
It is appended to the row, and the source columns are either kept in place or removed depending on the option you selected.
Can I merge more than two columns?
Yes, select as many as you need. They are joined in selection order with the same separator between each pair.
Does this change the number of rows?
No. Merging works across columns within each row, so the row count is identical before and after.
Related tools on this site
- Excel Sheet Reorder — Change worksheet tab order and download the reordered workbook
- JSON Path Extractor — Extract nested values using dot paths, indexes, and wildcards
- CSV Group & Aggregate — Group rows and calculate sum, average, count, min, or max
Everything above runs inside this page. CSV Column Merger needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
CSV 欄位合併能做什麼
用你指定的分隔符把兩個以上的 CSV 欄位合併成一個新欄位，並可選擇是否從輸出中移除來源欄位。它處理的正是試算表裡最瑣碎的那些合併：姓與名合成全名、街道與城市合成單行地址，或把幾個代碼組成複合鍵。
什麼時候用得上
- 郵件合併前，把分開的姓、名欄位組成全名欄位。
- 建立「地區-年份」這類複合鍵，讓兩份資料能以單一欄位關聯。
- 把地址各部分攤平成一行，供只接受單一地址欄位的物流標籤匯出使用。
使用步驟
- 選擇 CSV 檔案。
- 依順序選取要合併的欄位。
- 設定新欄位名稱與連接分隔符。
- 決定是否移除來源欄位，再下載結果。
精確度、限制與實務建議
- 姓名適合用空格，鍵值適合用連字號或底線；值中含逗號時輸出會自動加引號。
- 來源儲存格為空時會產生連續分隔符（例如兩個空格），若結果要做標籤或鍵值，建議先清理缺失值。
- 若合併欄只作顯示用途，請保留來源欄位，之後排序時通常還會需要原本的組成部分。
常見問題
新欄位會出現在哪裡？
會附加到每列末端；來源欄位則依你選擇的選項保留或移除。
可以合併超過兩欄嗎？
可以，要幾欄就選幾欄，會依選取順序以同一個分隔符逐一連接。
資料列數會改變嗎？
不會。合併是在每一列內跨欄進行，前後列數完全相同。
本站相關工具
- Excel 工作表排序 — 變更工作表順序並下載重新排序的活頁簿
- JSON 路徑提取 — 使用點路徑、索引和萬用字元提取巢狀資料
- CSV 分組彙總 — 依欄位分組並計算加總、平均、計數、最小或最大值
以上步驟全部在這個頁面內完成，CSV 欄位合併 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。