How to export your LinkedIn contacts to Excel?
One of the best features of LinkedIn is how you can create a wide network of professional contacts. These contacts – or “connections” as called on the social media, are often people you know or who share similar interests. But if you use LinkedIn for prospecting, then your contacts might also be potential prospects. In that scenario, you can sometimes ask yourself: how to export LinkedIn contacts to Excel or a spreadsheet?
LinkedIn can be a great source of professional opportunities: finding new jobs, learning new skills, expanding your network and adding contacts, or prospecting are some of the opportunities that LinkedIn offer.
If you are active on LinkedIn, your address book is certainly very large. LinkedIn has actually set a limit to the number of contacts you can have: 30,000, which is a pretty high number. If you want to sort or qualify these contacts correctly, you may need to export the list to process it in Excel. LinkedIn allows you to export your existing contacts in .csv (for Comma Separated Values, a specific file type you can convert with Excel), with their public information: last name, first name, position, email address, etc.
You can also export your LinkedIn contacts onto Excel to import them to other platforms: to Gmail, Hotmail or Outlook, for example, or to marketing software, such as your CRM. You will then be able to transfer the contacts to mailing lists.
Exporting data outside LinkedIn will allow you to retrieve contact information from your network members in an Excel file.
There is a very simple process to export your contacts and their information. Just follow these few steps to get them!
Connect to your account on LinkedIn.
To export your contacts, you will indeed need an active LinkedIn account, and relationships to export. If you don’t have any, or have very few, try to create new contacts. Send them invitations, add contacts suggested by the platform… Create your network!
Click onto the « Me » tab, in the upper-right corner of your screen.
A drop down list of options should appear.
Select « Settings & Privacy »
By clicking on this page, you can access many LinkedIn options. Among them: the possibility to switch to private mode.
Click on the “Data Privacy” tab, then the “How LinkedIn uses your data” part.
You get several options to choose from.
Click on “Get a copy of your data”
You will access a dashboard with a couple of boxes. They allow you to choose the dataset for exporting.
Select the “Want something in particular? Select the data files you’re most interested in.” checkbox then choose “Connections”. Once you have done it, click on “Request Archive”.
Important to note, you can choose to export all data LinkedIn has about you: relationships, articles, imported contacts, messages, invitations, profile, recommendations, and registration can be selected. This will give you a complete record of the personal data you have on LinkedIn.
If you want to export to Excel your complete data, LinkedIn gives you the possibility to do so by checking the option “Download larger data archives”.
After a few minutes, the archive you requested will be available to download from LinkedIn in Excel format.
Before downloading and create a csv file with your contacts, LinkedIn will make sure you are the person requesting it. Typing your password when requested will do so.
Click on « Download archive » to download the .zip file with your list of contacts.
LinkedIn can process the data for a few minutes, so be patient. Check the same tab a bit later if you do not see the option yet: the Export button should appear soon. Once it is there, you just must click the button to download your file.
Be careful: the file that you will download is a .zip file containing your export to csv. You need to extract the contact list from it. Right click your .zip file and select « Extract here » to get the csv file with all your contacts information. You can also use this data export in any other spreadsheet program.
You can also import your LinkedIn contacts in a slightly different manner. To do so, go to the “My Network” tab. This is the tab where you will usually find your new invitations and matchmaking requests. At the top left, in the “Manage my network” section, there is a link, “Connections”, leading to all the contacts in your network.
Click on it to get to a complete list of all your relations. You can select the option “Manage synced and imported contacts”.
An advanced action then allows you to either export contacts or syncing your contacts. By clicking on “Export contacts”, you will be sent to the “How LinkedIn uses your data” tab that we described earlier. Repeat the previous process from step 5, to export your contact data in an Excel file. You will also receive your import file in csv format.
You now have a contact file in good and due form! This list of your contacts can then be worked on, modified, and re-imported into other tools, to meet all your needs. 😜