How to format LinkedIn lead lists for automation
Clean and format a LinkedIn lead CSV for automation. Remove duplicates, strip tracking parameters and fix profile URLs before you import the file.
Get startedShort answer
To format a LinkedIn lead list for automation, you need a clean CSV file where every row is a valid, direct LinkedIn profile URL. Remove duplicates and strip non-URL data so your tool doesn't waste invite limits on broken pages or people you've already contacted.
Isolate the profile URLs
Automation tools can't search for people by name, because names aren't unique. Give a tool "John Doe, Acme" and it may land on the wrong John Doe, or on nobody at all. A direct profile URL is the only identifier that points at one person, which is why every import flow starts with a column of links.
Keep the file to the targets for one campaign. A master database of everyone you have ever found is a different file with a different job, and mixing the two means you re-message people you already contacted. Extra columns like phone numbers, emails or free-text notes are where imports break, because the tool has to guess which column holds the profile and often guesses wrong.
If you need context, such as where the lead came from or which post they commented on, put it in a second column with a clear header like source_note. Most tools ignore columns they don't recognise. What they can't ignore is a URL column that is half full of names.
Weak import file
- Column A: John Doe, Column B: Acme Corp, Column C: CEO
- Column A: linkedin.com/in/jane-doe, Column B: notes about the call, Column C: email
Clean import file
- Column A header: url, Column B header: source_note
- Every row: https://www.linkedin.com/in/jane-doe
Standardize the URL format
The same profile can be written several ways. LinkedIn adds tracking parameters when you copy a link from the feed, and a trailing slash is easy to pick up along the way. To a spreadsheet, https://www.linkedin.com/in/jane-doe/?trk=public_post and https://www.linkedin.com/in/jane-doe are two different strings, so your dedupe step won't catch them.
Pick one format and force every row into it: https://www.linkedin.com/in/slug, lowercase, no query string, no trailing slash. LinkedIn slugs are case-insensitive, but string comparison in a spreadsheet is not, so Jane-Doe and jane-doe will survive as separate rows if you let them.
Company pages are the other common contaminant. A /company/ URL points at a page that can't receive a connection request, so the row is dead weight. Delete anything containing /company/, /school/ or /events/ before you go further.
linkedin.com/in/jane-doe/?trk=public_post
- Original URL
- linkedin.com/in/jane-doe
- Cleaned URL
- Remove the query string
linkedin.com/in/jane-doe/
- Original URL
- linkedin.com/in/jane-doe
- Cleaned URL
- Remove the trailing slash
linkedin.com/in/Jane-Doe
- Original URL
- linkedin.com/in/jane-doe
- Cleaned URL
- Lowercase the slug
linkedin.com/company/northwind/
- Original URL
- Delete the row
- Cleaned URL
- Company pages can't receive invites
Paste this job
=IF(REGEXMATCH(A2,"linkedin\.com/in/"), "https://www.linkedin.com/in/"&LOWER(REGEXEXTRACT(A2,"linkedin\.com/in/([^/?#]+)")), "DELETE")
Remove duplicate profiles
Duplicates arrive from everywhere. You pull one list from a competitor's post comments and another from a search, and the same ten people sit in both. Send both and someone gets two invites in a week, which reads as spam and gets you ignored or restricted.
Dedupe after you clean the URLs. If you dedupe first, the tracking parameters hide matches and you end up with the same person twice under two different strings.
Sort alphabetically as a second check. Two rows with different slugs but the same display name usually mean the person changed their vanity URL, or that you exported the same profile from two tools with different settings.
- 1
Clean the URLs first
Run the standardization formula before you dedupe. Raw URLs with different tracking parameters won't match each other.
- 2
Select the URL column
Highlight the whole column in Google Sheets or Excel so the tool only compares profile links.
- 3
Run remove duplicates
In Excel, Data then Remove duplicates. In Google Sheets, Data, then Data cleanup, then Remove duplicates.
- 4
Check the remaining count
Compare row counts before and after. If nothing was removed, your URLs probably still have different formats.
Filter out unreachable leads
A URL that 404s still costs you. The tool opens the page, finds nothing, and the attempt counts as activity on your account. A handful of failures is noise. A few dozen in one run looks like a scraper working through a list.
Check the list against your existing connections before you import. Anyone already connected doesn't need an invite, and anyone you invited last month shouldn't get another one. Most tools can't tell the difference, so the filter has to happen in the file.
Strip out the obvious non-people as well: company pages, school pages, event pages, and anything with a query string that suggests a private or internal link. Those never resolve for an automation tool, no matter how many times it retries.
- Company, school and event pages (/company/, /school/, /events/)
- Rows where the URL column is empty but other columns have data
- Profiles you already messaged in a recent campaign
- Links with more than one query parameter, which usually means a copied session URL
A failed page load still counts as account activity. Delete rows you can't verify rather than hoping the tool skips them.
Final export settings
Save as CSV, UTF-8, comma delimited. Excel's "CSV UTF-8" option works. "Excel Workbook" does not survive the trip, and neither does PDF. Even when a tool accepts .xlsx, the formatting inside it (merged cells, hidden rows, formulas that were never calculated) causes problems that a plain CSV avoids.
Open the file in a text editor once before importing. You're checking three things: the header row is there, each line ends with a URL and not a stray comma, and no quote characters are wrapping every field. If you see HTML tags or symbols, your spreadsheet exported formatting instead of text.
- 1
Name the column
Put a header in row 1 called url or profile_url. Tools look for a header to map the column correctly.
- 2
Save as CSV UTF-8
File, Save as, then CSV UTF-8 (comma delimited). Skip Excel Workbook and PDF.
- 3
Read it in a text editor
Open the file in Notepad or TextEdit. You should see one header line and one URL per line, separated by commas.
Doing this with Kinlead
Once the file is clean, you can import LinkedIn URLs into a lead group. Kinlead opens each profile, scores it from 0 to 100 against the customer you described, and drops anything below the fit line, so a rough list gets filtered before anyone is messaged.
Limits live in Settings: daily invite and message caps you set, plus a send window in the lead's time zone. Kinlead sends at most one action every 5 minutes per LinkedIn account, so a large import doesn't turn into a burst of activity.
- Connection notes are AI-written, under 200 characters, and open with why that person became a lead.
- Queued messages can be read and edited on the Actions page before they send, and any campaign can be paused.
- Each campaign chooses how replies are handled: hand off at the first reply, AI replies until real interest, or AI replies until a meeting is booked with your scheduling link.
Frequently asked questions
Related
Get started with Kinlead
Prefer markdown? How to format LinkedIn lead lists for automation.md