Beginner8 min readLead Generation

How to Upload a CSV List of Contacts to Apollo.io

Already have prospects in a spreadsheet, from an event, a trade show, LinkedIn Sales Navigator, or another tool? You can import them into Apollo as contacts, drop them straight into a list, and optionally enrich missing emails and phone numbers, all in one upload.

By AWykoff Consulting · Updated 2026-11-05

▶ Video walkthrough coming soon
Subscribe for the step-by-step YouTube tutorial.

Before you start

  • Permission to bulk import contacts via CSV. If you don't see the import option, ask your Apollo admin to update your permission profile.
  • A CSV file with fewer than 10,000 rows (split larger files).
  • Credits, if you turn on email or phone enrichment.

Step 1: Format your CSV

A clean file means better matching and fewer duplicates. Apollo needs at least one identifying column per row.

  1. Include at least one of: Company Name, Company Website, Contact LinkedIn URL, or Contact Email.
  2. For best results, also include First Name, Last Name, Title, Contact Email, Contact LinkedIn URL, Company Name, and Company Website.
  3. Enter websites as a bare domain (for example, acme.com, not https://www.acme.com).
  4. Separate multiple values within one cell with semicolons, and enter checkbox fields as True or False.
  5. Save as .csv and keep it under 10,000 rows.
Tip: Delete blank rows and duplicate header rows before uploading. They're the most common cause of failed or messy imports.

Step 2: Upload the file

  1. In Apollo, click People.
  2. Click Import and choose CSV.
  3. Under Import contacts, click Select CSV File and choose your file.

Step 3: Map your columns

Apollo shows each column in your file next to a matching Apollo field.

  1. Confirm each CSV column maps to the right Apollo field (First Name → First Name, and so on).
  2. If a column has no matching field, you can create a custom contact field. Note that you'll need to restart the upload after creating it.
Tip: Create any custom fields before you start the import to avoid uploading twice.

Step 4: Choose import settings and add to a list

This is where you tell Apollo how to treat duplicates and where to put the contacts.

  1. Stage: pick one stage for every contact, or choose to use a stage column from your CSV.
  2. If contacts already exist: Apollo matches on name, company, email, or LinkedIn URL. Choose Update the existing record to merge new data instead of creating duplicates.
  3. Owner settings: choose who owns contacts with no owner in the file, and whether existing owners should change.
  4. Add to a list: type a new list name or select an existing list. This puts every imported contact into that list automatically.
  5. Accounts: choose whether Apollo should auto-assign or create accounts from the website or domain column.
  6. If you've connected a CRM, decide whether the import should create and update records there too.

Step 5: Enrich (optional) and import

On paid plans, Apollo can fill in missing emails and phone numbers during the import.

  1. Click Data enrichment and toggle email, phone, or both.
  2. Review the credit estimate Apollo shows based on your row count and enrichment settings.
  3. Click Import.
  4. Track progress under Settings > Imports and exports > Contact Import. Most imports finish in minutes; very large files can take a few hours.
Tip: Apollo enforces weekly CSV import limits based on your subscription. If you hit the limit, the import is blocked with an error showing your weekly maximum.

Go-to-market tips

Tag the source

Add a column like Lead Source (e.g. SaaStr 2026 booth) and map it to a custom field. Months later you'll know which event or campaign the contact came from.

Import into a list, then sequence the list

Always use the Add to a list setting. It turns a one-time upload into a reusable segment you can sequence, re-enrich, and report on.

Verify before outreach

Imported data is often the oldest data you have. Verify emails before the first send to keep bounce rates low.

Frequently asked questions

What columns does Apollo require in a CSV import?

Each row needs at least one of Company Name, Company Website, Contact LinkedIn URL, or Contact Email. Including names, titles, and emails improves matching and enrichment.

How many rows can I upload at once?

Apollo recommends keeping each file under 10,000 rows. Weekly import limits also apply based on your subscription.

Will importing create duplicate contacts?

Not if you choose Update the existing record. Apollo matches on first name, last name, company, email, or LinkedIn URL and merges the CSV data into the existing contact.

Can I import companies instead of people?

Yes. Apollo has a separate import for accounts (companies). Import accounts first if you want to find contacts at a specific set of companies.

Sources

Software interfaces change. If a button has moved, check the sources above for the latest steps, or let us know.

Related tutorials