Thursday, August 20, 2015

How to export your LinkedIn contacts into Microsoft Excel?

You can export all your LinkedIn contacts to a .csv file and import this file into Excel.

Follow these steps:

1. Log in to your LinkedIn homepage and click on the tab 'Connections'.

2. Click on the 'Settings symbol'. Looks like a wheel.


3. Click 'Export LinkedIn Connections' under Advanced Settings in the right column on the page.

4. Choose 'Microsoft Outlook (.CSV file) and click 'Export'.

5. Type the Security Verification and click 'Continue'.

6. Your LinkedIn Connections were successfully exported to a .csv file and saved in the Downloads folder on your computer.

7. Start up Excel and then open the file within Excel by selecting File/Open.

8. Once the file opens, remove all the empty columns,

9. Save the file by selecting File/Save. Select Excel Workbook format, click on 'Save' and your file is ready.

Note that you can't save all of the LinkedIn data, but you will have First Name, Last Name, Email Address, Company and Job Title.