To import B2B contacts into your CRM, clean and map the file first, import only the segment that matches your ideal customer profile, and assign owners before any outreach begins. The steps differ slightly in HubSpot and Salesforce, but the discipline is the same: fewer, better records beat a bulk upload. This guide is written for small B2B sales and marketing teams that want clean pipeline data from day one.

Decide Which Contacts Belong in the CRM
Not every row in a list deserves a CRM record. Start with accounts that match your ICP: B2B companies with roughly 11 to 200 employees in software, professional services, financial services, or consulting, where a small team can realistically work each account. Contacts from firms far outside that profile add reporting noise and wasted follow-up. If you also use website visitor identification, apply the same filter to identified visitors before they reach your CRM.
Related: Vibe Coding a CRM for a Small B2B Team: Build or Buy?
Prepare the File Before You Import
- Remove duplicates and incomplete rows: Keep one record per person.
- Map every column: Match each CSV column to an existing CRM property, and name custom fields clearly.
- Verify emails and phone numbers: Validate before sending anything. Our guide on cleaning contact data before you reach out walks through the checks.
- Tag each row with its source: A label such as 'Q1 Target Accounts' lets you measure results later.
- Back up your current CRM: Export existing contacts before any import.
- Use consistent formats: Write dates as YYYY-MM-DD and keep country and job title values standardized.
Run a Pilot Import Before the Full Load
Start with a small batch of a few hundred records from one segment. Check how fields map, whether duplicates merge correctly, and whether the right owner receives each contact. Fix problems in the pilot, then load the rest. A pilot takes little time and prevents the kind of cleanup that can take weeks after a full upload.
Related: The Ultimate Guide to 5 Best Outbound Sales Tools That Integrate with Your CRM
Import Into HubSpot
- Open Contacts and choose Import.
- Select the file upload option and choose your CSV.
- Map each column to a HubSpot property, creating new properties only where needed.
- Set how duplicates are handled, matching on email where possible.
- Review the preview, start the import, and check the results report for errors.
Check your HubSpot subscription's contact limits before large uploads, since they vary by plan. For a deeper setup of CRM sync, read HubSpot and Salesforce visitor identification setup for small B2B teams.
Import Into Salesforce
Salesforce is strict about field mapping and duplicates, so configure duplicate rules before loading any data.
- Set up duplicate rules for Leads and Contacts first.
- Use the Data Import Wizard for smaller files, which handles leads, contacts, and accounts.
- Use Data Loader for larger files, and run them in batches rather than one large upload.
- Map fields carefully and confirm that required fields are populated.
- Review the success and error files, then correct and re-import rejected rows.
Avoid These Common Import Mistakes
- Importing everything: Start with the ICP segment only.
- Skipping deduplication: It creates CRM clutter that is hard to unwind.
- Wrong date formats: Standardize on YYYY-MM-DD before upload.
- Missing required fields: Check CRM requirements before you build the file.
- No backup: Export existing data first, every time.
Assign Owners So Imported Contacts Get Worked
A contact with no owner never reaches pipeline. Before the import, decide who owns each segment, whether that is an account executive, a business development rep, or a shared queue. Set a rule for how quickly new contacts receive a first touch.
- Assign each segment to a named owner or queue.
- Create a list for each import batch so results are easy to compare.
- Set lead scoring rules so reps see the strongest contacts first.
- Build a follow-up workflow with a clear exit condition for each contact.
- Track bounce rates and reply rates on the first campaign.
For routing logic that sends the right record to the right rep, see how to route identified website visitors to the right rep.
Keep Imported Data Compliant
Imported contacts still fall under privacy rules in the markets you sell to. Confirm the lawful basis for outreach in the UK, EU, and US, record opt-outs in your CRM, and make sure suppressed contacts are never re-imported. Your legal or compliance team should advise on the specifics for your business.
If your team also wants to know which anonymous website visitors are worth importing, Happierleads is a B2B website visitor identification platform that reveals the person behind each visit and offers CRM integrations. Book a free demo to see how it fits your sales workflow.
Frequently asked questions
Should I import every contact from a purchased list?
No. Import only contacts that match your ICP and that your team can realistically work. Extra records add reporting noise and wasted follow-up.
How do I avoid duplicate contacts in HubSpot or Salesforce?
Remove duplicates from the file before upload, match on email where possible, and set duplicate rules in Salesforce before loading any data.
Should contacts be verified before import?
Yes. Validating emails and phone numbers protects sender reputation and keeps bounce rates low on your first campaigns.
Can imported contacts sit alongside website visitor data?
Yes. Happierleads offers CRM integrations and identifies the person behind anonymous website visits, so you can keep both sources organized in your CRM.




