How to import LinkedIn URLs into a sales list
Learn how to export LinkedIn profile URLs into a CSV and import them into your sales tool to move from manual browsing to automated outreach sequences.
Get startedShort answer
Export target profiles into a CSV file containing their LinkedIn profile URLs. Upload this CSV to your outreach tool to create a lead group, then assign that group to a messaging campaign.
Gathering the profile URLs
Start with the exact web addresses of the people you want to reach. A LinkedIn profile URL looks like linkedin.com/in/sarah-chen, and it is the only identifier that reliably points at one person. Names repeat across companies. Job titles change every quarter. The URL stays put.
If you don't have a list yet, build one from LinkedIn search. Filter by current job title, location and industry, and keep the filters tight enough that you would be happy to message every single result. Forty people who match your buyer are worth more than four hundred who almost do, because the almost-matches burn invites and teach you nothing.
LinkedIn lets you export your own connections from Settings, under Data privacy. It does not give you an export button for search results, so those URLs get collected by hand or with a tool that reads the page. Either way, you finish with a column of links and a rough memory of why each person is there. Write that reason down while it's fresh.
- 1
Run a narrow search
Open LinkedIn search and add filters for current job title, location and industry. Save the search so you can come back to the same results next week.
- 2
Open profiles one at a time
Work down the list. Skip anyone whose profile looks dormant or whose company doesn't fit the profile you're selling to. You are curating a list, so skip freely.
- 3
Copy the full URL
Take the address from the browser bar rather than the display name. It should read linkedin.com/in/ followed by the handle, with no query string stuck on the end.
- 4
Paste into a single column
One URL per row in Google Sheets or Excel. No extra text in the cell, no leading spaces, no hyperlink formatting.
- 5
Save as CSV
File, then Download, then Comma Separated Values. Open the file once to confirm it looks right before you upload it anywhere.
Formatting your CSV so the import doesn't fail
Most import failures come from the file, not the tool. Merged cells, a title row sitting above the header, curly quotes pasted in from a document, or a URL with tracking parameters on the end will all cause rows to be skipped without an obvious error.
One row per person, one column per field, header in row one. The profile URL is the only column a tool needs to find someone. Extra columns are for you: a name to sanity-check the row, a company to segment on, a note about why you picked them.
Here is a file that imports cleanly. The last column is the one people skip, and it's the one that makes the first message easy to write later.
LinkedIn profile URL
- Field
- Yes
- Required
- linkedin.com/in/sarah-chen
First name
- Field
- No
- Required
- Sarah
Company
- Field
- No
- Required
- Acme
Why they're on the list
- Field
- No
- Required
- Wrote about onboarding a design team
Paste this job
profile_url,first_name,company,why_they_made_the_list https://www.linkedin.com/in/sarah-chen,Sarah,Acme,Posted about onboarding a design team https://www.linkedin.com/in/marcus-webb,Marcus,Northwind,Hiring their first SDRs
Manual list building versus buying a list
You can buy a file of LinkedIn URLs from a data vendor in about ten minutes. You can also build one yourself in an afternoon. The trade-off is fit against volume.
Bought lists go stale in a quiet way. People change jobs, and a URL that pointed at a VP of Marketing at Northwind last year may now point at someone in a different role, or at a profile nobody has touched in months. When a chunk of your import no longer matches, messages land on the wrong people and your acceptance rate slides.
A hand-built list is smaller and slower. It also comes with something a vendor can't hand you: you have read each profile, so you already know what to say in the first line.
Low-quality bulk import
- Importing 500 random URLs from a generic industry list
- Sending the same generic message to everyone
- Ignoring whether the lead is actually active on LinkedIn
High-fit targeted import
- Verifying 50 URLs that match a specific buyer persona
- Grouping leads by a shared pain point or recent company event
- Checking that the profile has been updated in the last 30 days
Connecting the list to outreach
Uploading the CSV gives you a lead group, which is a named bucket of people. The bucket does nothing until a campaign points at it.
Name groups by where they came from and what they have in common. 'Q3 agency founders who post about hiring' tells you more than 'list 4', and when you want a different message for a different segment, the name is how you find them again.
Then write the first message. The note attached to a connection request has a hard character limit, so it has to earn the acceptance in a line or two. Open with the reason the person is on your list. If you can't name that reason, they shouldn't be on it.
- 1
Create the lead group
Upload the CSV, check the row count against your file, and name the group after the segment and the source.
- 2
Write the connection note
Under 200 characters, opening with the specific reason you picked them. No pitch in the note itself.
- 3
Set one follow-up
For people who accept and stay quiet. Reference something from their profile so it doesn't read like a template.
- 4
Watch the pending pool
Track how many invitations sit unanswered. Withdraw the old ones before the pile gets large enough to matter.
Example
- You
Hi Sarah, saw your post about scaling the design team at Acme. I've helped a few 40-person agencies through the same onboarding crunch. Worth connecting?
- Prospect
Thanks for reaching out. We are actually stuck on the onboarding part right now.
- You
That's the part that usually breaks first. I have a short framework for it. Do you have 15 minutes on Tuesday?
What to check when an import goes wrong
Row count is the first thing to check. If you uploaded 120 rows and the group shows 96, then 24 were dropped. The usual causes are duplicate URLs, a URL pointing at a company page instead of a person, or a profile that no longer exists.
Second, check encoding. A file saved from Excel on Windows sometimes arrives with odd characters in the name fields. Open the CSV in a plain text editor and read the first few lines. If an apostrophe shows up as a question mark or a squiggle, re-save the file as UTF-8 CSV.
Third, look for a column with no header. A stray column of notes shifts every field one place to the right, which is how you end up with company names in the first-name field.
- Duplicates: the same person imported twice under two job titles.
- Company pages: a URL with /company/ instead of /in/ will never match a person.
- Trailing spaces: invisible in a spreadsheet, fatal to a matching step.
- Deleted profiles: the URL resolves to a 404 and the row is dropped.
If the row count doesn't match, fix the file before you send anything. A half-imported list means half your messages go out with the wrong context.
Keeping the list usable after the first import
Every import adds to the pile. Six months in, the same person will sit in three groups under two job titles. Decide early how you handle duplicates: either check the URL against existing groups before you upload, or let the tool flag matches and merge them.
Re-importing is normal. You refresh a segment when a target company posts a relevant role or when a new quarter starts. Name the original CSV files with a date so you can tell which import a lead came from when something looks off.
Leads go stale in a specific way: the person is still active on LinkedIn but has moved. A quarterly pass through your groups, checking current company against the company you imported them under, catches most of it. Export the group, spot-check twenty rows, and drop the ones that no longer fit.
Export matters as much as import. Keep a copy of every group outside the tool so a mistake in one campaign doesn't take your list with it.
Doing this with Kinlead
Kinlead imports a CSV of LinkedIn profile URLs and keeps the results in lead groups. Any campaign can point at any group, so one import can feed several sequences, and leads can be exported back to CSV whenever you want a copy.
Connection notes are written by AI from the campaign's goal, tone and your own sales playbook, and each note opens with why that person became a lead. Messages and follow-ups are drafted the same way, and queued messages can be read and edited on the Actions page before they send.
Sending runs from your own LinkedIn account through Unipile, at most one action every 5 minutes, inside the daily invite and message limits you set and inside a send window in the lead's time zone. Stale pending invitations are withdrawn automatically, and if LinkedIn pushes back on an account, invites pause and you get an email.
- Lead search uses LinkedIn's standard search, so no Sales Navigator seat is needed.
- Replies from every campaign land in one inbox, sorted by intent, with interested replies first.
- The Steal Customers agent turns commenters on competitor posts into leads, keeping the post URL and what they said.
Book a walkthrough at book a demo or start on the free trial at create an account.
Frequently asked questions
Related
Get started with Kinlead
Prefer markdown? How to import LinkedIn URLs into a sales list.md