Excel Duplicate Remover
Remove duplicate spreadsheet rows using one or more selected columns
Separate multiple column names with commas. Leave blank to compare the complete row.
Excel Duplicate Remover — what it does
Remove duplicate rows from a worksheet by matching on one column, several columns, or the entire row, keeping either the first or last occurrence. Multi-column matching is the practical difference from simpler tools: two people sharing a surname are not duplicates, but two rows agreeing on name, email and date almost certainly are.
When this tool helps
- Deduplicating a contact sheet where the same person was entered from several sources.
- Cleaning double-keyed transactions by matching on reference, amount and date together.
- Collapsing a log to the latest entry per key by sorting by date and keeping the last occurrence.
How to use it
- Choose the Excel file and the worksheet.
- List the column names to match on, or leave blank to compare whole rows.
- Choose keep first or keep last.
- Process and download the deduplicated workbook.
Accuracy, limits, and good practice
- Whole-row comparison is strict: one differing cell anywhere keeps both rows. Use targeted columns to catch near-duplicates.
- Trailing spaces and case differences defeat matching — run the blank cleaner first when data was hand-typed.
- Keep-last only means "most recent" if the sheet is sorted chronologically; sort before deduplicating.
- Count the rows before and after. A deduplication that removed far more than expected usually means the matching columns were too narrow.
Frequently asked questions
How do I match on several columns?
List the column names separated by commas. Rows must agree on every listed column to count as duplicates.
Can I see which rows were removed?
Compare the before and after with the worksheet comparison tool, which lists differing rows explicitly.
Does it work across worksheets?
Deduplication runs within the selected worksheet. Merge sheets first if duplicates may span them.
Does it preserve the original row order?
Surviving rows keep their relative order, so the sheet reads as it did minus the removed duplicates.
Related tools on this site
- CSV Delimiter Converter — Convert comma, semicolon, tab, or pipe-delimited data
- CSV Transposer — Swap CSV rows and columns and download the result
- Excel to JSON — Convert a selected worksheet into object arrays or row arrays
Everything above runs inside this page. Excel Duplicate Remover needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
Excel 重複資料清理能做什麼
依單一欄位、多個欄位或整列比對，移除工作表中的重複資料列，並可選擇保留第一筆或最後一筆。多欄比對正是它與簡單工具的實用差異：兩個人同姓不算重複，但姓名、信箱與日期三者皆同的兩列，幾乎可以肯定是。
什麼時候用得上
- 清理由多個來源重複輸入同一人的聯絡表。
- 以單號、金額與日期聯合比對，清除重複入帳的交易。
- 先依日期排序、保留最後一筆，把日誌收斂成每個鍵值的最新紀錄。
使用步驟
- 選擇 Excel 檔案與工作表。
- 列出比對用的欄位名稱，留空則比對整列。
- 選擇保留第一筆或最後一筆。
- 執行處理並下載去重後的活頁簿。
精確度、限制與實務建議
- 整列比對非常嚴格：任何一格不同就兩列都留。想抓近似重複，請指定關鍵欄位。
- 尾端空格與大小寫差異會讓比對失效——手動輸入的資料請先跑空白清理。
- 「保留最後一筆」只有在工作表已按時間排序時才等於「最新」；去重前請先排序。
- 請比對處理前後的列數。刪掉遠多於預期的資料，通常代表比對欄位選得太少。
常見問題
怎麼用多個欄位比對？
以逗號分隔列出欄位名稱。所有列出的欄位都相同，兩列才視為重複。
能看到被移除的是哪些列嗎？
用工作表比較工具比對處理前後兩份檔案，即可明確列出差異列。
可以跨工作表去重嗎？
去重在所選工作表內進行。若重複可能跨表，請先合併工作表。
會保留原本的列順序嗎？
保留下來的列維持原本的相對順序，因此工作表看起來就是原樣扣掉被移除的重複。
本站相關工具
- CSV 分隔符轉換 — 轉換逗號、分號、Tab 或直線分隔資料
- CSV 行列互換 — 交換 CSV 的資料列與欄位並下載結果
- Excel 轉 JSON — 將指定工作表轉換為物件陣列或二維陣列
以上步驟全部在這個頁面內完成，Excel 重複資料清理 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。