# 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.
- HTML: https://getkinlead.com/cleaning-linkedin-lead-lists-via-csv
- Markdown: https://getkinlead.com/cleaning-linkedin-lead-lists-via-csv.md

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

| | What the importer asks for | Columns to keep | Columns to delete |
| --- | --- | --- | --- |
| Profile URLs only | URL column | Names, companies, notes, emails |
| URL plus name | URL and name columns | Notes, emails, old owner fields |
| URL plus company | URL and company columns | 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.

| | Error message | Common cause | Fix |
| --- | --- | --- | --- |
| Invalid URL | Shortened links or redirects | Expand the URL to the full version |
| Limit reached | File is larger than the importer accepts | Split the CSV into smaller batches |
| Wrong format | Uploaded .xlsx instead of .csv | Re-export as Comma Separated Values |
| Duplicate lead | Same profile appears twice | 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](/features/lead-groups-and-scoring), 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.

## Related

- [CSV import workflow](https://getkinlead.com/ai-sdr-csv-import-workflow.md)
- [Lead groups and scoring](https://getkinlead.com/features/lead-groups-and-scoring.md)
- [LinkedIn account safety](https://getkinlead.com/features/linkedin-account-safety.md)

## Common questions

**Can I import leads without their full URL?**

No. Most automation tools need the full profile URL to locate the person. If you only have names, open each profile and copy the address, or use a lead finder to build the list first.

**Do I need Sales Navigator to import lists?**

No. A valid public LinkedIn profile URL is enough for most importers. Sales Navigator helps with search, but it is not required to upload a CSV.

**What happens if I import a company page by mistake?**

The importer will usually flag the row as invalid or skip it. Company pages cannot receive connection requests or personal messages, so remove those rows before you upload.

**Should I include trailing slashes?**

Most tools ignore a trailing slash, but pick one format and use it for every row. Mixed formats make duplicate checks less reliable.

[Create a Kinlead account](https://getkinlead.com/signup) or [book a call](https://getkinlead.com/demo) to talk through pricing and setup.
