Lusha User Data
Monday.com Contacts5 fieldsHow to import Lusha User Data into Monday.com
Lusha ships at least two CSV export shapes. This template handles the User Data export, the one with a single Contact name column, three email slots, and six type-named phone slots. Lusha's single Contact name column is exactly what Monday.com's single Name column expects, so it maps across verbatim. The template also maps work email and company, and parks the job title in Notes since Monday.com boards have no default title column. Lusha runs on a credit-per-reveal model, so any email or phone column can be blank for contacts you have not revealed yet. Mobile, Direct phone, and Phone are combined into Monday.com's single Phone column, mobile-first. If your export has separate First name and Last name columns, use the Lusha Prospecting template instead.
Field-by-field mapping
This is the complete column mapping from Lusha User Data 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.
| Lusha User Data column | Monday.com field | |
|---|---|---|
| Contact name | Name Lusha's User Data export ships the full name in a single Contact name column, which is exactly what Monday.com's single Name column expects, so it maps across verbatim. | |
| Work email | Email TransformLowercased and trimmed | |
| Company name | Company | |
| Mobile → Direct phone → Phone | Phone Monday.com's default contact board has one Phone column. Mobile, Direct phone, and Phone are combined into Phone, taking the first available number in that order. Mobile wins when present. TransformStandardized to international format (+1, +44, etc.) | |
| Job title | Notes Monday.com's default contact board has no job-title column. Job title maps to the Notes column so the title carries over to the board item. |
Columns we don't use
Your Lusha User Data export includes 8 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Monday.com.
- Work email 2, Private email
Monday.com's default contact board has one Email column, which this template fills from Work email. A secondary work email and a personal email have no native place on the board.
If you need it. Add Text columns to your Monday.com board for the extra emails, then map them by hand.
- Mobile 2, Phone 2, Direct phone 2
Monday.com's default contact board has one Phone column, which this template fills from the first available of Mobile, Direct phone, and Phone. The second numbers in each pair have no native place on the board.
If you need it. Add Phone columns to your Monday.com board if you want every number kept separately.
- LinkedIn profile
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 this column to it by hand.
- Industry, Sub industry
Monday.com's default contact board has no industry column, and these are company-level data points.
If you need it. Add Status or Dropdown columns to your Monday.com board for Industry and Sub industry, then map them by hand.
Formatting and cleanup
Lusha User Data exports rarely match the format Monday.com expects. Fix these before you import.
- 1.Maps Lusha's single Contact name column to 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 phone, then Phone
- 5.Maps Job 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 Lusha User Data export and download a clean, import-ready file for Monday.com.
Lusha User Data to Monday.com FAQ
Which Lusha export does this template expect?
The User Data export, which ships a single Contact name column, three email slots, and six type-named phone slots. If your export has separate First name and Last name columns plus Seniority and Departments, that's the Prospecting export. Use the Lusha Prospecting to Monday.com Contacts template for that shape.
How do I export from Lusha?
In Lusha, open the list you want, then use the list's export option to download a CSV. Lusha emails you a download link when the file is ready. Upload that CSV to Operelio.
Why doesn't this template split the name?
Monday.com items use a single Name column, which is exactly the shape Lusha's User Data export already ships in its Contact name column. So the column maps across verbatim, no split needed.
Why are some email and phone columns blank?
Lusha uses a credit-per-reveal model, so contacts you haven't spent credits to reveal ship with blank email or phone columns. Operelio preserves those blanks rather than guessing values.
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.
