Apollo.io
Monday.com Contacts5 fieldsHow to import Apollo.io data into Monday.com
Apollo.io exports people lists as CSV files. This template maps the export onto a Monday.com contact board: First Name and Last Name are combined into Monday.com's single Name column, email and the work phone map directly, and the job title goes to the Notes column since Monday.com boards have no default title column. Apollo ships four phone columns; Monday.com's default board has one Phone column, so Mobile, Work Direct, Corporate, and Other are combined and the first available number wins, with Mobile taking priority. Phones are standardized and emails are lowercased before import. On Apollo's free tier the Email column shows the placeholder email_not_unlocked@domain.com for locked records. Monday.com boards are lean by default, so most Apollo columns have no native home; the Columns we don't use section covers each one.
Field-by-field mapping
This is the complete column mapping from Apollo.io to Monday.com. The left column is the header in your CSV export. The right column is the Monday.com field it should map to.
| Apollo.io column | Monday.com field | |
|---|---|---|
| First Name → Last Name | Name* Monday.com uses a single Name column on the item, so First Name and Last Name are combined into one with a space between them. TransformFirst Name and Last Name combined with a space | |
| Email TransformLowercased and trimmed | ||
| Mobile Phone → Work Direct Phone → Corporate Phone → Other Phone | Phone Monday.com's default contact board has one Phone column. It takes the first available number: Mobile first, then Work Direct, then Corporate, then Other. Whichever is present wins; the rest are skipped. TransformStandardized to international format (+1, +44, etc.) | |
| Company | Company | |
| Title | Notes Monday.com's default contact board has no job-title column. Title maps to the Notes column so the job title carries over to the board item. |
Required by Monday.com.
Columns we don't use
Your Apollo.io export includes 24 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Monday.com.
- Email Status
Monday.com's default contact board has no email-quality column. Apollo's Verified, Unverified, Guessed, and Unavailable values are useful for filtering, Monday.com just has no standard place for them.
If you need it. Add a Status column to your Monday.com board called Email Status, then map it by hand.
- Seniority
Monday.com's default contact board has no seniority column.
If you need it. Add a Status or Dropdown column to your Monday.com board called Seniority, then map it by hand.
- Departments
Monday.com's default contact board has no department column. Apollo ships several departments per row, comma-separated.
If you need it. Add a Dropdown or Text column to your Monday.com board called Departments, then map it by hand.
- Corporate Phone, Other Phone, Company Phone
Monday.com's default contact board has one Phone column, which this template fills from the first available of Mobile, Work Direct, Corporate, and Other. Company Phone is the same switchboard number as Corporate Phone in most exports.
If you need it. Add Phone columns to your Monday.com board if you want every number kept separately.
- Person Linkedin Url, Company Linkedin Url
Monday.com's default contact board has no LinkedIn column.
If you need it. Add a Link column to your Monday.com board called LinkedIn, then map Person Linkedin Url to it by hand.
- Person City, Person State, Person Country
Monday.com's default contact board has no address-block column set. Each piece needs its own column on the board.
If you need it. Add Text columns to your Monday.com board for City, State, and Country, then map them by hand.
- Website, Industry, # Employees, Annual Revenue, Company Description, Founded Year
These are company-level data points. Monday.com's default contact board has no columns for them, and they belong on a company record rather than a contact.
If you need it. Add columns to your Monday.com board if you want them on the contact, or keep a separate company board and link the two.
- Company Address, Company City, Company State, Company Country
The company address is company-level data and Monday.com's default contact board has no address columns.
If you need it. Keep company addresses on a separate Monday.com company board if you need them.
- Lists
Monday.com's default contact board has no native field for the Apollo list a row came from. The list name is useful for segmenting prospects by campaign or saved-search source.
If you need it. Add a column to your Monday.com board called Apollo List, then open the column mapper and route Lists to it.
- Created Date
Monday.com's default contact board has no native field for the date Apollo added the row to your account. The value is useful for filtering older prospects or sorting by recency.
If you need it. Add a column to your Monday.com board (date type) called Apollo Created Date, then route Created Date to it in the column mapper.
- Account Owner
Monday.com's default contact board has no native field for the Apollo user assigned to a row. Account Owner is an Apollo user, not a Monday.com user. The two are different identities and mapping them across needs a manual translation table.
If you need it. Add a column to your Monday.com board called Apollo Owner if you want to preserve the source of the record. Or use it as a filter in Apollo before exporting, so each exported file is single-owner.
Formatting and cleanup
Apollo.io exports rarely match the format Monday.com expects. Fix these before you import.
- 1.Combines First Name and Last Name into Monday.com's single Name column
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Fills the single Phone column with the first available number, checking Mobile, then Work Direct, then Corporate, then Other
- 5.Maps Title to the Notes column since Monday.com boards have no default job-title column
- 6.Trims whitespace and removes blank rows
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Apollo.io export and download a clean, import-ready file for Monday.com.
Apollo.io to Monday.com FAQ
Why do some rows have email_not_unlocked@domain.com instead of a real email?
Apollo's free tier writes that placeholder in the Email column for records you haven't spent credits to reveal. The rows still land on the Monday.com board, but they arrive without a real email. Reveal the contacts in Apollo and re-export, or filter those rows out of your CSV before uploading.
How do I export contacts from Apollo.io?
In Apollo, open your saved list or search, select the contacts you want, and click Export. Apollo emails you a CSV when it's ready. Upload that file to Operelio.
Why do you combine First Name and Last Name?
Monday.com items have a single Name column, not separate first and last name columns. The template combines the two columns with a space so each item displays correctly on the board.
How does the template handle Apollo's four phone columns?
Monday.com's default contact board has one Phone column. The template fills it with the first available number, checking Mobile first, then Work Direct, then Corporate, then Other. All numbers are standardized to international format before import.
How does Monday.com handle duplicates on import?
Monday.com boards don't deduplicate on import. Every row in your CSV creates a new item. Run a deduplication pass on your CSV before uploading if you want to avoid duplicate items on the board.
Where do I import the CSV into Monday.com?
Open your contacts board, click the + at the top-right, choose Import from spreadsheet, and upload the file Operelio produces. The import wizard matches the column headers to your board columns.
