|
|
How do I import a contact list into LinkedIn?I have a spreadsheet of names, addresses, email and phone numbers and would like to invite all of them to join LinkedIn and link to me. Can you tell me how to do this as I haven't been able to figure it out? Thanks, Dave! Do you want the good news or the bad news first? The good news is that you can do this, sort of, but the bad news is that after testing various data formats, I have concluded that there's still a bit of manual data entry required. The first step is the easiest: go into Excel or whatever spreadsheet you're using, select the records you want to export, then choose File --> Save As... and specify the data format CSV (Windows) rather than the default spreadsheet XLS format. Now you should have a data file that contains those records in a file with the suffix "csv". Time to flip to LinkedIn and start the process of importing the new data file. To do this, click on the "Add Connections" button on the top right of the main window, then look for the "Import Contacts" box on the subsequent page: ![]() Click on the link thereon and you'll be brought to the contact import page: ![]() You'll want to click on "Choose File" to select the CSV data file you just created in Excel, then click on "Upload Contacts File". Tip: If you have a contact manager, by the way, click on "Find out more about creating a contacts file" where there are helpful tips on exporting data from various contact management systems, both Mac and Windows. It works a lot better than using Excel. In a second or three, your data file will be uploaded and LinkedIn will parse it and hopefully show you names and addresses, but my experimentation only ever got it to recognize email addresses: ![]() Assuming it's good enough for you to progress (and who knows, maybe you'll have better luck and it'll automatically pick up the name too!) click on "Contacts are Correct -- Complete Upload" and LinkedIn will then instantly check to see which of the uploaded contacts are already part of the LinkedIn network: ![]() You can see that each email address in my list already represents someone hooked into LinkedIn both by the informative message in green and by the fact that each had their "headline" or title/company filled in on the lower list. (in some of these screenshots, needless to say, I've added the grey bar to protect my colleague's privacy). Select those contacts you actually want to invite or click on the "Select all on this page" option in the grey column title row as a shortcut, then click on "Invite" to proceed. If you have more than one page of contacts, step through all the pages until you have your entire set of contacts selected. Now you'll have a chance to fill in any missing data: ![]() Don't click on "Send Invitations" yet, though! You'll also want to scroll down to the invitation box itself and write a custom invitation so that these folk will know who you are, why you're inviting them to join LinkedIn and why it's advantageous for them to link to you. This is a critical step that many people miss with LinkedIn, and it makes a world of difference in your success rate working with LinkedIn. I look at it this way: if you can't even spend the 90 seconds adding something that shows you know who I am and really want to connect to me then I'm darn unlikely to approve our link. Anyway, create a custom invite, then click on "Send Invitations" and you'll get some useful feedback like: ![]() That's all there is to it. Now sit back and wait for them to approve your connection and you'll be in building your network LinkedIn style! Also, if you're new to LinkedIn, you'll find that I have an extensive set of tutorials on how to work with the site. Please see: And if you'd like to consider linking to me, please see my public LinkedIn profile.
More Useful Twitter, LinkedIn and Social Network Help Articles:
✔ How do I search for a job on LinkedIn?
This may be a bit obvious, but I'm looking for work and am unclear how I can use LinkedIn to find positions other...
✔ Add a header graphic to my Twitter profile?I heard from a colleague that Twitter's added profile pictures a la Facebook's timeline photo on the top. Nice, but how do I...
✔ Export LinkedIn Profile as a PDF Resume?I've spent the last year or two updating and adding to my LinkedIn profile and it has a ton of information about me....
✔ How do I block an iPad app from accessing Twitter?My son installed an app on my iPad and now it's posting updates on my Twitter account when he plays. What the deuce?...
✔ Repost a Facebook photo on Instagram?I post a lot of photos on Facebook and sometimes want to share them with my Instagram followers. You can automatically mirror an...
Let's stay in touch!
Sign up for my weekly AskDaveTaylor Newsletter and you'll receive even more tech and gadget help
right to your inbox, along with exclusive news and industry updates. It's good stuff. I promise!
Categorized:
Twitter, LinkedIn and Social Network Help
(Article 6477,
Written by Dave Taylor)
Tagged: contact management, linkedin Previous: What do all the icons on my Motorola RAZR V3c phone mean? Next: How do I create a MySpace Blog? Reader Comments To Date: 5Bill Wyatt said, on April 28, 2009 9:11 AM:
Hi Dave - Also, I kept a header row to identify each column. If you export a few contacts, you'll have a great template to copy your spreadsheet and reverst the process. Bill Scott Faver said, on May 7, 2009 7:02 AM:
Dave, I have a list that I too would like to import. But each time I try to import all I get is the name (first & last) and the company name. The EMail Address and other information is not imported. Suggestions? Thanks, Ankan Pal said, on August 11, 2009 1:06 AM:
It helped me alot. Thank you :) James Crawford said, on February 22, 2012 6:40 AM:
Dave, It looks like LinkedIn might have changed since this post. The post makes sense up until the 'send personalised message' section. Any ideas on how to do this now? Is personalisation a premium feature now? Cheers, James
I do have a comment, now that you mention it!Check This Out Too... |
Recent Entries
Look for Answers
Recommended
All Our Categories
Apple iPad Help
Articles and Reviews Auctions and Online Shopping Blogs and Blogging Building Web Site Traffic Business and Management Computer and Internet Basics d) None of the Above Facebook Help Google Gmail Help Google Plus Help HTML, JavaScript and Web Site Programming Industry News and Trade Shows iPhone and Cell Phone Help iPod, Sony PSP and MP3 Player Help Kindle Fire Help Mac OS X Help Pay Per Click (PPC) Advertising Pinterest Help Search Engine Optimization (SEO) Shell Script Programming Tech Support Video Help The Writing Business Twitter, LinkedIn and Social Network Help Unix and Linux Help Video Game Tips and Help Windows PC Help Find Me on Google+ ADT on G+ |
Thanks for the info...Im trying to import Plaxo into Linked in.