# How to send LinkedIn connection requests from a CSV list
> Import a CSV of LinkedIn profile URLs, clean the list, set a safe sending pace, and write a note that gets a reply. A practical guide for small sales teams.
- HTML: https://getkinlead.com/connecting-with-leads-from-csv-lists
- Markdown: https://getkinlead.com/connecting-with-leads-from-csv-lists.md

**Short answer:** To send LinkedIn connection requests from a CSV list, you need a column of direct profile URLs. You can open each URL by hand, or import the CSV into a tool that sends the requests and follow-ups inside limits you set. The list only works if you clean duplicates and broken links first.

## What the CSV needs before you import it

Your CSV needs one column of direct profile URLs. A row with a name and company but no URL is not a lead you can send to. You will have to find the profile by hand, and that search is where lists fall apart.

Keep the file simple. One header row, no merged cells, no formulas that point to another sheet. Save it as CSV UTF-8 so names with accents do not break. The tool you import into will map columns, so clear headers help.

A list from a webinar or a downloaded community sheet often has links copied from a browser. Those links can include extra tracking parameters. Strip everything after the profile slug if your tool rejects the link. A clean URL is the one thing you cannot fake.

| | Column | What to put in it | Example |
| --- | --- | --- | --- |
| Profile URL | The full link to the person's profile, starting with https://www.linkedin.com/in/ | https://www.linkedin.com/in/jane-doe-123 |
| Full name | Used in the note and for a quick check | Jane Doe |
| Company | Optional context for the message | Acme |
| Role | Optional context for the message | VP of Sales |

## Clean the list so requests do not fail

Broken links and duplicates waste sends. A duplicate means the same person gets two requests, which looks careless. A broken link means the request fails and you may not notice until you check the list again.

Clean the URL column before you upload. The work takes a few minutes and saves you from a half-finished campaign. Keep a copy of the original file so you can compare what changed.

Check for URL shorteners too. A link that starts with a short domain is not a profile URL. Open it once, copy the full LinkedIn profile link, and replace the short version in your sheet.

1. **Remove blank rows.** Filter the URL column for blanks and delete those rows. A request cannot go to a profile that is not there.
2. **Delete duplicate URLs.** Use Remove Duplicates on the URL column. Keep the first row and delete the rest.
3. **Check the link shape.** A direct profile link has /in/ in it. Links to company pages, search results or posts will not work as a person.
4. **Open five links at random.** Click five URLs from different parts of the list. If one is a company page or a dead link, clean the whole column again.

## Send by hand or with a tool

Under about 50 people, sending by hand is fine. You can read the profile, mention a post, and write a note that does not sound like a template. The cost is time. You will spend more time opening tabs than talking to buyers.

Over 50 people, a tool saves you from copy and paste. The trade is that you need to set the goal, tone and limits before anything sends. If you skip that setup, the notes read like a mail merge.

Test with 10 rows before you send the whole list. Read the queued notes, check the timing, and make sure the name and company variables pull from the right columns. A small test catches a bad mapping before it reaches 200 people.

**Manual list**

- Open the CSV
- Copy a URL
- Paste it into a browser
- Click Connect
- Write the note
- Repeat for every row

**Tool-assisted list**

- Upload the CSV
- Map the URL column
- Set the goal and tone
- Set a send window
- Review queued notes
- Send inside your limits

## Set a volume you can keep up with

LinkedIn does not publish a number of invites or messages you can send each day. Anyone who gives you an exact number is guessing. Start with a small number of requests, watch what happens, and add more only when the account is healthy.

Your limit should match your ability to reply. If 20 people accept and you have no time to answer, the extra volume does not help. The send window matters too. A request that lands at 2 a.m. in the lead's time zone is easier to ignore.

A steady pace beats a burst. Send a few requests, answer the replies, then send the next batch. If you go quiet for a week and then send a large batch, the pattern looks less like a person using LinkedIn.

> If LinkedIn shows a warning, stop all requests on that account. Do not test the limit by sending more. Check the account, wait, and start again at a lower number.

## Write the note and the first follow-up

The note has one job: give the person a reason to accept. Keep it under 200 characters if you add a note. Open with the detail that put them on the list, then ask a simple question or say why you want to connect. Do not pitch a meeting in the first line.

The first follow-up after acceptance should not repeat the request. Add context, ask about the thing you mentioned, or share a useful observation. A short question gets more replies than a paragraph about your product.

Do not use the same note for every row. Pick one real detail from the CSV or the profile and use it. If the detail is missing, the note will sound generic even when the name is correct.

- **you:** Hi Sarah, I saw your post about agency operations. I work with a 40-person agency on the same problem and would like to connect.
- **them:** Thanks for reaching out. Happy to connect. What are you working on?
- **you:** The intake side. We are trying to stop leads from sitting in a shared inbox for a day. Is that still a spreadsheet for you, or have you moved it?

```
Connection note:
Hi {{first_name}}, I saw your post about {{topic}}. I work with {{company_type}} on {{problem}} and would like to connect.

Follow-up after they accept:
Thanks for connecting, {{first_name}}. You mentioned {{topic}} in your post. Is {{problem}} still handled by hand, or have you changed it this year?
```

## Handle replies without losing the thread

Replies come in different forms. One person asks a question, another says not now, another sends a referral. If you keep them in a spreadsheet, you will miss the one that matters. Keep one inbox or one view for every reply, and sort by intent.

Write down the next step for each reply. A question needs an answer. A not-now needs a date. A referral needs a new request with the referrer's name in the note. Do not leave a reply sitting because it did not ask for a meeting.

A simple tag saves you from rereading the thread. Use the same tags across the list so you can find the replies that need work today. The tag is for you, not for the lead.

- Interested: answer the question and ask one small next question.
- Not now: ask when to check back and put the date on the list.
- Referral: send a new request that mentions the person who sent you.
- No: remove them and do not send a second request.

## Doing this with Kinlead

Kinlead imports a CSV of LinkedIn profile URLs into a lead group. A campaign can point at that group, and the AI-written note opens with why the person became a lead. The note stays under 200 characters. Messages and follow-ups are written from the campaign goal, tone and an optional sales playbook, which is your own script.

Queued messages can be read and edited on the Actions page before they send. Each LinkedIn account sends at most one action every 5 minutes, inside the daily invite and message limits you set and inside a send window in the lead's time zone. Replies from every campaign land in one inbox, classified by intent, with interested replies first. If you want the list and the campaign in one place, start with [lead groups and scoring](/features/lead-groups-and-scoring).

## Related

- [Lead groups and scoring](https://getkinlead.com/features/lead-groups-and-scoring.md)
- [LinkedIn outreach](https://getkinlead.com/features/ai-linkedin-outreach.md)
- [LinkedIn account safety](https://getkinlead.com/features/linkedin-account-safety.md)

## Common questions

**Do I need Sales Navigator to send requests from a CSV?**

No. A CSV of direct profile URLs does not need a Sales Navigator seat. You need the exact profile link for each person.

**What if a URL in my CSV is a company page?**

The request will not reach a person. Remove company pages and search result links, and keep only links that contain /in/.

**Can I add a note to every request from a list?**

Yes, if the tool or your manual process supports notes. Keep the note under 200 characters and open with the reason that person is on your list.

**How many requests should I send each day?**

LinkedIn does not publish a number you can rely on. Start with a small number, watch for warnings, and add more only when the account is healthy and you can answer replies.

**What should I do when someone says not now?**

Ask when to check back, put the date on the list, and do not send another request in the meantime.

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