Remove duplicate rows in Excel
Drop your spreadsheet, choose which columns to match on, and download the clean file. Preview exactly which rows will be removed — nothing uploaded, 100% private.
Drag & drop your file here
.xlsx, .xls, .csv — one file at a time
How to remove duplicates in Excel online
- Drop your file
Load any .xlsx, .xls, or .csv spreadsheet. Your data never leaves your browser.
- Choose your dedup options
Match on all columns for exact-row duplicates, or pick specific key columns (e.g. Email, Order ID) to find rows that share the same value in those fields. Set keep-first or keep-last, and optionally ignore case or extra whitespace.
- Preview, then download
Duplicate rows are highlighted in the preview table so you can verify before committing. Click Download to get the clean .xlsx file instantly.
How to remove duplicates in Excel (built-in method)
Excel has a native Remove Duplicates feature. Here's how to use it — and when SheetToolkit gives you more control.
- Select your data range
Click any cell inside your table, or select the full range including headers.
- Open the Remove Duplicates dialog
Go to Data tab → Data Tools group → Remove Duplicates. A dialog will appear letting you choose which columns to check.
- Confirm and Excel removes them in-place
Excel removes the duplicates directly from your sheet and shows a count. There's no preview — the operation is immediate and modifies your file. Use Ctrl+Z to undo if needed.
When SheetToolkit is more useful: you want a preview before deleting, you need keep-last instead of keep-first, you want case-insensitive or whitespace-agnostic matching, or you're working with a file you'd rather not open in Excel.
Frequently asked questions
- How do I remove duplicate rows in Excel?
- Use the tool above: drop your file, configure options, and click Download. The clean .xlsx file is generated instantly in your browser. Alternatively, Excel's built-in Data → Remove Duplicates modifies the file in-place.
- What is the difference between Excel's Remove Duplicates and SheetToolkit?
- Excel removes duplicates immediately without showing you which rows will be deleted. SheetToolkit highlights duplicate rows in a preview table before you download, so you can verify the result. It also adds options Excel lacks: keep last, ignore case, and ignore leading/trailing spaces.
- Can I remove duplicates based on one column only?
- Yes. Switch to Selected columns mode and check only the column you want to match on (e.g. Email, Customer ID). Two rows are duplicates only if that specific column matches — other columns can differ.
- Does it keep the first or last duplicate?
- Your choice. Keep first retains the earliest occurrence and removes later ones. Keep last keeps the most recent — useful when records are ordered by date and the latest entry is the most accurate.
- What does "ignore case" do?
- When enabled, "Alice" and "ALICE" are treated as the same value. Useful for email addresses, names, and codes that may have inconsistent capitalisation.
- What does "ignore leading/trailing spaces" do?
- When enabled, " foo " and "foo" are treated as the same value. This catches duplicates caused by accidental spaces that would otherwise slip through.
- Is my file private?
- Completely. All processing runs entirely in your browser. Your spreadsheet is never sent to any server. You can disconnect from the internet after the page loads and the tool still works.
- What is the free row limit?
- Free users can process files up to 5,000 rows. SheetToolkit Pro lifts all limits with a one-time payment — no subscription.