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
Tired of seeing the same prospects over and over again? The Net New filter helps you keep your pipeline fresh by automatically removing records you've already worked with.
You can find the Net New filter in the upper-left corner of the search page.
How it works
When enabled, the Net New filter ensures your search results only contain new, untouched prospects by excluding companies and contacts that have already been:
Added to your CRM (companies only)
Exported from Ocean.io (companies and contacts)
Saved as leads in Ocean.io (companies and contacts)
This means less time spent reviewing duplicates and more time discovering new opportunities that are ready for outreach.
Need more control?
Click Custom within the Net New filter to fine-tune exactly what should be included or excluded from your search results.
With Custom Net New filtering, you can choose to include or exclude:
People in leads (available when searching for people)
People exported (available when searching for people)
Companies in leads
Companies in CRM
Companies exported
This gives you complete flexibility to tailor your searches, whether you're looking for entirely fresh prospects or simply want to avoid specific records you've already engaged with.
3. Duplicate Prevention For CRM Exports
These methods apply to users with Salesforce, HubSpot, Attio, or Pipedrive integrations.
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.