Cognism
Monday.com Contacts4 fieldsHow to import Cognism data into Monday.com
Cognism exports prospect lists as CSV files from Prospector. This template maps the export to Monday.com's default contact board: it combines First Name and Last Name into Monday's single Name column, and maps email and company. Cognism ships four phone columns; Monday's default board has one Phone column, so Mobile, Direct, Office, and HQ are combined and the first available number wins, with Mobile, including Cognism's Diamond-verified mobiles, taking priority. Monday's default contact board is lean, so the job title, the company firmographics, and the address are listed in the Columns we don't use section.
Field-by-field mapping
This is the complete column mapping from Cognism 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.
| Cognism column | Monday.com field | |
|---|---|---|
| First Name + Last Name | Name* Monday.com uses a single Name column on the item, so the template combines the two columns with a space between them. TransformFirst Name and Last Name combined with a space | |
| Email TransformLowercased and trimmed | ||
| Mobile → Direct → Office → HQ | Phone Monday's default contact board has one Phone column. It takes the first available number: Mobile first, including Cognism's Diamond-verified mobiles, then Direct, then Office, then HQ. Whichever is present wins; the rest are skipped. TransformStandardized to international format (+1, +44, etc.) | |
| Company Name | Company |
Required by Monday.com.
Columns we don't use
Your Cognism export includes 51 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Monday.com.
- Job Title
Monday.com's default contact board has no native job-title column.
If you need it. Add a Text column to your Monday.com board called Job Title, then map this column to it by hand.
- Seniority
Monday.com's default contact board has no native seniority column.
If you need it. Add a Status or Dropdown column to your Monday.com board for Seniority, then map it by hand.
- Department
Monday.com's default contact board has no native department column.
If you need it. Add a Status or Dropdown column to your Monday.com board for Department, then map it by hand.
- Technologies
Monday.com's default contact board has no native column for a company's tech stack.
If you need it. Add a long Text column to your Monday.com board, or store the data on a separate companies board.
- Industries
Monday.com's default contact board has no native industry column.
If you need it. Add a Status or Dropdown column to your Monday.com board for Industry, then map it by hand.
- Email Quality
Monday.com's default contact board has no native column for an email confidence flag. The Verified Email or Likely Email signal is useful for filtering, Monday just has no standard place for it.
If you need it. Add a Status column to your Monday.com board for email quality, then map it by hand.
- Education
Monday.com's default contact board has no native education column.
If you need it. Add a Text column to your Monday.com board if you want it.
- List Name
Monday.com's default contact board has no native column for the source list a row came from.
If you need it. Add a Text or Status column to your Monday.com board if you want to record which Cognism list a contact came from.
- Diamond Record
Monday.com's default contact board has no native column for Cognism's Diamond-verified flag.
If you need it. Add a Status column to your Monday.com board if you want to keep the flag.
- Profile ID
Monday.com's default contact board has no native column for an external ID.
If you need it. Add a Text column to your Monday.com board if you want Cognism's ID for re-import matching.
- sId
Cognism's internal composite ID has no downstream use in a CRM.
If you need it. None needed. This column is safe to ignore.
- Company Alias
Monday.com's default contact board has no native column for an alternate company trading name. It is often the same as Company Name anyway.
If you need it. Add a Text column to your Monday.com board if you want it.
- Lead Source
Every Cognism row carries the literal value 'Cognism'. Monday.com's default contact board has no native lead source column.
If you need it. Add a Status column to your Monday.com board for lead source and set it after import.
- Personal Linkedin URL
Monday.com's default contact board has no native LinkedIn column.
If you need it. Add a Link column to your Monday.com board called LinkedIn, then map this column to it by hand.
- Country, City, State (person location)
Monday.com's default contact board has no native address columns.
If you need it. Add Text columns to your Monday.com board for City, State, and Country, then map them by hand.
- Website, Headcount, Financials, Company Type, Company Description, Company Founded Year, Company Linkedin URL
These are company-level data points. Monday.com's default contact board has no native columns for them.
If you need it. Add columns to your Monday.com board if you want them on the contact, or store this data on a separate Monday.com companies board and link the two boards.
- Company Address Line, Company City, Company Post Code/ZIP, Company County/State, Company Country
The company registered office address has no native column set on Monday.com's default contact board.
If you need it. Add Text columns to your Monday.com board for the company address, or land it on a companies board.
- Company HQ Address Line, Company HQ City, Company HQ Post Code/ZIP, Company HQ County/State, Company HQ Country
The company HQ address also has no native column set on the contact board.
If you need it. Add Text columns to your Monday.com board, or land it on a companies board.
- SIC, ISIC, NAICS
Monday.com's default contact board has no native columns for industry classification codes. They are company-level data.
If you need it. Add Text columns to your Monday.com board, or store the codes on a companies board.
- Hiring Title, URL, Location, and Date columns (1 through 5)
Monday.com's default contact board has no native columns for hiring-signal data. These columns capture roles the contact's company is hiring for, a real buying signal, but Monday has no standard place for them.
If you need it. Add columns to your Monday.com board if you track hiring activity as a buying signal.
- Job Change - Previous Company, Previous Title, New Company, New Title, Date
Monday.com's default contact board has no native columns for job-change data. A recent job change is a useful champion signal, Monday just has no standard place for it.
If you need it. Add columns to your Monday.com board if you track job changes.
- Location Move - From Country, From State, To Country, To State, Date
Monday.com's default contact board has no native columns for location-move data. The signal is useful for territory planning, Monday just has no standard place for it.
If you need it. Add columns to your Monday.com board if you use them for territory planning.
Formatting and cleanup
Cognism 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 Direct, then Office, then HQ
- 5.Title-cases name fields, including Cognism's ALL-CAPS job titles
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Cognism export and download a clean, import-ready file for Monday.com.
Cognism to Monday.com FAQ
How do I export from Cognism?
In Cognism Prospector, build your search, save the contacts to a list, then click Download CSV from the list view. Upload that CSV 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 Cognism columns with a space so each item displays correctly on the board.
How does the template handle Cognism's four phone columns?
Cognism ships Mobile, Direct, Office, and HQ. Monday's default contact board has one Phone column, so the template fills it with the first available number, checking Mobile first, then Direct, then Office, then HQ. Cognism's Diamond-verified mobiles come through in the Mobile column, so they win when present. All numbers are standardized to international format before import.
Why aren't the job title and the other Cognism columns mapped?
Monday.com's default contact board is lean: Name, Email, Phone, Company, Status, Notes. Job Title, Seniority, the address, and the company firmographics have no native column. The Columns we don't use section above explains how to add a column and map each one by hand.
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 on the board. Run a deduplication pass on your CSV before uploading if you want to avoid duplicate items.
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.
Which address does the template use?
Monday.com's default contact board has columns for Country, City, and State, and this template fills them from Cognism's person-level columns. Those describe where the contact actually is. Cognism also ships two company-level addresses (the registered office and the HQ); both are listed in the Columns we don't use section because they belong on a company-level board, not the contact board.
