How to clean and import LinkedIn lead lists

Learn how to format, clean, and upload your LinkedIn profile URLs to automation tools using CSV files to avoid import errors and account flags.

Get started

Short answer

To upload LinkedIn profile URLs to automation, clean your list by removing non profile links and duplicates, then save it as a CSV file with a single column of full URLs. Most tools need the full linkedin.com/in/username format to identify the person.

Verify your URL format

Automation tools find a person by the unique slug at the end of their profile URL. If the link is incomplete or points to a company page, the tool will skip the row or reject the file during upload.

You need the full absolute URL. Include the https protocol and the /in/ path for individual profiles. A link that starts with linkedin.com/in/ but has no protocol may work in a browser, but many importers treat it as invalid text.

If you only have names, usernames or old profile IDs, convert them to full URLs before you build the CSV. Do not guess the slug. Open the profile, copy the address from the browser, and paste it into your sheet.

A profile URL with a query string can also fail. Remove everything after the username, including tracking codes, so the importer sees a clean profile address.

Invalid formats

  • linkedin.com/in/john-doe (missing https://)
  • https://www.linkedin.com/company/acme-corp (company page)
  • https://www.linkedin.com/search/results/ (search page)
  • https://www.linkedin.com/profile/view?id=123 (old format)

Valid format

  • https://www.linkedin.com/in/john-doe-12345/
  • https://www.linkedin.com/in/jane-smith-b2b/

Clean your spreadsheet

Dirty data wastes import slots and breaks campaigns. Before you export, strip out everything that is not a valid person profile.

Most people build the list in Google Sheets or Excel. Use the built-in data tools so you do not upload the same person twice or try to message a company page.

Sort the sheet by the URL column before you remove duplicates. Sorting brings identical links next to each other, so you can spot near matches that the duplicate tool misses, such as one URL with a trailing slash and one without.

  1. 1

    Isolate the URLs

    Paste all links into one column. Keep names or emails in separate columns for now, but make sure the URL column is clean and every row has a value.

  2. 2

    Remove duplicates

    In Google Sheets, go to Data, Data cleanup, Remove duplicates. Select only the URL column so every profile appears once.

  3. 3

    Filter out non profiles

    Turn on filters for your header row. Click the filter icon in the URL column, select Filter by condition, and choose Text contains. Search for company or search and delete those rows.

  4. 4

    Clear empty rows

    Sort the column A to Z to push blank cells to the bottom, then delete them so the importer does not hit a null value.

Decide which columns to keep before export

Some importers accept only a single column of URLs. Others ask for a name, company or note column next to the URL. Read the import screen before you delete anything.

If the tool asks only for profile URLs, keep one column and delete the rest. Extra columns can shift the mapping and make the importer read a company name as a URL.

If the tool asks for names, keep the name column next to the URL column and make sure every row has a URL. A name without a URL is not a lead your tool can find.

If you are unsure, export a test file with only the URL column. Add columns back only when the importer rejects the file for missing data.

Profile URLs only

What the importer asks for
URL column
Columns to keep
Names, companies, notes, emails

URL plus name

What the importer asks for
URL and name columns
Columns to keep
Notes, emails, old owner fields

URL plus company

What the importer asks for
URL and company columns
Columns to keep
Free text notes, phone numbers

Export to CSV

Automation tools cannot read .xlsx or .pdf files. They need a Comma Separated Values file, which is a plain text version of your spreadsheet.

If your tool only asks for URLs, delete all other columns before exporting. This stops the software from reading extra data like phone numbers or notes as part of the URL.

Export from the spreadsheet app instead of renaming a file. A renamed .xlsx file still contains spreadsheet formatting and will fail in most importers.

Open the CSV in a plain text editor before you upload. You should see one URL per line, or URLs separated by commas if you kept more than one column. If you see spreadsheet formatting, formulas or hidden characters, export again.

  1. 1

    Strip unnecessary columns

    Right click and delete any column that does not contain a LinkedIn URL if the tool does not ask for name or company data.

  2. 2

    Download as CSV

    In Google Sheets, go to File, Download, Comma Separated Values (.csv). In Excel, go to Save As and select CSV (Comma delimited).

  3. 3

    Verify the file

    Open the .csv file in a basic text editor like Notepad or TextEdit. You should see URLs separated by commas or new lines with no strange symbols.

Never rename the file extension manually from .xlsx to .csv. Use the Save As or Download function so the app writes a plain text file.

Check for common upload errors

Even with a clean list, imports can fail because of file size, account limits or a mismatch between the URL and the tool's expected format.

If your upload hangs or returns a partial list, match the error message to the cause before you edit the file again.

Fix one cause at a time. If you change the URL format, the column order and the batch size in the same upload, you will not know which change solved the problem.

Invalid URL

Error message
Shortened links or redirects
Common cause
Expand the URL to the full version

Limit reached

Error message
File is larger than the importer accepts
Common cause
Split the CSV into smaller batches

Wrong format

Error message
Uploaded .xlsx instead of .csv
Common cause
Re-export as Comma Separated Values

Duplicate lead

Error message
Same profile appears twice
Common cause
Remove duplicates before upload

Test with a small batch first

Upload five to ten rows before you import the full list. A small test shows you whether the tool reads your column order, URL format and duplicate handling correctly.

If the test works, import the rest in batches. If it fails, fix the file while the list is small. Deleting a bad import is easier than cleaning up hundreds of skipped or duplicated leads.

Keep the test file separate from your master list. If the test import adds the same leads to a campaign, pause the campaign before you upload the full file.

  1. 1

    Create a test file

    Copy the first ten rows from your cleaned list into a new CSV. Use the same column order you plan to use for the full file.

  2. 2

    Check the imported count

    Compare the number of rows in the file with the number of leads the tool shows. If the tool skipped rows, open the file and look for bad URLs or blank cells.

  3. 3

    Import the full list in batches

    Upload the rest in groups your importer can handle. Check the count after each batch so you catch a bad row before it affects the whole list.

Doing this with Kinlead

Kinlead imports a CSV of LinkedIn profile URLs into lead groups. Any campaign can point at any group, so you can keep a cleaned list separate from leads found by search or by the Steal Customers agent.

Outreach runs from your own LinkedIn account, connected through Unipile. Kinlead never stores your LinkedIn password. It sends at most one action every 5 minutes, inside daily invite and message limits you set and inside a send window in the lead's time zone.

If you already have a CSV from another source, clean it with the steps above before you import. Kinlead keeps each list in a lead group, so a campaign can point at only the list you want to contact.

  1. 1

    Upload the CSV

    Import your profile URLs into a lead group so the list stays organized.

  2. 2

    Assign a campaign

    Select the lead group in the campaign settings to start the sequence.

  3. 3

    Set limits and a send window

    Choose daily invite and message limits and a send window in Settings before you start.

Frequently asked questions

Related

Get started with Kinlead

Prefer markdown? How to clean and import LinkedIn lead lists.md