Home / Office & Sheets / Remove Duplicate Rows
Remove Duplicate Rows
Delete repeated rows from Excel or CSV, matching on all columns or the ones you pick, ignoring case and spaces.
Free, no uploads, no sign-up. Runs 100% in your browser.
How Remove Duplicate Rows works
Files are opened in your browser with SheetJS and JSZip. Nothing is uploaded, and your original file is never changed. You keep the first or last copy, and can download the removed rows to check them.
Input: XLSX, XLS, ODS, CSV. Output: XLSX, CSV, ODS.
How to use Remove Duplicate Rows
- Drop a spreadsheet.
- Pick the columns that define a duplicate.
- Choose first or last copy and the matching options.
- Download the clean file.
Tips
- Excel, ODS and CSV all work. Formulas are read as their last saved values.
- For CSV files with odd characters, save them as UTF-8 first.
Remove Duplicate Rows FAQ
- Are my files uploaded?
- No. This tool runs entirely in your browser tab. Files are read from your disk into memory and the result is generated locally.
- Is it free? Are there limits or watermarks?
- Free and open source (MIT). There are no file-size caps, daily quotas, accounts or watermarks.
- Does it work offline?
- Yes, once the page (and any engine it needs) has loaded, it keeps working without a connection thanks to the service worker cache.
Related tools
- Spreadsheet Cleaner: Trim spaces, remove hidden characters and blank rows or columns, fix number text, change case, fill down and transpose.
- Sort & Filter Rows: Sort a spreadsheet by several columns and keep only rows that match your rules, then save a new file.
- CSV & Spreadsheet Editor: Edit CSV and Excel files in a fast grid: sort, filter, dedupe, find and replace, split and merge.
- Merge Excel Files: Combine sheets from many Excel, ODS or CSV files into one workbook, or stack their rows into one table.