---
title: "Import a Lead List into Your CRM: Field Mapping and Cleanup"
description: "Map every column of a lead list CSV to HubSpot, Salesforce and Pipedrive fields. 35.5% of rows share a website with a branch: dedupe with care."
url: https://leadlists.app/guides/import-a-lead-list-into-your-crm
---

# How to import a lead list into your CRM

A column-by-column mapping of a lead list CSV to HubSpot, Salesforce and Pipedrive, and the five cleanup steps to run before you press import.

Updated November 20, 2026 · 9 min read · Data from LeadLists' own lists

On this page

1. [What is in the file, column by column](#what-is-in-the-file-column-by-column)
2. [The field mapping for HubSpot, Salesforce and Pipedrive](#the-field-mapping-for-hubspot-salesforce-and-pipedrive)
3. [Clean the file before you import](#clean-the-file-before-you-import)
4. [Which columns to keep, and which to leave out](#which-columns-to-keep-and-which-to-leave-out)
5. [Skip the cleanup with a Bespoke plan](#skip-the-cleanup-with-a-bespoke-plan)
[Lists from $29 ](https://leadlists.app/lists/ready-made)

The short answer

Import businesses as companies (organizations in Pipedrive, accounts in Salesforce) and each email as a contact linked to its company. Before importing, split extra emails into their own rows, convert phones to E.164, reduce websites to a bare domain, and decide how to treat branches: 35.5% of rows in our files share a website with another location. Keep rating, hours and socials as custom properties.

A lead list is a flat file: one row per business, every fact in a column. A CRM is not flat. HubSpot, Salesforce and Pipedrive all separate the business (company, account, organization) from the people at it (contacts, persons), and each has its own rules for what counts as a duplicate. Most bad imports come from ignoring that split: three emails crammed into one contact, fifty pharmacy branches merged into one company, or review ratings dropped into Salesforce's Hot/Warm/Cold Rating field.

This guide uses the columns of our own files as the worked example. Every [ready-made list](https://leadlists.app/lists/ready-made) ships about 40 columns in CSV and Excel (39 in the Palm Beach County real estate file), and the 12 free sample rows on each list page download in exactly that format, so you can test the mapping before you buy anything.

![The 39 column names of the Palm Beach County real estate list, from business and category to latitude, longitude and place id](/guides/shots/import-a-lead-list-into-your-crm-1.jpg)

All 39 columns of a LeadLists file, as listed on the Palm Beach County real estate list page. The free sample CSV has the same columns.[LeadLists list page](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl), November 2026

## What is in the file, column by column

Before mapping, know which columns are nearly always filled and which are sparse. Business name, category, address, city, state, ZIP, coordinates and the listing ID are on every row. Phone is on 95.4%, website on 80.8%. Emails, named contacts and social profiles depend on the industry (see [which industries publish email addresses](https://leadlists.app/guides/which-industries-publish-email-addresses)).

Share of rows with each column filled, across 285,744 businesses

business, address, city, state, zip**100.0%**

phone**95.4%**

rating and reviews**88.2%**

website**80.8%**

working\_hours**76.7%**

email**73.5%**

facebook**56.8%**

email\_2**53.1%**

email\_3**41.2%**

county**35.6%**

LeadLists data: 285,744 businesses in 323 lists, November 2026

Two things in that chart drive the import design. First, a business with an email usually has more than one: 41.2% of all rows carry three addresses and 11.9% carry two. Those are different inboxes (an owner, a front desk, a second partner), so each should become its own contact. Second, **county** is filled on only about a third of rows. If you route by county, derive it from ZIP before importing; our [territory guide](https://leadlists.app/guides/segment-a-lead-list-by-territory) shows how.

## The field mapping for HubSpot, Salesforce and Pipedrive

Import the business as a company-level record and the emails as people linked to it. In HubSpot and Pipedrive you can do both from one file: Pipedrive links everything in a row, and HubSpot creates and associates a company and a contact when both are mapped. In Salesforce, the Data Import Wizard handles accounts, contacts and leads up to 50,000 records at a time; import businesses as accounts and named emails as contacts, or use leads if your team works a lead queue (a lead needs a Last Name and a Company).

__Standard fields where they exist, custom fields where they don't. Field names as shown in each CRM's default setup.__
| Our column                                      | HubSpot                                                      | Salesforce                               | Pipedrive                                   |
| ----------------------------------------------- | ------------------------------------------------------------ | ---------------------------------------- | ------------------------------------------- |
| business                                        | Company name                                                 | Account Name (or Lead: Company)          | Organization: Name                          |
| website                                         | Company domain name (bare domain) and Website URL            | Website                                  | Custom field: Website                       |
| phone                                           | Company: Phone number                                        | Phone                                    | Organization custom field, or Person: Phone |
| email, email\_2, email\_3                       | Contact: Email (one contact per address)                     | Contact or Lead: Email                   | Person: Email                               |
| email\_name                                     | Contact: First name, Last name (split)                       | First Name, Last Name                    | Person: Name                                |
| email\_title                                    | Contact: Job title                                           | Title                                    | Custom field: Job title                     |
| address, city, state, zip                       | Street address, City, State/Region, Postal code              | Billing Street, City, State, Zip         | Organization: Address                       |
| category, subcategories                         | Custom: Category (not Industry)                              | Custom field (not the Industry picklist) | Custom field or label                       |
| rating, reviews                                 | Custom number properties                                     | Custom number fields (not Lead Rating)   | Custom number fields                        |
| facebook, linkedin, twitter                     | Facebook company page, LinkedIn company page, Twitter handle | Custom URL fields                        | Custom fields                               |
| instagram, youtube, tiktok                      | Custom URL properties                                        | Custom URL fields                        | Custom fields                               |
| working\_hours                                  | Custom text property                                         | Custom long text                         | Custom large text                           |
| county                                          | Custom property                                              | Custom field                             | Custom field                                |
| claimed\_listing, business\_status              | Custom properties                                            | Custom fields                            | Custom fields                               |
| listing\_id, listing\_link, latitude, longitude | Custom properties (listing\_id as your source ID)            | External ID field                        | Custom fields                               |

Three mapping traps

**Industry** in HubSpot and Salesforce is a fixed dropdown; a category like "Real estate consultant" won't fit, so use a custom property. **Rating** on a Salesforce lead means Hot, Warm or Cold, not 4.7 stars. **Company domain name** in HubSpot only accepts a domain up to the top-level domain, so **https://www.example.com/agents/jane** must become **example.com** first.

## Clean the file before you import

From list file to CRM in six steps

1. 1**Open the CSV**Excel or Google Sheets, UTF-8
2. 2**One row per email**Split email\_2 and email\_3 into their own rows
3. 3**Normalise phones**+1 561-555-0123 to +15615550123
4. 4**Bare domains**Strip https, www and paths
5. 5**Decide on branches**Same domain: merge or keep apart
6. 6**Import and spot-check**Open 10 records, check links

### 1\. Split multiple emails into contact rows

Keep one row per email address, carrying the business columns with it. The simplest way is to stack three copies of the sheet (one using **email**, one **email\_2**, one **email\_3**), then delete rows where that email is blank. The name and title columns belong to the matching address: **email\_name** goes with **email**, **email\_2\_name** with **email\_2**. If you only want one contact per business, keep **email**; it is the address our pipeline ranked first for that business.

# Python (pandas): one row per email, with the business columns repeated
import pandas as pd
df = pd.read_csv("list.csv", dtype=str)
parts = []
for col, name, title in [("email", "email_name", "email_title"),
                         ("email_2", "email_2_name", "email_2_title"),
                         ("email_3", None, None)]:
    p = df[df[col].notna()].copy()
    p["contact_email"] = p[col]
    p["contact_name"] = p[name] if name else ""
    p["contact_title"] = p[title] if title else ""
    parts.append(p)
contacts = pd.concat(parts).drop_duplicates("contact_email")
contacts.to_csv("contacts.csv", index=False)

Run once; import contacts.csv with the company columns mapped too.

### 2\. Convert phones to E.164

Every phone in our files is already in one form, **+1 561-555-0123**, so converting to E.164 (the **+15615550123** form that dialers and SMS tools expect) is a single formula. HubSpot and Salesforce accept either, but a consistent format makes duplicate checks work.

Google Sheets:  =REGEXREPLACE(C2, "[^0-9+]", "")
Excel:          =SUBSTITUTE(SUBSTITUTE(C2, " ", ""), "-", "")

Column C is phone. Both return +15615550123.

### 3\. Reduce websites to a bare domain

Google Sheets:  =REGEXEXTRACT(LOWER(D2), "^(?:https?://)?(?:www\.)?([^/?#]+)")
Excel 365:      =LET(u, SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D2), "https://", ""), "http://", ""), "www.", ""),
                     IFERROR(LEFT(u, FIND("/", u) - 1), u))

Column D is website. Put the result in a new column and map it to Company domain name.

### 4\. Decide what a duplicate means

Inside one of our files, every row is a separate map listing (no listing ID repeats), so true duplicates are rare. What you will see is branches: **35.5%** of rows with a website share that website with another row in the same file, and **16.2%** of rows with a phone share the number. Those are pharmacy and bank branches, hotel brands, brokerages whose agents use the firm's site, and practices with several offices. HubSpot treats the domain as the company's identity, so importing those rows maps every branch to one company. That is right if you sell to head office and wrong if you sell to each location. To keep branches apart, map the domain to Website URL instead of Company domain name, or add the city to the company name.

Rows that share a contact point with another row in the same file

Shared with another locationUnique in the file

Same website (of rows with a website)

_**35.5%**_ _**64.5%**_

Same phone (of rows with a phone)

_**16.2%**_ _**83.8%**_

LeadLists data: 285,744 businesses in 323 lists, November 2026

If you buy several lists, dedupe across them on **listing\_id**: only 0.3% of listings appear in more than one of our 323 files, mostly where a metro list overlaps a state list. Against your existing CRM data, dedupe contacts on email and companies on domain, which is what HubSpot does by default.

### 5\. Tidy social links

Facebook, LinkedIn, X and YouTube values are full URLs. 19.8% of Instagram values are a bare handle like **studio.name**; prefix them with **https://www.instagram.com/** so the CRM renders a clickable link.

## Which columns to keep, and which to leave out

Keep anything a rep would filter or sort by. Rating and review count let you prioritise established businesses (businesses with more reviews publish emails more often; see [more reviews, more emails](https://leadlists.app/guides/more-reviews-more-emails)). Working hours tell callers when to dial (see [cold calling small businesses](https://leadlists.app/guides/cold-calling-small-businesses)). The **claimed\_listing** column marks owners who manage their own listing, which is a decent proxy for an engaged owner. Keep **listing\_id** as the source ID so a re-import updates instead of duplicating.

Import as properties

- business, category, phone, website, domain
- Each email as a contact, with name and title
- Address, city, state, ZIP, county
- rating, reviews, working\_hours
- Social profile URLs
- claimed\_listing, business\_status, listing\_id

Keep in the file only

- all\_emails and all\_phones (already split out)
- email\_matches\_website (use it to filter, then drop)
- reviews\_link and owner\_link
- photos\_count
- latitude and longitude, unless you map territories in the CRM

Then run a small test: import the 12 free sample rows from a list page first, open ten records, click the website and social links, and check that each contact sits under the right company. If that works, the full file will too. Pipedrive accepts XLS, XLSX and CSV files up to 200,000 rows and 50 MB; HubSpot and Salesforce both take CSV.

![Pipedrive knowledge base article on importing data with spreadsheets, listing XLS, XLSX and CSV files and the objects you can import](/guides/shots/import-a-lead-list-into-your-crm-2.jpg)

Pipedrive's import guide: XLS, XLSX and CSV files, with companies imported as organizations.[Pipedrive Knowledge Base](https://support.pipedrive.com/en/article/importing-data-into-pipedrive-with-spreadsheets), November 2026

## Skip the cleanup with a Bespoke plan

If you import lists every month, the split-and-map work repeats. On a [Bespoke plan](https://leadlists.app/pricing) the agent builds lists to your brief and pushes verified leads straight to HubSpot, Instantly or Smartlead, so new matches land as contacts under the right company without a spreadsheet step. Bespoke Starter is $99 a month for 2,000 verified leads; Pro is $199 for 5,000\. For a one-off import, a [ready-made list](https://leadlists.app/lists/ready-made) is $29 once, with the free sample to test your mapping first. Comparing sources? See [LeadLists vs Apollo](https://leadlists.app/vs/apollo) and [LeadLists vs Outscraper](https://leadlists.app/vs/outscraper), and run any file through our [lead list quality checklist](https://leadlists.app/guides/lead-list-quality-checklist) before import.

Test your CRM mapping on 12 free rows

Every list page has 12 complete rows you can download as a CSV, in the same columns as the full file. The whole list is $29 once, with a 7-day money-back guarantee.

[Real estate agents and brokerages in Palm Beach County, FL · $29](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl)[Advertising agencies in New York · $29](https://leadlists.app/lists/advertising-agencies-new-york)[Colleges and universities in California · $29](https://leadlists.app/lists/colleges-california)

[Browse lists ](https://leadlists.app/lists/ready-made)

## How to import a lead list into your CRM: questions

Should I import a lead list as contacts or companies?

Both. Import each business as a company (an organization in Pipedrive, an account in Salesforce) and each email address as a contact linked to it. HubSpot and Pipedrive can create and link both from one file; in Salesforce, import accounts first and then contacts, or use leads if your team works a lead queue.

How do I handle a business with three email addresses?

Make three contacts. Split email, email\_2 and email\_3 into separate rows that repeat the business columns, then import. In our files 41.2% of businesses have three addresses and 11.9% have two, and they are usually different people or inboxes.

What phone format should I use for a CRM import?

E.164, such as +15615550123\. Our files use +1 561-555-0123 on every row, so removing spaces and hyphens with one formula is enough. A consistent format makes duplicate checks and dialers work.

Why did HubSpot merge many of my companies into one?

HubSpot uses the company domain name to identify companies. Chains, brokerages and multi-office practices share one website across branches; in our files 35.5% of rows with a website share it with another row. Map the domain to Website URL instead, or add the city to the company name, if you want each branch as its own company.

Can I test the import before buying a list?

Yes. Each LeadLists list page has 12 free sample rows that download as a CSV with the same columns as the full file. Import them first, check the mapping, then buy the list for $29.

## Keep reading

[How to check the quality of a lead list before you buy](https://leadlists.app/guides/lead-list-quality-checklist)[How to segment a lead list by territory](https://leadlists.app/guides/segment-a-lead-list-by-territory)[How to cold call small businesses](https://leadlists.app/guides/cold-calling-small-businesses)[How to verify an email list before you send](https://leadlists.app/guides/how-to-verify-an-email-list)[Info@ vs personal email addresses: which one should you email?](https://leadlists.app/guides/info-vs-personal-email-addresses)[LeadLists vs Apollo](https://leadlists.app/vs/apollo)[LeadLists vs Outscraper](https://leadlists.app/vs/outscraper)[Real estate agents and brokerages in Palm Beach County, FL · $29](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl)[Advertising agencies in New York · $29](https://leadlists.app/lists/advertising-agencies-new-york)[Colleges and universities in California · $29](https://leadlists.app/lists/colleges-california)[All guides](https://leadlists.app/guides)[Insights](https://leadlists.app/insights)[Ready-made lists](https://leadlists.app/lists/ready-made)

## Sources

- [LeadLists data: 285,744 businesses in 323 lists (Nov 2026)](https://leadlists.app/insights)
- [HubSpot: Import records for multiple objects](https://knowledge.hubspot.com/import-and-export/import-objects)
- [Pipedrive: Importing data into Pipedrive with spreadsheets](https://support.pipedrive.com/en/article/importing-data-into-pipedrive-with-spreadsheets)
- [Salesforce Trailhead: Import data (Data Import Wizard, 50,000 records)](https://trailhead.salesforce.com/content/learn/modules/lex%5Fimplementation%5Fdata%5Fmanagement/lex%5Fimplementation%5Fdata%5Fimport)
