How to build a LinkedIn lead list from a CSV
How to format LinkedIn profile URLs in a CSV, clean the list, map the columns on import and write a first message that gets a reply from the right person.
Get startedShort answer
Put one full LinkedIn profile URL per row in a spreadsheet, strip the formatting and tracking strings, and save it as a plain CSV. On import, map the URL column to the tool's profile identifier field. The URL is the only thing that reliably points at the right person, so a list without it will send messages to the wrong profiles.
Prepare your CSV file
Most tools identify a person by the profile URL and nothing else. Hand over a name and a company and the software has to guess which of the several people with that name you meant. That guess is how a message written for a VP of operations lands with someone who left the company two years ago.
Keep the sheet lean. Bold text, cell colors, merged rows and frozen panes do not survive a CSV export cleanly, and the ones that do can push data into the wrong column.
Where the URLs come from matters more than the format. A list built from people who commented on a competitor's post is worth more than a scraped export of 5,000 names, because the first one has a reason attached to every row.
- 1
Create a URL column
Title it Profile URL and put the full link in every row, like https://www.linkedin.com/in/jane-doe-acme. A bare username or a display name will not resolve to a profile.
- 2
Remove duplicates
Run the spreadsheet's remove duplicates tool on the URL column. Two rows for the same person means two connection requests to the same profile, and the second one reads as a mistake.
- 3
Strip formatting
Select all, then clear styles, borders and fills. Plain text in a standard grid is the only thing every importer agrees on.
- 4
Export as CSV
Save as comma separated values, not xlsx and not pdf. If your app offers a UTF-8 option, take it, because accented characters in job titles break otherwise.
Paste this job
Profile URL,First Name,Company,Source https://www.linkedin.com/in/jane-doe-acme,Jane,Acme,Conference list https://www.linkedin.com/in/marcus-lee-northwind,Marcus,Northwind,Competitor commenters
Clean your lead data
Dirty data breaks imports. A line break inside a cell, a trailing space, or a link that picked up a tracking string will either fail the upload or land a row that points at nothing.
LinkedIn share links often look like linkedin.com/in/username?utm_source=share&utm_campaign=copy. Everything after the question mark is not part of the profile. Strip it before you import, or the tool may treat the whole string as the identifier.
Audit before you upload. Open the first ten URLs by hand. If three of them fail to load, the rest of the list has the same problem, and you should fix the source before you spend an hour on the file.
Will break the import
- A column of names with no URLs
- Links with tracking strings like ?utm_source=share
- Cells carrying HTML or background colors
- Merged cells for company names
Will import cleanly
- One full profile URL per row
- Links with nothing after the username
- Plain text in a standard grid
- One lead per row, header row on top
Check for dead links before the import, not after. If someone deleted their profile or changed their handle, the row either errors out or gets skipped silently, and you will not notice until the campaign reports fewer leads than you uploaded.
Paste this job
=IFERROR(LEFT(TRIM(A2),FIND("?",TRIM(A2))-1),TRIM(A2))Map your columns during import
The upload screen asks you to match your columns to the tool's fields. This step decides what the software knows about each person, so it is worth doing slowly.
Your URL column maps to the profile identifier. Everything else is optional but useful. First name and company feed personalization. A source column tells you later which list actually produced conversations, which is the only way to know which list to rebuild.
Anything the tool has no field for should go into a custom field rather than get dropped. That is where notes like which post someone commented on end up living.
- 1
Upload the file
Pick the cleaned CSV. If the tool rejects it outright, the problem is almost always an encoding or delimiter issue, not the data itself.
- 2
Match the URL field
Point your Profile URL column at the profile identifier field, and check any auto-detected match you did not intend.
- 3
Assign the rest
Map first name, company and job title to their fields, and send anything else to a custom field so it stays attached to the lead.
- 4
Check the sample
Most importers show a preview. Read three rows against your spreadsheet and confirm the names and URLs line up before you commit.
Segment your imported leads
Do not push everyone into one list. A person who downloaded your pricing page and a person who commented on a competitor's launch need different opening lines, and mixing them means the message is written for nobody.
Split the file by how each person relates to your business, then run one campaign per group. The source column you kept during import is what makes this possible a month later.
Cold lists are the weakest group and should be treated that way. If a row has no reason attached beyond a job title, expect it to do the least work and put it in its own campaign so it cannot drag down the groups that do have context.
Warm
- Lead group
- Visited a pricing or demo page
- Where they came from
- Names the page and asks what they were comparing
Competitor
- Lead group
- Commented on a rival's recent post
- Where they came from
- Refers to the post and the point they made in the comments
Event
- Lead group
- Attendee list from a conference
- Where they came from
- Mentions the session and asks what they took from it
Cold
- Lead group
- A purchased or scraped export
- Where they came from
- Leads with a specific problem that role usually has
What to do when the import fails
Imports fail in a small number of ways, and each one has a fix you can make in the spreadsheet rather than in the tool.
- Every row errors: the delimiter is wrong. Open the file in a text editor and check that commas separate the columns, not semicolons.
- Half the rows import: those URLs are malformed or dead. Filter the URL column for anything that does not start with linkedin.com/in/.
- Names arrive in the wrong field: the tool did not detect your header row. Re-upload and mark row one as headers.
- Accented characters turn into symbols: the file was saved in the wrong encoding. Re-export as UTF-8.
- Duplicates appear: the tool matched on a field other than the URL. Check which field it used as the identifier.
When nothing obvious is wrong, import ten rows as a test. A ten row file that succeeds tells you the format is fine and the problem sits somewhere in the larger file.
Write the first message for imported leads
An imported list gives you a URL and maybe a name. It does not give you a reason to write. Add that reason yourself by reading the profile before the message goes out, or by keeping the post or page that put the person on the list.
The opening line should say why this person and not someone else. If you cannot write that sentence, the lead does not belong in the campaign yet.
Keep it short enough to read on a phone. Two sentences is usually enough to earn a reply, and a third sentence about your product usually loses it.
Example
- You
Hi Priya, saw your comment on Northwind's post about moving off spreadsheets. You said the migration went fine but the reporting didn't. Is that still the issue?
- Prospect
Ha, yes. We ended up building our own dashboard.
- You
That's usually the point where the spreadsheet comes back. Worth a short call to compare notes? I work with ops teams on exactly that handoff.
- Prospect
Sure, Thursday works.
Doing this with Kinlead
Kinlead imports a CSV of LinkedIn profile URLs into a lead group and scores each lead from 0 to 100 against the customer you describe. Anything below your fit line is not kept, so a campaign starts from the rows that match rather than the whole file. Groups can also be exported back to CSV whenever you need them elsewhere.
Queued messages can be read and edited on the Actions page before they send, and stale pending invitations are withdrawn automatically so the pending pool stays healthy.
- 1
Import the URLs
Upload the cleaned CSV into a lead group.
- 2
Set the fit line
Score the group against your customer profile and drop the rows that fall below it.
- 3
Point a campaign at the group
Any campaign can use any group. Connection notes run under 200 characters and open with why that person became a lead.
- 4
Set limits and a window
Choose your daily invite and message limits and a send window in the lead's time zone. Each LinkedIn account sends at most one action every 5 minutes.
Frequently asked questions
Related
Get started with Kinlead
Prefer markdown? How to build a LinkedIn lead list from a CSV.md