Clean an .xlsx of repeated rows and get an .xlsx back, numbers and dates kept
Processed in your browser. Nothing is uploaded. Checked against sources on 17 Oct 2026.Excel has a Remove Duplicates button, but it changes the sheet in place and does not show what it deleted. Drop the .xlsx here instead: pick the columns that identify a row, see the rows that will go before anything is removed, and download a new workbook with the numbers, dates and number formats of the kept rows unchanged. The removed rows can be saved as their own file to check later.
Drop your files or click to choose them.
Adjust the options and check the preview.
Download the result. Nothing was uploaded.
Duplicate rows creep in whenever two exports are combined, a form is submitted twice or a list is copied from several places. Finding them by eye stops working after a few hundred rows.
See it before it happens. As soon as the file is read, the page counts the duplicates and lists the first rows that would be removed, with their row numbers. Changing an option updates the count at once. When the Download button is pressed, the cleaned file is saved, and the removed rows can be saved separately to check.
The format you started with. A CSV comes back as a CSV with the same delimiter, so a semicolon file from a European Excel stays a semicolon file. An Excel workbook comes back as an .xlsx with the kept rows' numbers, dates and number formats unchanged; formulas are saved as their calculated values.
The rest of the article, and all 6 questions about Remove Duplicate Rows (CSV and Excel), are on the Remove Duplicate Rows (CSV and Excel) page.
Drop the CSV on Remove Duplicate Rows. Duplicates are counted at once, comparing whole rows, and the first rows that would be removed are listed. Tap a column such as Email to compare only that column, then press Download to save the cleaned CSV with its header and delimiter unchanged.
Drop the .xlsx here and tap the column that identifies a row, for example Customer ID. Rows with a value already seen in that column are removed and the first one stays. The download is a new .xlsx with the kept rows, their numbers, dates and formats unchanged.
The first copy of each repeated value is kept by default, and the kept rows stay in their original order. Tick Keep the last copy when the newest row should win, such as the latest address of a customer who signed up twice.
Yes. Before you download, a table lists the rows that will go with their row numbers. After that, Download the removed rows saves every removed row as its own file, with the header, so the cleaning can be checked or undone.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about Remove Duplicate Rows (CSV and Excel) and anybody who knows can answer. No account needed.
Same job, other tools: Markdown to Plain Text – Strip every Markdown mark and keep the words.
On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible.