Recipe: CSV import · HubSpot

# Owner names in HubSpot, from a CSV.

Download your LocalContact results, split the names, and import them as HubSpot contacts with their job titles and companies. No API needed.

Updated 15 Nov 2026

[Upload a list](https://localcontact.ai/#upload) [Book a demo](https://localcontact.ai/demo)

## How do I get LocalContact results into HubSpot?

Short answer

Download your LocalContact results as a CSV, split the Person Name column into first and last names, then use HubSpot's import to create contacts with their job title and company name. HubSpot import is available on its free tools. LocalContact doesn't return emails yet, so HubSpot can't spot duplicate contacts: import each list once.

Recipe: CSV import

This is a recipe, not a native app: there is no LocalContact app in HubSpot. You download your results from LocalContact as a CSV and import that file into HubSpot. No API needed: CSV export comes with every plan, and uploading a whole list comes with the Growth and Scale plans.

## 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)   | HubSpot property                         |
| -------------- | ------------------- | ---------------------------------------- |
| Company Name   | Bramblewood Bakery  | Company name (contact) or Name (company) |
| Company Domain | bramblewood.example | Company domain name (company)            |
| Company Type   | Bakery              | Industry, or leave it out                |
| Location       | Austin, US          | City, or leave it out                    |
| Person Name    | Maria Lopez         | Split into First name and Last name      |
| Job Title      | Owner               | Job title (contact)                      |

A business with two people found has two rows, one per person.

## 1. Download the results

In LocalContact, open your finished list upload and download the results (list uploads come with the Growth and Scale plans). The file is UTF-8, so names with accents import cleanly. If you’re starting from a list of businesses, [upload it to LocalContact](https://localcontact.ai/#upload) first; clean it with the free [lead-list cleaner](https://localcontact.ai/tools/lead-list-cleaner) if it came from a scraper.

## 2. Split the names

HubSpot stores first and last names separately. Open the file in Google Sheets or Excel and add two columns next to **Person Name** (column E in the download):

- **First name:** `=LEFT(E2, FIND(" ", E2 & " ") - 1)`
- **Last name:** `=TRIM(MID(E2, FIND(" ", E2 & " "), 200))`

Fill them down, check a few rows by eye (some names have more than two parts), and save as CSV.

## 3. Import the contacts

1. In HubSpot, open your contacts and choose **Import**, then start a new import from a file on your computer.
2. Choose one file and one object: **Contacts**.
3. Map the columns: First name, Last name, **Job title** and **Company name**. Leave Person Name unmapped.
4. Name the import after your list, so you can find these contacts later, and finish.

HubSpot’s guide lists Email as the main identifier for contacts. LocalContact doesn’t return emails yet, so each row becomes a new contact. That’s fine for a fresh list. Just don’t import the same file twice.

## 4. Link them to companies

If most rows have a **Company Domain**, you can create or match company records too:

1. Start an import with **Advanced imports**, then **Single file** with contacts and companies.
2. Map **Company Domain** to the company’s **Company domain name**. HubSpot matches companies on their domain, so two people at the same business land on one company record.
3. Map **Company Name** to the company’s **Name**, and the person columns as in step 3.

Rows without a domain would create a new company each time, so import those as contacts only, with the Company name property filled in.

## Things to know

- **Plans:** HubSpot’s import guide lists import as available on all its plans, with limits on file size and rows per day on the free tools.
- **Credits:** in LocalContact, each business searched costs 1 credit, with every person found included.
- **Consent:** importing a name into a CRM doesn’t give you permission to email it. Check the rules where the person is, for example the [CAN-SPAM Act](https://localcontact.ai/glossary/can-spam-act) in the US or [PECR](https://localcontact.ai/glossary/pecr) in the UK.

For Pipedrive, see the [Pipedrive recipe](https://localcontact.ai/integrations/pipedrive). To skip the CSV and work from the API, see [Zapier](https://localcontact.ai/integrations/zapier) or [Make](https://localcontact.ai/integrations/make).

## Sources

- [HubSpot: set up your import file](https://knowledge.hubspot.com/import-and-export/set-up-your-import-file)
- [HubSpot: import records and activities](https://knowledge.hubspot.com/import-and-export/import-objects)
- [HubSpot: deduplication of records](https://knowledge.hubspot.com/records/deduplication-of-records)
- [HubSpot: default contact properties](https://knowledge.hubspot.com/properties/hubspots-default-contact-properties)

## Questions

Still have questions? [Contact us](https://localcontact.ai/contact)

Is there a LocalContact app for HubSpot?

Not yet. This recipe moves a CSV from LocalContact into HubSpot with HubSpot's own import tool. It needs no API: CSV export comes with every LocalContact plan, list uploads with Growth and Scale, and HubSpot's import works on its free tools.

Can I import contacts without an email address?

Yes, but HubSpot uses the email address to find duplicates. Its help centre says that without one, each row of the file is imported as a new contact. So import each list once, and don't import the same file twice.

Will the contacts be linked to the right company?

When the row has a company domain, HubSpot can match the company by its domain. Rows without a domain create a new company each time, so for those, fill in the contact's Company name property instead of creating company records.

When will LocalContact add emails?

Work and personal emails for the people LocalContact finds are coming soon. You can join the early list on the emails page.

## Stop emailing info\@. Find who actually decides.

Name and address in. The people who run the business out.

[Find the owner ](https://localcontact.ai/try)[Book a demo](https://localcontact.ai/demo)

Source: https://localcontact.ai/integrations/hubspot · Updated: 2026-11-15
