Wednesday, February 3, 2016

Linkedin contacts ----> Excel file

1. Exporting LinkedIn contacts You can export all your LinkedIn contacts to a .cvs file and import this file into Excel. - Step 1: Go to your LinkedIn homepage and click on the tab 'Connections' - Step 2: Click to 'Settings' symbol in the top right corner of the page - Step 3: Click 'Export Linkedin Connections' in the right column on the page - Step 4: Choose 'Microsoft Outlook (.CSV file)' and click 'Export' - Step 5: Save the document 2. Import your exported contacts into a workable Excel file You can't save all of the data of your LinkedIn contacts, but you will have First Name, Last Name, E-mail address, Company & Job title. This is how you do it: - Step 1: Open your saved .cvs file in Excel - Step 2: Go to 'Data' in the tab section and click 'Text to columns' - Step 3: Choose 'Seperated', click next, choose 'Comma', click next, choose 'complete' - Step 4: Clean up the empty columns and you're ready! Now you have a workable file, especialy when you apply filters to it. Now you can import this .cvs or .xls file into your ATS/database and the contacts will be stored into your database.

No comments: