Remove repeated rows using all cells or selected columns, keeping the first or last occurrence.
Local openpyxl processing. No subscription or external content-processing API.
How to use Remove Duplicate Excel Rows
Choose XLSX or UTF-8 CSV files. Uploads are processed temporarily on KTAS servers, not by external APIs.
Review the limitations. Formulas are never evaluated; saving XLSX clears existing formula caches.
Download the result and review it in a spreadsheet editor. Keep your original workbook.
Options
Worksheet name (blank = all): Exact worksheet name; leave blank for all sheets.
Keep first row as a header
Match column numbers (blank = all): Comma-separated column numbers, starting at 1: A = 1, B = 2. For example, 1,3 compares A and C. Each column must exist in every selected worksheet.
Which duplicate row to keep: First or last means its original position, not a date sort. Retained rows stay in their original order.
Important limitations
Matching is exact and type-sensitive; text, numbers and booleans differ. Case and whitespace are not normalized. Repeated empty keys are duplicates too. Headers are excluded when enabled; each worksheet is matched separately. Row-removing tools reject formula workbooks, merged cells, filters, print areas, validation and advanced structures to avoid broken references.