Split CSV by Column
Create separate CSV files for each field value
Split CSV by Column — what it does
Choose a column and the tool creates one CSV per distinct value in it, each containing only the matching rows, all packed into a ZIP. A combined export becomes a file per region, per salesperson or per month in a single step, with the header preserved in every output.
When this tool helps
- Sending each branch or account manager only the rows that belong to them.
- Separating a consolidated report back into per-department files for distribution.
- Producing one file per status or category so each can be processed by a different workflow.
How to use it
- Choose the CSV file.
- Select the column to split on.
- Process the split.
- Download the ZIP of per-value files.
Accuracy, limits, and good practice
- Split on a column with a manageable number of distinct values; splitting on an ID column produces one file per row.
- Values that differ only in case or spacing create separate files, so normalise the column first if the source was typed by hand.
- Filenames come from the column values, so characters that are illegal in filenames are adjusted in the output names.
Frequently asked questions
How many files will I get?
One per distinct value in the chosen column. Run the column statistics tool first to see the unique count before splitting.
Do the parts keep the header?
Yes, every file gets the full header row, so each opens independently in any spreadsheet or importer.
What happens to blank values?
Rows with an empty value are grouped into their own file, which makes uncategorised records easy to spot.
Related tools on this site
- CSV Column Reorder — Change CSV column order before downloading
- CSV Row Splitter — Split a CSV into smaller files by row count
- Excel Row Sorter — Sort worksheet rows by a selected column
Everything above runs inside this page. Split CSV by Column needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
依欄位拆分 CSV能做什麼
選定一個欄位，工具會依該欄的每個不重複值各產生一份 CSV，只包含對應的資料列，並統一打包成 ZIP。一份彙總匯出檔，一步就能變成依地區、依業務或依月份分開的檔案，且每份都保留標題列。
什麼時候用得上
- 只把屬於各分店或各業務的資料寄給對應的人。
- 把彙總報表拆回各部門檔案以便分送。
- 依狀態或分類各產生一份檔案，交給不同流程處理。
使用步驟
- 選擇 CSV 檔案。
- 選定作為拆分依據的欄位。
- 執行拆分。
- 下載依值分檔的 ZIP。
精確度、限制與實務建議
- 請挑不重複值數量合理的欄位；用識別碼欄位拆分會變成一列一個檔案。
- 只差在大小寫或空白的值會被分成不同檔案，若來源為手動輸入，建議先統一格式。
- 檔名取自欄位值，因此不允許出現在檔名中的字元會在輸出名稱中被調整。
常見問題
會產生幾個檔案？
依所選欄位的不重複值數量而定。拆分前可先用欄位統計工具查看不重複值有幾個。
各檔案都有標題嗎？
有，每份都會寫入完整標題列，可獨立在任何試算表或匯入程式中開啟。
空白值怎麼處理？
值為空的列會集中成獨立一份檔案，方便找出尚未分類的紀錄。
本站相關工具
- CSV 欄位重新排序 — 調整 CSV 欄位順序後下載
- CSV 按行數拆分 — 依指定行數將 CSV 拆分成多個檔案
- Excel 資料列排序 — 依指定欄位排序工作表資料列
以上步驟全部在這個頁面內完成，依欄位拆分 CSV 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。