Remove duplicates from Google Sheets safely.
Export the relevant sheet as CSV, clean it locally in your browser, and import the reviewed result as a separate sheet. This is a careful file workflow, not a direct Google Sheets connection.
1. Choose a CSV to clean
Your file opens directly in the local app. Contents stay in this browser; no account needed.
Up to 20 MiB, 100,000 rows and 500 columns.
- Choose CSV
- Profile and choose cleanup rules
- Review and download a new CSV
Export one sheet as CSV
In Google Sheets, choose the tab you want to clean and download it as a comma-separated values file. CSV contains cell values, so retain the original spreadsheet for formulas, formatting and other tabs.
Choose what makes a row duplicate
Remove rows only when every exported value matches, or select approved key columns such as customer ID. Avoid treating a similar name or shared email as proof without checking the business context.
Review exact and likely matches
Exact deduplication updates the preview and row count. Fuzzy suggestions show similar values separately and cannot delete rows, giving you a safer list for manual investigation.
Import the result separately
Download the cleaned CSV and import it into a new sheet or spreadsheet. Verify types, identifiers, formulas and downstream references before replacing any working data.
Frequently asked questions
Does this tool connect directly to Google Sheets?
No. Export one sheet as CSV, review and remove exact duplicates locally, then import the cleaned CSV as a separate sheet. Keep the original spreadsheet for formulas, formatting and other tabs.
Is my CSV uploaded when I clean it locally?
No. Local cleaning processes the CSV in this browser without an account. Temporary Loam mode is a separate option and uploads a copy only after you confirm it in the application.
Which files can I clean?
Local mode accepts one CSV up to 20 MiB, 100,000 rows and 500 columns. Export other formats as CSV first. Download your cleaned result before refreshing or closing the tab.
Does cleaning overwrite my original CSV?
No. Rules change a preview that you can undo or reset. Export downloads a separate cleaned CSV and processes the complete accepted file.