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 startedShort 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
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
Remove duplicates
In Google Sheets, go to Data, Data cleanup, Remove duplicates. Select only the URL column so every profile appears once.
- 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
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
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
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
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
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
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
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
Upload the CSV
Import your profile URLs into a lead group so the list stays organized.
- 2
Assign a campaign
Select the lead group in the campaign settings to start the sequence.
- 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