Exact match free · Similarity matching on Pro
Remove duplicates before your CRM import
Upload a spreadsheet. Pick the columns to match on. Operelio finds and removes every duplicate row, with a preview before you commit.
No credit card required. Free for up to 2,000 rows.
What it does
Six things this tool does well
Column-based matching
Select one column or several. Operelio compares rows on your chosen columns and marks exact matches as duplicates. Match on email alone, or combine email and company for stricter matching.
Keep first or last
Choose which occurrence to keep when duplicates are found. Keep first is the default. Keep last is useful when later rows have more recent data.
Preview before you run
See how many duplicates were found and which rows will be removed before you commit. Nothing changes until you click Run.
CSV and Excel supported
Upload .csv, .xlsx, or .xls files. The tool reads your columns for you and outputs a clean file with all duplicates removed.
Similarity matchingPro
Exact matching misses close duplicates like "Jon Smith" and "John Smith". Similarity matching on Pro catches these by comparing how similar the values are.
Export removed rowsPro
On Pro, download a separate file containing just the rows that were removed. Useful for reviewing what was dropped before you import the clean file.
How to use it
Three steps from messy to clean
Upload your file
Drag and drop any CSV or Excel file. Operelio reads the columns for you.
contacts_export.csv
5,875 rows, 9 columns
Pick columns and preferences
Select which columns to match on and whether to keep the first or last occurrence.
Match on
Keep
Download the clean file
Click Run and download your file with all duplicates removed. See the summary: rows checked, duplicates found, rows kept.
The alternative
Doing it yourself
This is what deduplication looks like without a tool.
In Excel or Google Sheets
Several minutes per file
No preview before deletion. No similarity matching. No record of what was removed. Issues only surface when the CRM import fails.
With Deduplicate
Seconds, not minutes
Preview before you run. Similarity matching on Pro. Export removed rows to verify what was dropped.
Duplicates might not be the only problem in that file
Upload it and Bridgeant reviews the file before you commit to a tool. It reports what it finds, orders the problems by how much they actually matter, and points you at the tool for each one. That is on every plan including Free, and it works from a summary of your file rather than the contents.
On Pro and up it stops advising and starts doing. Describe the job in a sentence and Bridgeant plans the steps, shows you the plan, and runs them in the right order once you approve. You are not running four jobs by hand and trying to remember which came first.
See how Bridgeant worksPricing
Free on every plan
Exact matching is free for up to 2,000 rows. Pro ($39/month) adds similarity matching, duplicate export, and up to 50,000 rows. Agency ($299/month) goes up to 150,000 rows.
Common questions
FAQ
How does Operelio detect duplicates?
You select one or more columns and Operelio compares every row on those columns. Rows with identical values in all selected columns are marked as duplicates. The first occurrence is kept by default.
What is similarity matching?
Similarity matching finds close duplicates by comparing how similar values are. It catches variations like "Jon" vs "John" or "Westmarch Trading" vs "Westmarch Trading Ltd" that exact matching would miss. Available on Pro.
What file formats are supported?
CSV (.csv) and Excel (.xlsx, .xls). Upload either format and download a clean file with duplicates removed.
Does it work with multi-tab workbooks?
Yes. By default the tool reads the workbook's first tab, and a tab picker under the upload switches to any other. To remove duplicates across every tab at once, combine the tabs into one list in Merge Files first (its Source Tab column keeps track of where each row came from), dedupe the combined list, then split it back into tabs if you want the original shape back.
What does the Free plan include?
Three jobs per month, files up to 2,000 rows and 2 MB, CSV output, and 24-hour file retention. Exact matching is included on Free. Similarity matching and the separate duplicates export file are Pro features.
Can I export the removed duplicates?
On Pro, yes. Download a separate file with just the rows that were removed, so you can review what was dropped.
How does this compare to a dedicated deduplication tool?
Tools like Dedupely merge duplicate records that are already inside HubSpot, Salesforce or Pipedrive. Operelio removes them from the file before they get there, so they never become records with owners and activity attached. They solve different halves of the same problem and work well together.
Can I match on more than one column?
Yes. Select multiple columns and rows are only flagged as duplicates if they match on all of them. Useful for stricter matching, like email plus company name.
Works well with
Want the full walkthrough? Read the Deduplicate guide →
More guides: Remove duplicates in Excel · Clean up your CRM data · Operelio vs Dedupely
Try it on your messiest CSV
Upload a file. We'll do the rest. Free on every plan.