Recipe: CSV import · Pipedrive
Owner names in Pipedrive, linked to their organizations.
Download your LocalContact results and import them into Pipedrive. One file creates each person with their job title and links them to the right organization.
Updated
How do I get LocalContact results into Pipedrive?
Short answer
Download your LocalContact results as a CSV and import it with Pipedrive's spreadsheet import. Map Person Name to the person's name, Job Title to a job title field, and Company Name to the organization's name. Pipedrive links everything in a row, so each person is created inside their organization, and it offers to merge duplicates it finds.
What’s in the LocalContact file
When a list upload finishes, LocalContact gives you a CSV with one row per person found:
| Column | Example (made up) | Pipedrive field |
|---|---|---|
| Company Name | Bramblewood Bakery | Organization: Name |
| Company Domain | bramblewood.example | Organization: a website field, if you have one |
| Company Type | Bakery | Organization: a custom field, or skip |
| Location | Austin, US | Organization: Address |
| Person Name | Maria Lopez | Person: Name |
| Job Title | Owner | Person: a job title field |
Pipedrive’s guide says all the data in a row is linked: a row with a person and an organization creates both and puts the person in the organization.
1. Download the results
In LocalContact, open your finished list upload and download the results (list uploads come with the Growth and Scale plans). If you’re starting from a list of businesses, upload it to LocalContact first. If it came from Google Maps or a scraper, clean it with the free lead-list cleaner before you upload it.
2. Start the import
In Pipedrive, open the import tool for spreadsheets and upload the CSV. Pipedrive accepts XLS, XLSX and CSV files.
3. Map the columns
- Person Name to the person’s Name. Pipedrive accepts a full name, so there’s no need to split it.
- Job Title to a job title field on the person. If your Pipedrive has none, create a custom person field called Job title first.
- Company Name to the organization’s Name, and Location to its Address.
- Company Domain and Company Type to organization fields if you use them, or leave them out.
4. Review duplicates and finish
Pipedrive checks for duplicates before it imports. Its guide says people are matched on their name plus organization, phone or email, and organizations on their name plus address. Choose to merge them when they’re the same, or bypass the merge step. Then finish the import. Give it a name you’ll recognise, such as the list’s name, so you can find these records later.
Things to know
- Credits: in LocalContact, each business searched costs 1 credit, with every person found included.
- Emails: the file has names and job titles, not emails yet. Work and personal emails are coming soon.
- Consent: a name in your CRM isn’t permission to email it. Check the rules where each person is, such as the CAN-SPAM Act in the US or PECR in the UK.
For HubSpot, see the HubSpot recipe. To skip the CSV and work from the API, see Zapier, Make or n8n.
Questions
Still have questions? Contact us
Is there a LocalContact app for Pipedrive?
Not yet. This recipe uses Pipedrive's own spreadsheet import with a CSV from LocalContact, so it needs no API key.
Do I need emails to import people into Pipedrive?
No. Pipedrive's import guide says people need a name, or a first and last name, and organizations need a name. LocalContact gives you both. Emails in LocalContact are coming soon.
What if a business has two people?
The LocalContact file has one row per person. Both rows carry the same company name, so Pipedrive links both people to the one organization, and its duplicate check matches organizations by name and address.
How big can the file be?
Pipedrive's guide says no more than 200,000 rows and under 50 MB per file, as XLS, XLSX or CSV. Split very large result files into smaller ones.
Stop emailing info@. Find who actually decides.
Name and address in. The people who run the business out.