# How to turn a list of URLs into LinkedIn leads
> A step by step guide to cleaning a CSV of LinkedIn profile URLs, importing it into lead groups and writing a first message that gets a reply.
- HTML: https://getkinlead.com/find-leads-via-csv-import
- Markdown: https://getkinlead.com/find-leads-via-csv-import.md

**Short answer:** Put your LinkedIn profile URLs in one column of a CSV, check that each link opens a real profile, then import the file and map that column to the profile field. The URL is what identifies each person, so every other column is optional context.

## What a URL import actually does

Most lead tools treat the LinkedIn profile URL as the primary key. It's the one field that is unique, permanent and easy to check. Names repeat, job titles go stale, and the same company gets written five different ways across a spreadsheet. A profile URL points at exactly one person.

When you upload a CSV of URLs, the tool looks up each profile and pulls back what it can see: name, headline, current company, location. Anything else in your file, like where you met them or who referred them, travels with the lead as a tag or a note. It doesn't identify the person, but it tells you what to say when you write.

That's the whole mechanism. The URL column has to be right. Everything else is context you'll be glad you kept.

| | What's in your file | Needed | Example |
| --- | --- | --- | --- |
| Profile URL | Yes | https://www.linkedin.com/in/sarah-cole-design |
| First name | No | Sarah |
| Company | No | Northwind |
| Where you met | No | Design summit, booth 12 |

## Build the CSV from whatever list you have

You probably already have the list somewhere. Badge scans from a conference, a spreadsheet a partner shared, a column from a CRM export, a notes app full of half finished entries. All of it can become a CSV.

The real work is turning names into profile URLs. There's no shortcut that skips it. Search the name on LinkedIn, add the company as a second filter, open the profile, copy the URL, paste it into the next row. Twenty names takes about fifteen minutes. Two hundred names is a bad afternoon, and a good reason to be picky about who makes the cut.

1. **Put the URL in the first column.** Give the header a plain name like profile_url. One URL per cell, no merged cells, no colour coding that won't survive the export.
2. **Add a source column.** Values like design summit 2025 or referral from Priya. Eight months from now you'll want to know why this person is in your list, and the first message you write will use it.
3. **Fill in names and companies only where you have them.** Leave cells empty rather than guessing. A blank company field is fine. A wrong one sends your follow-up to the wrong place.
4. **Export as CSV from sheets or excel.** File, download, comma separated values. Then open the file once in a plain text editor to confirm you're looking at lines of comma separated text and not one long blob.

## Clean the list before you upload it

Every import failure I've seen comes down to four things: a URL that isn't a URL, a duplicate, a stray space, or a file that only looks like a CSV.

Open the file and scroll through it. You want cells that start with http and contain /in/. If a row says linkedin.com/in/sarah-cole with no protocol, add https:// to the front. If a cell holds two people, split it into two rows.

- Blank rows where someone started typing and stopped.
- URLs with /details/experience or tracking parameters on the end. Cut them back to the /in/name part.
- The same person twice, once from a badge scan and once from a referral.
- Names with leading spaces or stray tabs, which survive the import and show up in your greeting.

> Paste ten random URLs from the file into a browser before you upload. If they don't open a real profile, the import won't find one either.

## CSV import or LinkedIn search, which one

These solve different problems, and you'll use both. Import when you already know who you want. The list came from somewhere real: an event, a partner, a churned customer export, a competitor's comment section you read through by hand.

Search when you can describe a customer but can't name one. Turn on filters for title, headcount, industry and location, then work through the results.

The mistake is using search to rebuild a list you already have. You end up adding a different Sarah Cole from a different Northwind, and you can't tell afterward whether you covered the original forty names.

**Rebuilding a known list in search**

- You spend an hour filtering results for people whose names are already in a spreadsheet
- The match is fuzzy, so the wrong Sarah Cole ends up in the group
- You can't tell which of the forty names you actually covered

**Importing the file you already have**

- Each row either matches a profile or gets flagged for you to fix
- The list you started with and the list you end with are the same length
- The source column survives, so you know these came from the summit

## Map the columns and check the preview

Mapping is the step people click through without reading. It's just matching your headers to the tool's fields, but a wrong mapping drops good leads or puts the company name in the job title field.

Most tools show a preview of five or ten rows before you commit. Read it against your file. If your spreadsheet has the URL in column A and the name in column B, and the preview shows the opposite, back out and remap before anything is sent.

1. **Upload the exported file.** Choose the CSV, not the original spreadsheet. Spreadsheet uploads often get converted on the way in and lose empty cells.
2. **Match the URL column first.** Point profile_url at the LinkedIn profile field. Do this before the others, because some tools guess a mapping and hide the manual option behind it.
3. **Compare the preview to your file.** Open the CSV beside the preview and read line by line. Two minutes here saves a bad campaign later.
4. **Decide what happens to failed rows.** Most tools skip or flag them. Export the failures, fix the URLs, and re-import only those rows.
5. **Name the group after its source.** Design summit 2025 still makes sense next year. March list doesn't.

## Write a first message that says where the name came from

Imported leads are cold in a specific way. You chose them. They didn't choose you, and they have no idea a list exists. A message that pretends you're old acquaintances reads badly and gets ignored.

You do have one advantage over a cold search: you know where the name came from. Say it in the first line, then point at something specific you actually looked at on their profile. That combination gets replies because it answers both questions a stranger has, which are why you're writing and why to them.

- **you:** Hi Sarah, I picked your name up from the design summit attendee list and had a look at the onboarding screens you posted about last month. The plan picker step you showed is the exact thing we get asked about. Worth a short call?
- **them:** Which part of the onboarding work did you mean?
- **draft:** The step where a new user picks a plan. You said the drop off sat between the plan picker and the invite screen. That gap is the piece I'd want to ask you about.

```
Hi {first_name}, I got your name from {source}. I looked at {something specific from their profile} and it's the same problem {proof or example}. Open to 15 minutes this week or next?
```

## Doing this with Kinlead

Kinlead keeps leads in lead groups, and any campaign can point at any group. That's what makes an imported list useful: the summit names go in one group, churned customers in another, and each campaign sends its own message to whichever group it's aimed at. You can import a CSV of LinkedIn profile URLs and export any group back to CSV when you want a backup.

Finding is the other half. Kinlead finds people by describing a customer or by reading who comments on a competitor's posts, scores each lead from 0 to 100 against that profile, and drops the ones below the fit line. [lead groups and scoring](/features/lead-groups-and-scoring) explains what the score is built from.

## Related

- [Lead groups and scoring](https://getkinlead.com/features/lead-groups-and-scoring.md)
- [AI LinkedIn outreach](https://getkinlead.com/features/ai-linkedin-outreach.md)
- [Find leads tool](https://getkinlead.com/tools/find-leads.md)

## Common questions

**Can I import a list of names without profile URLs?**

Not usefully. Names aren't unique on LinkedIn, so a list of names alone matches the wrong person or nothing at all. Find the URL first, even if it means searching twenty names by hand.

**What happens to a profile that has been deleted?**

The row fails and most tools flag it in an error report. Fix or drop it, then re-import just those rows rather than the whole file.

**Do I need Sales Navigator to import a CSV?**

No. Importing URLs is a plain list operation and doesn't depend on any LinkedIn search plan.

**Should I import the whole list at once?**

Start with twenty or thirty and write the first message by hand. If that message gets replies, import the rest and let the campaign run.

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