I was recently asked how to download email addresses to an Excel file from a client’s connections on LinkedIn.
This is a handy way to get all the email addresses and phone numbers of people you want to get in touch with on LinkedIn (other than looking at their profile of course). The resulting Excel file will contain all of the contact information your LinkedIn connection has on their profile including email address, phone number, title, address, etc. You can also find these instructions on LinkedIn. Without further ado, here are the steps :
Step One
Log into your LinkedIn profile
Step Two
Click Contacts from the toolbar at the top of the screen. Select Connections from the drop-down box.
Step Three
Scroll to the bottom of the next screen and click Export Connections.
Step Four
Ensure that Micrsosoft Outlook (.CSV file) is selected as the option to export to. Click Export.
Step Five
Locate the exported file in your downloads file (this is the procedure on a PC – it may be different on a Mac) and open it.
Step Six
Save the file as an Excel File and rename it according to your saving protocol. Close the current document and open the Excel file you just created.
You will now have a file with all your LinkedIn connections and their contact information including email, phone number, address, title, etc. There is a lot of information in this file and you probably won’t need it all. You might also be interested in how to integrate LinkedIn with Microsoft Office. This is a neat way of seeing which of your Outlook contacts have LinkedIn profiles so you can grow your LinkedIn network.
If you have any questions on how to do this, or any other technical questions relating to LinkedIn, Facebook or Twitter please email me at samanthataracollier@gmail.com and I’ll be happy to help.
Thank you,
Samantha Collier
Social Media Strategist
www.SocialMediaforLawFirms.com
