> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/tools/remove-duplicates.md).

# Remove duplicate rows from Excel or CSV online

A free Duaer tool: open an Excel or CSV file, pick the columns that define a duplicate, keep the first row, optionally ignore case and spaces, and see how many rows were removed. No upload.

Interactive converter (runs in the browser, no upload): https://doc.duaer.com/tools/remove-duplicates/

## How to use it

1. Drop an Excel or CSV file into the box above, or paste CSV and click "Convert".
2. Tick the columns that define a duplicate, such as only "Phone"; tick none to compare whole rows.
3. Check how many rows were removed, then click "Download .xlsx" or "Download .csv".

## Rules

- Rows are read top to bottom; the first row for each key stays and later ones are removed. To keep the newest, sort by date descending in Excel first.
- Cells are compared by displayed text. With "Ignore case and surrounding spaces", `A@x.com ` and `a@x.com` count as duplicates.
- For Excel files, the first sheet is read.

## Automate it in Duaer

In Duaer, use the [Remove Duplicates](/integrations/builtin/core-nodes/duaer-nodes-base.removeduplicates.md) node with Remove Items Repeated Within Current Input and the fields to compare. To skip items seen in earlier runs, use Remove Items Processed in Previous Executions. See [Remove duplicates](/snippets/remove-duplicates.md).
## Questions

### How do I keep the last occurrence instead?

The Duaer tool keeps the first occurrence. Sort the table newest first in Excel, then deduplicate with Duaer to keep the latest row.

### Can I see which rows were removed?

The Duaer tool reports only the count. To review rows one by one, highlight duplicates with conditional formatting in Excel first.

## Related

- [Free file converters from Duaer](https://doc.duaer.com/tools.md)
- [Merge Excel and CSV files online (columns matched by header)](https://doc.duaer.com/tools/merge-excel-files.md)
- [Split an Excel table by column online (one sheet per value)](https://doc.duaer.com/tools/split-table-by-column.md)
- [Remove duplicates in Duaer, within a run and across runs](https://doc.duaer.com/snippets/remove-duplicates.md)