LinkedIn Connections.csv to email list: clean your export in seconds
To turn LinkedIn connections into an email list, request your data archive from LinkedIn's Data privacy settings, unzip it and upload Connections.csv here. The tool skips the notes LinkedIn puts above the header, keeps the connections that shared an email, removes duplicates and marks each address as work or personal. Most connections won't have an email.
Sample result
jane.doe@acme.example is a work address from your connections export.
- With an email
- jane.doe@acme.example
- Company
- Example Ltd
- Notes skipped
- 3 lines
What this means for you
Only connections who shared an email appear, with work and personal addresses split.
- Reads Connections.csv as it is exported
- Skips the notes above the header row
- Keeps connections that shared an email
- Splits work from personal addresses
- Connections
- Export
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I turn LinkedIn connections into an email list?
- On LinkedIn, open Me, then Settings & Privacy, Data privacy, Get a copy of your data. Choose the larger archive, which includes connections, and request it.
- When LinkedIn's email arrives, download and unzip the archive and find Connections.csv.
- Upload Connections.csv here (or paste it) and press Build email list. Tick Keep work addresses only if you want to drop personal mailboxes.
- Download the clean CSV with email, first_name, last_name, company, position, linkedin_url and connected_on columns, ready for a CRM or email tool.
Example
- You enter
- The Connections.csv file from a LinkedIn data export, including the notes lines above its header row.
- You get
- Only connections who shared an email are kept, such as
jane.doe@acme.exampleat Example Ltd, labelled as a work address; the 3 note lines above the header are skipped. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
How do I export my LinkedIn connections to CSV?
From LinkedIn's settings: Me, Settings & Privacy, Data privacy, then Get a copy of your data. LinkedIn's help article on exporting connections says to pick the larger data archive, which includes connections, and request it; a download link arrives by email at your primary address. The archive is a zip file, and the list is the Connections.csv inside it.
Only 1st-degree connections are included, and LinkedIn notes the CSV doesn't support every character set, so names in some scripts may come out garbled.
Why are email addresses missing from my LinkedIn export?
Because LinkedIn only exports an email for connections who allow their connections to see or download it. That is LinkedIn's own explanation in the same help article, and it is a privacy setting each member controls. Expect most rows to have a blank Email Address column; this tool tells you exactly how many shared one.
The addresses that are there are the ones members signed up with, often a personal Gmail or Outlook account from years ago rather than their current work address. The tool labels each as work or personal using our list of free email providers, so you can keep only work addresses for B2B outreach.
Can I export LinkedIn connections to Excel?
Yes. Connections.csv opens in Excel or Google Sheets, but the first rows are LinkedIn's notes, not data, so sorting and imports go wrong until you delete them by hand. The cleaned file this tool downloads starts with a normal header row and opens straight into Excel, Sheets, HubSpot or Mailchimp.
If you'd rather stay in a spreadsheet, delete the rows above First Name, then filter the Email Address column to non-blanks.
Can I email my LinkedIn connections?
You can contact people you know, but an export isn't consent to add them to a marketing list. Laws such as CAN-SPAM in the US, PECR in the UK and GDPR in the EU set the rules for commercial email; the GDPR and B2B cold email and CAN-SPAM guides cover what they require. A personal note to a few connections is very different from a bulk campaign.
Before any send, check the addresses still work. People change jobs, and a list built from old sign-up addresses bounces more than one you collected recently; see why cold emails bounce.
Is this faster than cleaning Connections.csv in Excel?
| This tool | Excel or Sheets | |
|---|---|---|
| LinkedIn's notes above the header | Skipped automatically | Delete rows by hand |
| Rows without an email | Removed, count shown | Filter to non-blank |
| Duplicates | Removed | Remove duplicates step |
| Work vs personal address | Labelled per row | Needs a list of free domains |
In Google Sheets, with the header in row 1: =FILTER(A2:G, D2:D<>"") keeps rows that have an email in column D.
Who uses this tool, and for what?
- Founders
- Find which of your connections shared an email before you announce a launch to people who know you.
- Recruiters
- Pull the connections with work addresses into an ATS or CRM, with company and position kept.
- Sales reps
- Move your own network into a CRM when you change jobs, marked work or personal, instead of retyping it.
- Job seekers
- Back up your network as a clean CSV you can sort by company and connection date.
What can’t this tool tell you?
- It can only keep emails LinkedIn exported, which is usually a minority of connections.
- LinkedIn never updates exported emails, so many are old personal addresses; the tool can't tell whether a mailbox still exists.
- Work or personal is decided by the domain alone, from our list of free and ISP mail providers.
- It reads Connections.csv, not the whole zip; unzip the archive first.
- Having someone's email from LinkedIn doesn't make it lawful to add them to marketing email.
Common questions
- How do I get my LinkedIn Connections.csv?
- Go to Settings & Privacy, Data privacy, Get a copy of your data, and request the archive that includes connections. LinkedIn emails a download link; Connections.csv is inside the zip.
- How do I download my LinkedIn connections to CSV?
- Request your data archive from LinkedIn's Data privacy settings. The download is a zip file, and your connections are in Connections.csv, one row per 1st-degree connection.
- Can I download a list of my LinkedIn connections?
- Yes, your 1st-degree connections, through LinkedIn's Get a copy of your data. You can't export people who aren't 1st-degree connections.
- Can I export LinkedIn connections to Excel?
- Yes. Open Connections.csv in Excel, but delete LinkedIn's notes above the header row first, or run it through this tool to get a clean file.
- Can LinkedIn connections see my email?
- Only if you allow it. A LinkedIn privacy setting controls whether connections can see or download your email address, and the export includes it only when you do.
- Can I send a message to all my LinkedIn connections?
- LinkedIn has no send-to-all button. Emailing an exported list is possible for the connections who shared an address, but email marketing laws still apply.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? $9 one-time covers 2,500 emails, no subscription
One plan, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.