Export your LinkedIn contacts to CSV File — Build mailing list

Linked Helper
Linked Helper
Published in
4 min readFeb 14, 2017

This article is for Linked Helper 1.

Linked Helper 1 is outdated and was replaced by Linked Helper 2. You can find it here https://www.linkedhelper.com/

Linked Helper 2 knowledge base is available here https://linkedhelper.zendesk.com/hc/en-us

By Linked Helper you can export your LinkedIn contacts to CSV File. Furthermore, you can build a targeted mailing list.

How to export all your 1st LinkedIn connections to CSV file or MS Excel:

How to export targeted LinkedIn contacts / connections into CSV file or MS Excel:

  1. Go to “Profiles extractor” settings. By default, you will see the list named “ALL”. This list collects queued and extracted profiles from all other lists.

2. Choose “…create new” list, type list name and click “Add” button

3. Go to the search page. Set your search filters. Set Relationship: «1st Connections»; And press “Collect contacts from search”. After this Linked Helper will go through all search results and — pull all contacts in the queue.

4. Open your LinkedIn tab in a separate Chrome window and do not minimize / not collapse it. You can do this by dragging down your LinkedIn tab. You need to do this because LinkedIn doesn’t load a profile page (freezes it) if Linkedin is in an inactive Chrome tab.

5. Go to “Extract” tab and click “Extract collected profiled”. The program will go through queued (collected) profiles and stores them into your browser memory.

My recommendation is to extract 150 profiles per period and set 24 hours between periods. Linked Helper will continue its work automatically in the same tab.

6. Go to “Export” tab and click “Download CSV File”. By default CSV file will be created compatible with Google Sheets, but you can switch to MS Excel format (not recommend for profiles in other languages).

If you collected profiles, which have text in other languages, and you want to export them to Excel, you have two options:

  1. Export to Google Sheet and then to Excel from Google Sheet
  2. Export in MS Excel format and use instruction from this link https://medium.com/linked-helper/how-to-import-csv-file-into-ms-excel-b4aee2f30375#.z8f8r8ybs

or

http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically/6488070#6488070

You will get a file with these fields:

'ID',
'Full name',
'Email',
'Profile url',
'First name',
'Last name',
'Title',
'Avatar',
'Location',
'Address',
'Birthday',
'Summary',
'Twitter',
'Phone 1',
'Phone 1 type',
'Phone 2',
'Phone 3 type',
'Phone 3',
'Phone 3 type',
'Messenger 1',
'Messenger 1 type',
'Messenger 2',
'Messenger 3 type',
'Messenger 3',
'Messenger 3 type',
'Website 1',
'Website 2',
'Website 3',
'Organization 1',
'Organization Title 1',
'Organization Start 1',
'Organization End 1',
'Organization Description 1',
'Organization Location 1',
'Organization 2',
'Organization Title 2',
'Organization Start 2',
'Organization End 2',
'Organization Description 2',
'Organization Location 2',
'Organization 3',
'Organization Title 3',
'Organization Start 3',
'Organization End 3',
'Organization Description 3',
'Organization Location 3',
'Organization 4',
'Organization Title 4',
'Organization Start 4',
'Organization End 4',
'Organization Description 4',
'Organization Location 4',
'Organization 5',
'Organization Title 5',
'Organization Start 5',
'Organization End 5',
'Organization Description 5',
'Organization Location 5',
'Organization 6',
'Organization Title 6',
'Organization Start 6',
'Organization End 6',
'Organization Description 6',
'Organization Location 6',
'Organization 7',
'Organization Title 7',
'Organization Start 7',
'Organization End 7',
'Organization Description 7',
'Organization Location 7',
'Education 1',
'Education Degree 1',
'Education FOS 1',
'Education Grade 1',
'Education Start 1',
'Education End 1',
'Education Description 1',
'Education 2',
'Education Degree 2',
'Education FOS 2',
'Education Grade 2',
'Education Start 2',
'Education End 2',
'Education Description 2',
'Education 3',
'Education Degree 3',
'Education FOS 3',
'Education Grade 3',
'Education Start 3',
'Education End 3',
'Education Description 3',
'Skills',

Download Linked Helper — LinkedIn Automation tool from our website

Write me your questions & ideas : info@linkedhelper.com

Check our web-site : http://linkedhelper.com/

Alex Erin

Read also

1 : Important — Linked Helper Data Storage

2 : Boost your profile and get hundreds of endorsements

3 : How to send your messages to your LinkedIn 1st connections

4 : Sequential messaging

5 : Build mailing list

6 : Auto-Visit Profiles to get Look-Back

7 : Export your LinkedIn contacts to CSV File

8 : How to manage Collected Recipients (Recipients Queue), Processed Recipients and Excluded Contacts for message broadcast to 1st connections

9 : Switch collapse mode to minified

10 : How to manage broadcasts to LinkedIn 1st connections — creating messages chains

11 : Automatically send personalized invitations to targeted 2nd (3rd in case of Sales Navigator) contacts

12 : Collect, Select & Invite 2nd & 3rd connections

13 : Automatically add your signature to new messages

14 : Automatically endorse all your contacts

--

--