We’ve all been there, discovering that some of your leads are already owned by another sales rep or even an existing customer.
Cleaning up lists manually can take hours, but with Ocean.io’s smart tools, you can automatically detect and avoid duplicates so you can focus on net new leads only.
Ocean.io helps you stay organized by preventing duplicates at every step, whether you’re browsing, building lead lists, or exporting to your CRM.
Overview: 3 Ways to Avoid Duplicates
Check the Search Results – Use the quickview and search columns for instant visibility.
Use the Net New Filter – Search for companies and people that are not yet exported, saved as lead or in your CRM.
Duplicate Prevention For CRM Company Exports – Automatically detect companies in your CRM when exporting to avoid duplicates
Bonus: For Non-Integrated CRMs – Manually compare your CRM data to Ocean.io results.
1. Check the Search Results
Use the Quickview
If you’re reviewing search results manually, click on a company to open the Quickview.
Here, you can immediately see whether the account already exists in your CRM and who it’s assigned to — saving you from double work.
Review the Columns
The search table includes columns that show:
Whether the company/person has been exported before
Whether the company is already present in your CRM (Professional plan)
If the company/person is already saved as lead
If so, what the status is, and who the assignee is
If you don’t see these columns yet, learn how to customize your search table to display the information most useful to you.
2. Use the Net New Filter
Look at the left top of the search page to find the "Net new" filter.
This feature may slightly slow down your search, but it ensures you only see net new companies and contacts — excluding those already:
In your CRM (only looks at companies)
Exported previously (companies + contacts)
Saved as lead (companies + contacts)
If you want to filter even more granularly, you can do custom net new filtering by clicking on the "Custom" option instead. Here, you can choose to include or exclude the following options from the results:
People in leads (only available when looking for people)
People exported (only available when looking for people)
Companies in leads
Companies in CRM
Companies exported
3. Duplicate Prevention For CRM Exports
These methods apply to users with Salesforce, HubSpot, or Pipedrive integrations on Professional plans and above.
Automatic Duplicate Detection
When you export a company from Ocean.io to your CRM, the system automatically checks for duplicates.
If an account already exists, Ocean.io marks it as Ignored and prevents the export.
Duplicate detection considers multiple data points — not just company name or domain — including:
Full company address
Email domain
LinkedIn handle
Other unique identifiers
⚠️ Note: This logic applies only to companies. Deals, leads and contacts are still created even if they already exist in your CRM. If you don't want to create deals, leads and contacts if they already exist, use the "Net new" filter.
4. Bonus: Other CRMs
Avoid duplicates if you have a CRM that doesn't integrate with Ocean.io
If you don't have Salesforce, HubSpot or Pipedrive, read on!
Want to avoid duplicates, but you can't integrate with Ocean.io as your CRM is not compatible? We have a trick up our sleeves for you.
Step 1: Prepare your list
For companies, copy the website URLs from your CRM
For people, copy the LinkedIn profile URLs
You can handle up to 10,000 links at once
Step 2: Paste into the relevant lookup filter
Company Lookup → paste company URLs
Person Lookup → paste LinkedIn URLs
Step 3: Exclude items without pressing Enter
Important: After pasting all URLs, do NOT press Enter
If you press Enter, the items will be included in your search instead of excluded
Look just below the search bar → you’ll see an Exclude option.
Click Exclude → all pasted items are now excluded from the current search
Step4: Save the search
Right-click on the search tab → select Save As.
Give it a name (e.g., “Excluded CRM Data”).
Next time: Load this saved search first → your excluded items remain hidden.
You can now add new filters on top without affecting exclusions.
✅ Outcome: Your CRM data will never be duplicated in Ocean.io exports.
📝 Note: If your goal is to exclude companies/items from the results, do not upload a CSV file into the Company Lookup filter. Uploading a CSV will cause those items to be included rather than excluded.
To exclude items correctly, copy and paste the list directly into the search bar manually instead of uploading a file. This ensures the items are treated as exclusions and filtered out as intended.