Downloading a list of business leads is the start of a sales workflow, not the end. Before your team can work the list efficiently, it needs to be cleaned, standardized and imported into the CRM or spreadsheet you actually use every day. Skipping this step creates duplicates, confused ownership and wasted calls.
This guide walks through a practical import process that works for most CRMs and spreadsheet-based pipelines.
Step 1: Understand what is in the file
Open the CSV and review the columns before you do anything else. A typical business lead export includes:
- Business name
- Phone number
- Street address, city, state and ZIP code
- Website, when available
- Email, when publicly available
- Category or industry
- Notes or status fields you added
BusinessLeadSearch delivers every lead with a business name, phone number and street address; website and email are included when the business publishes them. The file contains business contact details, not personal owner information.
Step 2: Standardize the fields
Consistent formatting makes searching, deduplication and reporting much easier.
Phone numbers
Pick one format and apply it everywhere, for example (555) 123-4567 or +15551234567. Many CRMs prefer a consistent international format for click-to-call.
Addresses
Keep street, city, state and ZIP in separate columns. Use standard state abbreviations. Avoid combining suite numbers into the city field.
Business names
Remove extra spaces and fix obvious capitalization issues, but do not rename businesses. The official name helps when you look them up later.
Categories
Map the category values to the industry or segment field you already use in your CRM. If your CRM uses "Food Service" and the file says "Restaurant," decide on one mapping and apply it consistently.
Step 3: Deduplicate before import
Duplicates are the most common import problem. Check for them in two places.
Inside the file
Sort by phone number and by street address. Two rows with the same phone number and address are almost certainly the same business. Two rows with the same name but different addresses may be separate locations and should stay separate.
Against your CRM
Export your existing accounts, or use your CRM's duplicate detection during import. Match on phone number and street address first; names alone are unreliable because many businesses share similar names.
Step 4: Decide ownership and status
Before importing, decide who owns each record and what status it starts with.
- Owner – assign accounts by territory, ZIP code or rep
- Status – usually "New" or "Not contacted"
- Source – record where the lead came from so you can measure results later
- Segment or priority – A, B or C based on your territory plan
Clear ownership prevents two reps from calling the same business on the same day.
Step 5: Map fields in the import tool
Most CRMs let you match CSV columns to CRM fields during import. Map carefully:
- Business name → Company or Account name
- Phone → Main phone
- Street, city, state, ZIP → Billing or Primary address fields
- Website → Website
- Email → General email (not a personal contact field)
- Category → Industry or Segment
If your CRM separates companies and contacts, import businesses as companies first. Create contacts only when you learn a real person's name and role through your outreach.
Step 6: Run a small test import
Import ten or twenty rows first. Check that fields landed in the right places, that phone numbers display correctly and that duplicates were handled as expected. Fix the mapping before importing the full file.
Step 7: Import and verify
Run the full import, then spot-check a random sample of records. Confirm totals: the number of records imported plus the number of duplicates skipped should equal the number of rows in the file.
Step 8: Set up views and tasks
Create saved views so reps can work efficiently:
- New accounts by territory
- A-priority accounts not yet contacted
- Accounts with a follow-up due this week
Add tasks or sequences for the first contact attempt. Keep records of opt-outs in a field everyone can see, and exclude those accounts from future outreach.
Keeping the data clean over time
Businesses move, change phone numbers and close. Build simple habits:
- Update records immediately when a call reveals a change
- Mark closed businesses rather than deleting them, so they are not re-imported later
- Review a sample of records every quarter
Working without a CRM
If you use a spreadsheet instead, the same principles apply. Use one tab for accounts and another for activities, keep formats consistent and add filters for status and owner. Whichever tool you use, agree on a short list of status values with your team before the first import, and write down what each one means. Consistent statuses make weekly reporting simple and prevent accounts from being forgotten between reps. Within the BusinessLeadSearch workspace you can also track lead status and notes before exporting.
A quick pre-import checklist
Before you click import, confirm:
- Phone numbers use one format
- Address parts are in separate columns
- Duplicates within the file are merged
- Each row has an owner and a starting status
- The source field is filled in
- Opt-out records are excluded
Summary
A clean import takes an hour or two and saves days of confusion later. Standardize fields, deduplicate on phone and address, assign ownership, test with a small batch and keep records current. Then your team can spend its time selling instead of fixing data.
Ready to build your next list? See how buying business leads works, or search a territory with the business lead finder.
Turn this into a prospect list
Build a targeted list with the business lead finder, start from buy business leads, or search by ZIP code.
