LinkedIn Tip On Extracting Tagged Lists
If you are like me you might want to organize your network into to do lists, but sometimes LinkedIn is difficult to work with and it is easier to get things in spread sheet form. This tip lets you extract LinkedIn tagged lists and put them into a spreadsheet. However an underlying assumptions here is that you have already been using the tagged feature within LinkedIn for segmenting your LinkedIn database. If you haven’t you need to start and find help at LinkedIn help resource showing how to tag contacts. Tagging lets you not only tag your 1st level contacts, but it also lets you tag 2nd and 3rd level people in LinkedIn for possible follow up later. However I found that after all my work of tagging these extra people there was not an easy way to manipulate the LinkedIn database for further segmentation- at least in the manor you can in a spreadsheet. This was a problem for me so I found this method of extraction, and thought it worthwhile to share.
Steps to getting your tag lists into excel
The process is a bit cumbersome, and is not perfect, but it works reasonable well for moderately sized lists of people that are under a couple of hundred. What is very nice about this process also is that you can use it to export lists of people you tagged but have not yet connected with as a level 1 connection. The regular LinkedIn export only lets you export those people with whom you have a level 1 connection. If you are using advance social media tagging to identify potential prospects for instance- you might want to export some information. This process lets you create a spread sheet, allow you to manipulate your LinkedIn data different than is allowed in LinkedIn.
If for instance you have created a list of network people in LinkedIn that you have tagged. My example uses a “Tip club” tag
Under Connections- drop down the “All Contact” arrow, go to Tag, and then select your particular Tagging that you are interested in- Here I am selecting “Tip Club” contacts.
Start with a reasonable sized tagged list of less than a few hundred
As long as your list is reasonable you put your cursor at the top of the list hold down the left mouse button and slide to the bottom of your list hit Control-C to copy the selection into your paste buffer. Then open up a Word file and paste the results into a blank file.
Some Manual Steps required
The results in Word take some manual effort and here are the issues to deal with.
1) The records are sometimes variable in length depending on which tags you have applied for each person. In my example I have some with 2 tags and some with only 1 tag. We will want to manually go through and make the same number of tags for each person, even if you have to create a blank tag as I will show.
2) Find People with only one tag, put cursor there and hit carriage return. This manually creates a blank paragraph- as a 2nd tag position. Manually go through and verify all people have exactly the same number of tags in your Word file.
3) The extracted data for 2nd and 3rd level contacts is missing a field, so if you don’t see 1st after each person’s name, then one has to follow step 2 and insert a blank after each persons name if they happen not to be a first level connection. This does require an additional manual step. Otherwise the final step to convert text to table will cause the data misalign.
4) Even with these preliminary steps the number of data fields between people records is not always the same. So it may still require you to move cells around once you have the spreadsheet created. However these steps will get most of the data in place. Maybe someone with more spreadsheet experience has a suggestion on how to enhance these steps. I would be glad to hear from others.
Now to create the spreadsheet
In Word select all you text that you pasted into the file. Then go Insert Tab and then Select Tables drop down- in the drop down selection find and select “Convert text to table” option. The dialog box comes up select the number of columns ( 1 tag -8 columns, 2 tags – 9 columns, etc). I also selected Autofit to contents for convenience in sizing the columns. To show the results below- I then added a header to the table below so you can see what fields are being extracted from LinkedIn.
At this point you can move the spreadsheet to excel and use it in whatever manner you see fit.
Author- Mark Colestock
Online Sales and Lead Generation Expert | Analytics | Social Media Sales | Web Search | WSI Digital Marketing