How to import LinkedIn profile URLs for prospecting
Build a clean CSV of LinkedIn profile URLs, map the columns, check the preview, and start outreach without messaging the wrong person. A practical import guide.
Get startedShort answer
To import LinkedIn profiles, make a CSV with one column of full profile URLs in the form https://www.linkedin.com/in/username. Upload it to your tool, map the URL column to the profile link field, and check the preview before you save. Names and companies are for personalization only; the URL is what tells the tool who to message.
What a LinkedIn profile URL import actually needs
A LinkedIn profile URL import is not a name import. It is a way to hand a tool a list of specific people. The tool needs the profile URL because names repeat and job titles change. A URL points to one profile.
You need three things: a CSV file, one column of full profile URLs, and a tool that accepts a URL import. First name, company and title are optional fields for personalization. The URL does the matching.
A full profile URL looks like https://www.linkedin.com/in/jane-doe-123. A company page, a post link or a search result page will not work as a lead URL. Keep that distinction clear before you build the list.
People often paste a LinkedIn search URL and expect the tool to read the result page. It cannot. A search URL contains query parameters, not a list of people. You have to open each profile and copy the URL, or use a tool that exports profile URLs for you.
Build the CSV before you touch the tool
Start in a spreadsheet with four columns: profile_url, first_name, last_name and company. Add title or a source note if your messages use them. Keep profile_url in the first column so mapping is obvious.
Use the full URL, including https://www.linkedin.com/in/. Do not shorten it to /in/username or paste the display name. If you copy from the browser, remove anything after the username.
Save the file as CSV UTF-8. Excel on Windows sometimes saves a normal CSV that mangles accents or special characters. CSV UTF-8 avoids that.
Column names do not have to match the tool exactly, but they should be clear to you. Use lowercase with underscores if you will edit the file in a script. Use plain words if a teammate will open it in Excel. The import map is easier when the header says what the column holds.
If you use a source note, keep it short. A full sentence is fine. Do not paste an entire comment thread into a cell. The note is for you and for the first line of the message, not for a data warehouse.
profile_url
- Column name
- https://www.linkedin.com/in/jane-doe-123
- Example value
- The only field the tool needs to find the person
first_name
- Column name
- Jane
- Example value
- Personalization tag, not a matching field
company
- Column name
- Northwind
- Example value
- Personalization tag and filtering note
source_note
- Column name
- Commented on Acme post
- Example value
- Your own context for the follow-up
Paste this job
profile_url,first_name,last_name,company,source_note https://www.linkedin.com/in/jane-doe-123,Jane,Doe,Northwind,Commented on Acme post https://www.linkedin.com/in/marcus-lee-456,Marcus,Lee,Acme,Attended same webinar
Clean the URLs so the import does not break
LinkedIn adds tracking parameters when you copy a URL from a feed or a search result. The profile still works, but the extra string can confuse a simple importer. Strip everything from the question mark onward.
Check the prefix on every row. A profile URL starts with https://www.linkedin.com/in/. A company URL starts with /company/. A post URL starts with /posts/ or /feed/update/. Only the /in/ links belong in the profile URL column.
Remove duplicates on the URL column. The same person can appear twice with different tracking strings. Deduplicate after cleaning, not before.
Some URLs have a trailing slash. Pick one format and use it for every row. Open five random URLs in a browser. If they load a profile, the format is probably right. If they load a feed or a company page, fix the row.
- 1
Strip tracking parameters
Delete everything after the question mark. https://www.linkedin.com/in/jane-doe-123?trk=profile-visit becomes https://www.linkedin.com/in/jane-doe-123.
- 2
Keep only profile links
Filter or sort the URL column. Delete company pages, group pages, post links and search result links. They are not leads.
- 3
Remove duplicates
Use Remove duplicates in your spreadsheet on the URL column. Do this after stripping parameters so two versions of the same link collapse into one.
- 4
Delete blank rows and broken rows
Blank rows can create empty leads. A URL that does not start with https://www.linkedin.com/in/ should be fixed or removed before upload.
Map the columns and check the preview
Every tool names the fields differently. You are looking for a field called Profile URL, LinkedIn URL, Person link or something close. Map your profile_url column to that field. Map first_name and company to the matching personalization fields.
The preview is the last place to catch a bad map. If the preview shows Hi Northwind where the first name should be, the company column is in the wrong field. Fix the map before you import the whole file.
Import a small batch first. Ten rows is enough to see whether the tool reads the URLs and whether the personalization fields land in the right place. Then import the rest.
Mapping is a one-time setup per file. If you import the same column layout every week, save a template. If you change the order, check the preview again. The tool does not know that column C is company just because it was company last time.
A clean URL gets the person. A clean map gets the message right. Check both before you upload the full file.
Decide how you will source the URLs
Common sources include people who engaged with a post, people from a search result, and people you already know from email or events. Each source gives you a different reason to reach out. The URL import only handles the mechanics.
If you collect from a post, keep the post URL in a separate column. The comment or reaction is the reason you are reaching out. Without that note, the first message becomes generic.
If you collect from LinkedIn search, copy the profile URLs one by one. Search result pages are not profile URLs. Do not paste a search URL into the import file.
People who comment on a competitor's post are a strong source because the comment gives you a reason. People from a search result are weaker because you only know they match a filter. People you already know are stronger because you have a shared context. Sort your list by the strength of the reason, not by the size of the file.
URL list with no context
- https://www.linkedin.com/in/jane-doe-123
- https://www.linkedin.com/in/marcus-lee-456
- https://www.linkedin.com/in/priya-shah-789
URL list with a reason
- https://www.linkedin.com/in/jane-doe-123 | commented on Acme post about onboarding
- https://www.linkedin.com/in/marcus-lee-456 | attended the same webinar
- https://www.linkedin.com/in/priya-shah-789 | former customer, left Northwind last month
What to check after the import
Open the imported list and look at the first five leads. Check the name, company and URL. If one field is shifted, delete the batch and fix the CSV before you launch a campaign.
Count the rows. If you uploaded 200 rows and the tool shows 180 leads, 20 rows were skipped or merged. Find out why before you add more. Common causes are duplicates, broken URLs and blank rows.
Check the source note. If the note says commented on Acme post, open the post and confirm the comment is still there. People delete comments. A stale note makes the first message wrong.
Write the first message before you import the next list. If the message needs a company name, a post topic or a job title, add that column now. Retrofitting context after the import is slower than collecting it once.
Keep the original CSV. You will need it when you change tools, clean duplicates or hand the list to a teammate. A lead group is not a backup.
Doing this with Kinlead
Kinlead imports leads from a CSV of LinkedIn profile URLs into lead groups. You can point any campaign at any group, so the import does not lock you into one sequence. You can also export leads to CSV when you need a backup or a handoff.
Lead search uses LinkedIn's standard search, so you do not need a Sales Navigator seat to build a list. If you already have URLs, the CSV import is the shorter path.
Outreach runs from your own LinkedIn account through Unipile. Kinlead does not store your LinkedIn password. It sends at a human pace, with one action every 5 minutes per account inside the daily invite and message limits you set and inside a send window in the lead's time zone.
Importing a list does not send anything. The send window and daily limits control what leaves your account after the import.
Frequently asked questions
Related
Get started with Kinlead
Prefer markdown? How to import LinkedIn profile URLs for prospecting.md