The long version
The menu path, if the link ever moves
- On LinkedIn, click your profile picture (Me) at the top, then Settings & Privacy.
- In the left menu, click Data privacy, then Get a copy of your data.
- Choose Want something in particular?, tick Connections, click Request archive and confirm with your password.
- 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 Name | Last Name | URL | Email Address | Company | Position | Connected On |
|---|---|---|---|---|---|---|
| Claire | Martin | linkedin.com/in/… | Atelier Nord | Architect | 14 Mar 2021 | |
| David | Okafor | linkedin.com/in/… | Self-employed | Accountant | 02 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 Namesits on row 1. - Most emails are empty. The
Email Addresscolumn 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.