- What file formats are supported?
- Maplesheet's duplicate finder accepts .xlsx and .csv files. CSVs are converted to a workbook automatically when you open them, so the same column / row / range controls apply.
- How is fuzzy duplicate detection different from exact match?
- Exact matching only flags cells with identical text. Fuzzy matching also catches near-duplicates that differ by typos, extra whitespace, punctuation, or letter case. Use the similarity slider to control how close two values have to be before they are grouped together.
- Can I find duplicates across multiple columns?
- Yes. In the search-in selector pick "Range" and enter the columns you want to scan (for example "A, C, E" or "A:D"). Row ranges like "2:500" are also supported.
- What happens to the duplicate rows when I click Apply?
- The first cell in each group is kept and the rows, columns, or cells you selected are removed. Charts, pivot tables, and data validations in your original file are preserved because the cleaned workbook is generated from your uploaded .xlsx, not from a re-serialized copy.
- Can I download the cleaned spreadsheet?
- Yes. After Apply finishes, a Download button appears that saves the deduplicated workbook as deduplicated.xlsx.
- Does it handle case and whitespace differences?
- Yes. Lower the similarity threshold and the matcher will group "Acme Corp", "acme corp ", and "ACME Corp" into the same duplicate group.
- Can I find duplicate invoice numbers or transactions?
- Yes. Scan the column that holds the invoice numbers, transaction IDs, or amounts — exact matching flags identical values, and fuzzy matching also catches variants with extra spaces or typos before they reach your report.