Home / Guides / How to export LinkedIn connections with emails

Guide

How to export LinkedIn connections with emails

LinkedIn's connections export leaves most emails out and has no phone numbers. Here is how to export them and add business emails and mobile numbers.

The short answer

Two steps. Export your connections from LinkedIn (Settings & Privacy, Data privacy, Get a copy of your data, Download larger data archive; it can take up to 24 hours). Then drop the file into a Claude chat with ProducerSpark connected and ask for the work emails in one sentence. You pay one credit per email found and nothing for a miss, and the list downloads as Excel.

Video: emails and mobile numbers for LinkedIn connections in Claude

Upload your LinkedIn connections export to a Claude chat with ProducerSpark connected and ask for work emails in one sentence. Ask for mobile numbers in a second sentence. Download the list as an Excel file. Emails and LinkedIn messages to these people go out from your own mailbox and LinkedIn account.

Get Emails AND Mobile Numbers for Your LinkedIn Connections (Claude + Excel). Watch on YouTube or see every video on the ProducerSpark channel.

The result

17 of 21
VPs, founders and C-level people came back with a work email
12 of 19
came back with a mobile number
4
of those numbers are on the Do Not Call list, marked beside the number

From 50 of the presenter's own LinkedIn connections, recorded November 2026. Your numbers depend on who you are connected to.

Prompts used in the video

ClaudeThis is my LinkedIn connections export. Find work emails for the VPs, founders and C-level people in it.
ClaudeNow find their mobile numbers too.

In the video

  1. 0:00 LinkedIn's export has no emails or phone numbers
  2. 0:26 Step 1: Export your LinkedIn connections
  3. 0:51 Step 2: Sign up at producerspark.com and connect Claude
  4. 1:19 Step 3: Upload the file and ask Claude for emails
  5. 1:48 The result: 17 of 21 with a work email
  6. 2:08 Step 4: Get their mobile numbers (with Do Not Call flags)
  7. 2:31 Step 5: Download Excel
  8. 2:50 Your whole network in the ProducerSpark app
  9. 3:18 Pricing and where to start
Read the full transcript

LinkedIn lets you export every connection you have. I just did it. 15,494 people. Names, companies, titles, profile links. But only 470 of them came with an email. That's 3%. And not one came with a phone number. In the next few minutes, I'll show you how to get their emails and their mobile numbers using Claude, and download it all as an Excel file.

Step one. Export your connections. On LinkedIn, go to Settings, then Data privacy, then Get a copy of your data. Pick the larger data archive, because that's the one with your connections in it, and click Request archive. LinkedIn says it can take up to 24 hours. When it arrives, unzip it and find the file called Connections.csv. Don't clean it up. You'll upload it exactly as it is.

Step two. Connect Claude. Go to producerspark.com. Get meetings with important people, using Claude. That's exactly what we're doing here. Click Start for free, and sign up with Google or Microsoft. It's one click. Then click Connect Claude at the top, and Add to Claude. Claude opens with ProducerSpark already filled in. Click Continue, then Connect Claude, and you're done. New accounts get 100 free credits.

Step three. Start a new chat. I'm using Fable 5.2, Claude's most capable model. For this video, I'm using 50 of my connections. Drag in the file, and ask for what you want. I asked for work emails for the VPs, founders and C-level people in it.

Claude reads the file, picks out the 21 people who match, and hands them to ProducerSpark. The people show up as they're found. The whole thing took about a minute.

And here's the result. 17 of the 21 now have an email. It's honest about the rest. One is a personal Gmail address, so it's flagged as not confirmed. Four had no business email on record, and it says so instead of guessing. You only pay a credit when an email is found.

Want to call them too? Just ask. I typed, now find their mobile numbers too. Claude checks with you before it spends anything. Each mobile number found costs 8 credits, and if none is found, it's free. 12 of the 19 came back with a mobile number. And every number shows whether it's on the Do Not Call list, so you know who you can call.

Step five. Get the spreadsheet. At the bottom of Claude's reply, click Open this search in ProducerSpark. Every person is there, and one click on Download Excel gives you the file. You can also look up mobile numbers right here, with one button. Then drop the file into your CRM.

Claude is perfect for a hit list. For your whole network, use the ProducerSpark app. Go to Contacts, click Attach file, and pick the same LinkedIn export. Leave Find business emails switched on, and click Add contacts. It tells you what it will cost before it spends anything. My 50 connections started with 2 emails. A minute later, 31 of them had one. Same account, same credits, and every search has a Download Excel button.

Go to producerspark.com, and click Start for free. You get 100 credits. One credit per email, 8 per mobile number, and nothing for a miss. Export your connections tonight, and get their emails and mobile numbers tomorrow. The link is in the description.

Why the LinkedIn export is missing emails

LinkedIn lets you export your connections at any time, but the file only includes an email address for connections who have allowed their connections to see or download it. Most people have not, so the Email Address column comes back nearly empty. The names, companies, titles and profile URLs are all there.

Step 1: Export your connections from LinkedIn

  1. Click the Me icon at the top of LinkedIn and choose Settings & Privacy.
  2. Click Data privacy, then Get a copy of your data.
  3. Choose Download larger data archive. LinkedIn no longer offers connections on their own: they only come inside the larger archive.
  4. Click Request archive. LinkedIn says it can take up to 24 hours and emails a download link to your primary email address.
  5. Unzip the download and find Connections.csv. Leave it as it is.

Connections.csv has one row per connection: first name, last name, profile URL, email address, company, position and the date you connected. Only 1st-degree connections are included. When we exported 15,494 connections in November 2026, only 470 rows had an email, which is 3%, and none had a phone number.

Step 2: Add the missing emails

The profile URL in each row is what makes the emails findable. Upload Connections.csv to ProducerSpark as it is. You do not need to delete the notes at the top of the file or rename any columns.

  1. Open Contacts and attach the file. Keep Find business emails ticked.
  2. ProducerSpark adds the people and looks up each profile.
  3. The emails fill in beside each person.

A file can hold up to 5,000 people and 5 MB. If you have more connections than that, split the file in two.

Step 3: Know what it costs and what to expect

You pay one credit for each email found and nothing for a miss. You start with 100 free credits and no card, so the first 100 emails cost nothing.

Not every profile has a findable business email. On one list of 594 LinkedIn connections in November 2026, 432 came back with a business email, which is 73%. Your number depends on who you are connected to.

Step 4: Use the list

Download the finished list as an Excel file, or add the people to a campaign. These are people who already accepted your connection, so a short, personal note does better than a pitch. ProducerSpark can send the same message by email and as a LinkedIn message from your own account.

Doing it from Claude

You can also do this in a Claude chat, including mobile numbers. To connect ProducerSpark to Claude:

  1. Go to producerspark.com and click Start for free. Sign up with Google or Microsoft.
  2. Click Connect Claude at the top of the app, then Add to Claude.
  3. Claude opens with ProducerSpark filled in. Click Continue, then Connect Claude.

To add it by hand instead, open Claude's Settings, then Customize, then Connectors.

Then start a new chat, drag in Connections.csv and ask: "This is my LinkedIn connections export. Find work emails for the VPs, founders and C-level people in it." For mobile numbers, ask in the same chat: "Now find their mobile numbers too." Claude shows the cost and waits for your yes. At the bottom of Claude's reply, click Open this search in ProducerSpark and then Download Excel.

If you only need a handful of people, skip the export and paste up to 30 profile URLs into the chat. See LinkedIn URL to email. For your whole network, upload the file in the app as in Step 2, which takes up to 5,000 people at a time.

LinkedIn export steps and the email rule are from LinkedIn Help, "Export connections from LinkedIn", checked November 11, 2026, and from our own export in November 2026.

Related.

Questions.

Why are emails missing from my LinkedIn connections export?

LinkedIn only includes an email for connections who have allowed their connections to see or download it. Most people have not.

How do I export my LinkedIn contacts?

Click Me, Settings & Privacy, Data privacy, Get a copy of your data, choose Download larger data archive and click Request archive. Connections only come inside the larger archive. LinkedIn emails you a download link, which can take up to 24 hours.

Can I export 2nd-degree connections from LinkedIn?

No. LinkedIn's export covers 1st-degree connections only.

How do I get the email addresses of my LinkedIn connections?

Upload the Connections.csv file from your LinkedIn export to ProducerSpark. It looks up each profile URL and adds the business email, one credit per email found.

How many connections can I upload at once?

Up to 5,000 people in one CSV or Excel file of up to 5 MB.

Can I get mobile numbers for my LinkedIn connections?

Yes. In the same Claude chat, type "Now find their mobile numbers too." Claude shows the cost and waits for your yes. In the video, 12 of 19 people came back with a mobile number.

Does it show which numbers are on the Do Not Call list?

Yes. Every mobile number is marked on the Do Not Call list, not on it, or unknown, beside the number and in the Excel download. In the video, 4 of the 12 numbers were on the list.

How much does it cost to get emails and mobile numbers for my LinkedIn connections?

One credit for each email found and 8 credits for each mobile number found. A miss costs nothing. New accounts start with 100 free credits and no card.

Pricing

$99/month per user

Every agent for each user, with their own LinkedIn account, 2 mailboxes and 1,000 Enriched+ credits a month. Extra credits are $15 per 100.
Extra mailboxes are $25 a month each.
Done for you: $399 per producer a month. Like hiring an executive admin for each producer: we run their campaigns, meet monthly on Zoom and support them 24x7. Starts with a call.
Start free with 100 credits, no card required. 14-day free trial on the paid plan.

Launch

Launch your first campaign in 7 minutes.

Start now and your campaign is live at 7 minutes from now, your time.