Try Reso

Guide · LinkedIn

How to export your LinkedIn connections (and actually use them)

3 clicks now, one email later. The button below takes you straight to the right LinkedIn page. No menus to hunt for.

Open LinkedIn's export page Opens in a new tab. Keep this one open: what to tick is right below.

Here's exactly what you'll see

0 of 3 done
  1. 01On the page you just opened

    Tick Connections. Only that.

    Pick Want something in particular?, then tick Connections. Leave everything else empty: that's what makes the file arrive in minutes instead of a day.

  2. 02Same page, just below

    Click Request archive.

    LinkedIn asks for your password, then says it will email you. You're done with LinkedIn for now. Close the tab and go back to your day.

  3. 03When the email arrives

    Download, open the zip, keep Connections.csv.

    Click the link in the email, then Download archive. You don't need to open the file. The next step does it for you.

That's the export done. Now drop the file below and see who you know.

The step people never get to

Drop the file in Reso. See who you know, by job.

Your connections laid out by job, by sector and by circle around you. The day you need an accountant, an architect or a client in a given industry, one search shows who you already know.

Drop my Connections.csv No account. Your file is read on your device, nothing is uploaded.

The long version

The menu path, if the link ever moves

  1. On LinkedIn, click your profile picture (Me) at the top, then Settings & Privacy.
  2. In the left menu, click Data privacy, then Get a copy of your data.
  3. Choose Want something in particular?, tick Connections, click Request archive and confirm with your password.
  4. When the email arrives, come back to the same page and click Download archive.

The same path exists in the LinkedIn mobile app. Downloading and unzipping the file is simply easier on a computer.

What's inside Connections.csv

One row per connection, with these columns:

Notes: When exporting your connection data, you may notice that some of the email addresses are missing...
First NameLast NameURLEmail AddressCompanyPositionConnected On
ClaireMartinlinkedin.com/in/…Atelier NordArchitect14 Mar 2021
DavidOkaforlinkedin.com/in/…Self-employedAccountant02 Nov 2019

If you open it in Excel or Google Sheets anyway

  • Notes above the headers. The file usually starts with a few lines of notes, then the real column names. Delete those first lines so First Name sits on row 1.
  • Most emails are empty. The Email Address column is only filled when a connection allowed it in their own settings. That's not a bug.
  • Strange symbols instead of accents. Don't double-click the file. In Excel, use Data › From Text/CSV and pick UTF-8. In Google Sheets, use File › Import.

The real problem: a file you never open again

A spreadsheet of 400, 800, 2,000 names, sorted alphabetically, answers "who am I connected to?". Nobody asks that. The question you actually ask, usually on a slow week, is: who do I already know who could help me right now?

  • Group by company and position, not by name. Ten people at the same firm is a door, not ten rows.
  • Use "Connected On" as a reminder. People you connected with two or three years ago knew you well once and have probably not heard from you since.
  • Write a real message. Not an offer. A question about what they're working on, or a reason you thought of them.

Questions

How long does LinkedIn take to send the file?

LinkedIn says up to 24 hours. If you only tick Connections, it is usually much faster, often a matter of minutes. You'll get an email either way.

Why are the email addresses missing?

Each person decides whether their email is shared with their connections. Most leave it off, so most of the column is empty. LinkedIn does not let you export emails people have not shared.

How do I export LinkedIn connections to Excel?

There is no direct Excel export. Download the CSV as above, then open it in Excel with Data, From Text/CSV, UTF-8. Delete the note lines at the top so the headers sit on row 1, and save as .xlsx if you want.

Does this tell the people I'm connected with?

No. Downloading your own data is private. Nobody is notified.