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 started

Short 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. 1

    Clean the URLs first

    Run the standardization formula before you dedupe. Raw URLs with different tracking parameters won't match each other.

  2. 2

    Select the URL column

    Highlight the whole column in Google Sheets or Excel so the tool only compares profile links.

  3. 3

    Run remove duplicates

    In Excel, Data then Remove duplicates. In Google Sheets, Data, then Data cleanup, then Remove duplicates.

  4. 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. 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. 2

    Save as CSV UTF-8

    File, Save as, then CSV UTF-8 (comma delimited). Skip Excel Workbook and PDF.

  3. 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