How to import LinkedIn Sales Navigator data into Freshsales
LinkedIn Sales Navigator lead lists are pulled into a CSV by a scraper like Evaboot. This template maps that export to Freshsales's standard contact fields: names, job title, country, company name, and the work email. Email carries data on Evaboot Pro tiers and is blank on the baseline export. Names are title-cased and country names are normalized. Mutual connections and the contact's two previous roles are composed into Freshsales's Description field as a multi-line block, one labeled line per non-empty slot, so reps see the warm-intro and champion signals on the contact record. Data Freshsales has no standard contact field for is listed in the Columns we don't use section.
Field-by-field mapping
This is the complete column mapping from LinkedIn Sales Navigator to Freshsales. The left column is the header in your CSV export. The right column is the Freshsales field it should map to.
| Emailemail Sales Navigator's standard export ships an Email column, populated on Evaboot Pro and higher tiers and empty on the baseline tier. When populated, the work email maps here. TransformLowercased and trimmed | ||
| First Name | First Namefirst_name TransformTitle-cased and trimmed | |
| Last Name | Last Name*last_name TransformTitle-cased and trimmed | |
| Job Title | Job Titlejob_title | |
| Country | Countrycountry Sales Navigator ships a person Country column parsed from the contact's Location. It maps to the Freshsales contact's Country field. The free-text Location string is not mapped. | |
| Company Name | Company Namecompany_name | |
| Descriptiondescription Three slots compose into Freshsales's Description field as a labeled multi-line block. Slot 1 is Mutual Connections on its own. Slot 2 is the most recent previous role (Past Title 1, Past Company 1, Past Company Duration 1). Slot 3 is the role before that (Past Title 2, Past Company 2, Past Company Duration 2). Each slot renders as '- column: value | column: value' on its own line. Empty slots are skipped, so contacts with no past roles or no mutual connections land with whichever subset is populated. Remove the row in the column mapper if you don't want it. TransformComposed into a multi-line block |
Required by Freshsales.
Columns we don't use
Your LinkedIn Sales Navigator export includes 26 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Freshsales.
- Personal Email
This CRM has one email field, and the work Email column is mapped to it. The work email is the higher-fidelity channel for B2B outreach and the lower-risk channel under GDPR, since a personal address needs explicit consent in most EU jurisdictions.
If you need it. Map it by hand to a custom email field in the column mapper if you want the personal address kept as a fallback.
- Full Name
First Name and Last Name are mapped separately, so Full Name is redundant. It is the same person's name in one field instead of two.
If you need it. None needed. Freshsales shows the contact name from First Name and Last Name.
- Profile URL, Sales Navigator URL
Freshsales contacts have no native LinkedIn field.
If you need it. Create a custom URL field on the Freshsales contact called LinkedIn, then map Profile URL to it by hand.
- Location
Sales Navigator's Location is a free-text string like 'London, England, United Kingdom'. Freshsales' City field expects a parsed city, and the standard Sales Navigator export has no person-level city column. The parsed Country column is mapped instead.
If you need it. Map it by hand to the Freshsales Address field, or to a custom contact field, if you want the verbatim location string kept.
- Company Industry, Company Size, Company Headcount, Company URL, Company Website, Company Founded, Company Description, Company Specialties
These are company-level data points. Freshsales stores firmographics on the Sales Account record, not the Contact.
If you need it. Enrich the matched Freshsales Sales Account record after import using Sales Navigator's company data.
- Company Location, Company Country, Company City
These describe where the company is, not where the contact is. They belong on the Freshsales Sales Account record.
If you need it. Land the company location on the matched Freshsales Sales Account record in a separate pass if you need it.
- Years in Role, Years in Company
Freshsales contacts have no native fields for role or company tenure. The data is a useful 'just changed jobs' filter, Freshsales just has no standard place for it.
If you need it. Create custom number fields on the Freshsales contact for tenure, then map them by hand.
- Description, Education Top
Freshsales contacts have no native field for a LinkedIn About summary or a top education entry. The data is real, Freshsales just has no standard place for it.
If you need it. Create custom contact fields in Freshsales, then map them by hand.
- Skills, Languages
Freshsales contacts have no native multi-select field for skills or languages. Both columns are comma-separated lists of several values.
If you need it. Create custom contact fields in Freshsales if you want them, then map them by hand.
- Connection Degree, Shared Connections
Freshsales contacts have no native fields for the connection-degree integer or the shared-connections count. Mutual Connections (the named-list column) is composed into the Description field; these two are the numeric signals beside it.
If you need it. Create custom contact fields in Freshsales if you run warm-intro plays from connection data.
- List Name, Scraped At
Freshsales contacts have no native field for the Sales Navigator list a row came from or the date it was scraped.
If you need it. Create custom contact fields in Freshsales if you want to record which Sales Navigator search a contact came from.
Formatting and cleanup
LinkedIn Sales Navigator exports rarely match the format Freshsales expects. Fix these before you import.
- 1.Maps the work Email column to the Freshsales contact's email field when the export includes it
- 2.Title-cases name fields
- 3.Maps the parsed Country column to the Freshsales contact's Country field
- 4.Composes Mutual Connections and the two previous-role slots into the Description field as a labeled multi-line block, skipping empty slots
- 5.Normalizes country names to a standard form
- 6.Trims whitespace and removes blank rows
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your LinkedIn Sales Navigator export and download a clean, import-ready file for Freshsales.
LinkedIn Sales Navigator to Freshsales FAQ
How do I get a CSV out of LinkedIn Sales Navigator?
Sales Navigator no longer has a built-in CSV export for lead lists. Most teams use a scraping tool such as Evaboot, Wiza, or PhantomBuster, which reads your Sales Navigator lead list and gives you a CSV. This template is built for the standard Evaboot column set. Upload that file to Operelio.
Does this template map email?
Yes. Sales Navigator's standard export ships an Email column that is populated on enrichment tiers (Evaboot Pro and up) and empty on the baseline tier. The template maps that work Email column to the Freshsales contact's email field, so a Pro-tier export lands email and a baseline export leaves it blank. The separate Personal Email column is left unmapped, since the Freshsales contact has one email slot and the work email is the higher-fidelity B2B channel. The export has no phone column, so phone is not mapped.
Why isn't the Location column mapped?
Sales Navigator's Location is a free-text string like 'London, England, United Kingdom'. Freshsales' City field expects a parsed city, and the standard Sales Navigator export has no person-level city column. The template maps the parsed Country column instead. The Location column is listed in the Columns we don't use section.
Where do company-level fields like industry and headcount go?
Freshsales stores firmographics on the Sales Account record, not the Contact. This template doesn't push them to the Contact. After the contacts import and Freshsales matches them to Sales Accounts, enrich those Sales Accounts separately using Sales Navigator's company data.
Where do I import the CSV into Freshsales?
In Freshsales, go to Contacts, click Import, and upload the file Operelio produces. The import wizard matches the column headers to contact fields.
Will this create duplicate contacts in Freshsales?
Freshsales uses email as the unique identifier on contacts. This template maps the work Email column, so when your export includes email, Freshsales matches on it. On baseline-tier exports the Email column is empty, so review your import settings in Freshsales to control how those rows match existing contacts.