{"id":5176,"date":"2016-01-26T14:23:40","date_gmt":"2016-01-26T19:23:40","guid":{"rendered":"http:\/\/www.pcrecruiter.net\/two-minute-tuesday\/whats-a-rollup-2\/"},"modified":"2016-01-26T14:23:40","modified_gmt":"2016-01-26T19:23:40","slug":"csv-linkedin","status":"publish","type":"post","link":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/","title":{"rendered":"Two Minute Tuesday: Import Contacts from LinkedIn"},"content":{"rendered":"

Another\u00a0Two Minute Tuesday<\/a> video is here! This time we’re going to walk through exporting your contacts from LinkedIn as a CSV file and importing them into your PCRecruiter database with the Generic File Mapper\/Importer. This is a great way to load up contacts for a new recruiting desk or when you’re getting started with a fresh database.<\/p>\n

NOTE:<\/strong> This video was made in 2016 and some information may have changed. As of 2020, LinkedIn’s instructions for exporting contacts can be found here.<\/a><\/p>\n

If you have any comments\u00a0or suggestions for something we can explain in about two minutes, send an email to twominutetuesday@mainsequence.net<\/a><\/p>\n

\n

Video Transcript<\/h3>\n

Welcome to this week\u2019s \u201cTwo Minute Tuesday,\u201d Main Sequence\u2019s weekly series of very short videos with tips, tutorials and techniques designed to help you become a more powerful PCRecruiter user in just a couple of minutes.<\/p>\n

In this episode we\u2019re going to walk through importing a list of contacts from LinkedIn, which can be handy when you\u2019re just getting started with PCR or if you add a new recruiter to your office and want to load their connections into the database.<\/p>\n

You can import them one at a time of course, and there are browser plugins that can shortcut the process, but if you want to bring all of your LinkedIn contact data into the system at once, here\u2019s how to do it.
\nUnder \u201cMy Network\u201d on LinkedIn, open \u201cConnections\u201d. Now click this little Settings gear on the right, and under \u2018Advanced Settings\u2019 you\u2019ll find an Export option. The default data format is a text file with comma-separated values, otherwise known as a .CSV, and that\u2019s just what we want. Click export and fill out the Security Verification to start the download.<\/p>\n

The data that\u2019s included in the export will depend on your particular LinkedIn account and connections. I\u2019ve opened my exported data in Excel and deleted all of the empty data columns to save myself some hunting in a later step.<\/p>\n

Now, in PCR, we\u2019ll go to the quick-add icon in the upper right, and choose Name. We want to Import a List.
\nStep one is to create or select a rollup list (see last week\u2019s episode for more on those). I\u2019m going to pick this empty list I made earlier. We can choose from a few pre-loaded data formats, but for this purpose we want the Generic Importer.<\/p>\n

Now we browse for the CSV file. The default settings here are just fine for our purposes. After we click \u2018Next\u2019, we click in these boxes here to choose which column in the CSV should be imported into each PCRecruiter field listed on the left. My data only had names, companies, email addresses, and job titles, so I can leave the rest alone.<\/p>\n

We click \u201cNext\u201d again, and specify how the system should handle any duplicates. I\u2019m going to tell it to update any existing records in the database with the data from the CSV if the Name and Company both match exactly. If there\u2019s no exact match, a fresh record will be made. Any contacts that have no company name at all will be imported into the default candidate pool company.<\/p>\n

When we click \u201cImport\u201d, the system starts creating name and company records as appropriate for everyone in the CSV, and adds all the names to the selected Rollup so they\u2019re easy to start working with.
\nAs a final tip, you might want to consider having a blank database added to your PCRecruiter account for doing big imports like this. That way you can make sure the imported data all looks correct and clean before transferring the records from the empty database into your live one.<\/p>\n

For more Two Minute Tuesdays, subscribe to this YouTube channel and watch our social networks or your PCR login screen. If you have any suggestions for future episodes, send an email to twominutetuesday@mainsequence.net.\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

Another\u00a0Two Minute Tuesday<\/a> video is here! This time we’re going to walk through exporting your contacts from LinkedIn as a CSV file and importing them into your PCRecruiter database with the Generic File Mapper\/Importer. This is a great way to load up contacts for a new recruiting desk or when you’re getting started with a fresh database.<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[33,104,105],"tags":[],"class_list":["post-5176","post","type-post","status-publish","format-video","hentry","category-topics","category-two-minute-tuesday","category-video","post_format-post-format-video"],"acf":[],"yoast_head":"\r\nTwo Minute Tuesday: Import Contacts from LinkedIn - PCRecruiter<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Two Minute Tuesday: Import Contacts from LinkedIn - PCRecruiter\" \/>\r\n<meta property=\"og:description\" content=\"Another\u00a0Two Minute Tuesday video is here! This time we're going to walk through exporting your contacts from LinkedIn as a CSV file and importing them into your PCRecruiter database with the Generic File Mapper\/Importer. This is a great way to load up contacts for a new recruiting desk or when you're getting started with a fresh database.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/\" \/>\r\n<meta property=\"og:site_name\" content=\"PCRecruiter\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/PCRecruiter\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-01-26T19:23:40+00:00\" \/>\r\n<meta name=\"author\" content=\"PCRecruiter\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@PCRecruiter\" \/>\r\n<meta name=\"twitter:site\" content=\"@PCRecruiter\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"PCRecruiter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/\"},\"author\":\"PCRecruiter\",\"headline\":\"Two Minute Tuesday: Import Contacts from LinkedIn\",\"datePublished\":\"2016-01-26T19:23:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/\"},\"wordCount\":674,\"publisher\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#organization\"},\"articleSection\":[\"Topics\",\"Two Minute Tuesday\",\"Video\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/\",\"name\":\"Two Minute Tuesday: Import Contacts from LinkedIn - PCRecruiter\",\"isPartOf\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#website\"},\"datePublished\":\"2016-01-26T19:23:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pcrecruiter.net\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Two Minute Tuesday: Import Contacts from LinkedIn\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#website\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/\",\"name\":\"PCRecruiter\",\"description\":\"PCRM & PCR - Software for Recruiters\",\"publisher\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pcrecruiter.net\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#organization\",\"name\":\"PCRecruiter\",\"alternateName\":\"Main Sequence Technology, Inc.\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png\",\"contentUrl\":\"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png\",\"width\":1200,\"height\":627,\"caption\":\"PCRecruiter\"},\"image\":{\"@id\":\"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/PCRecruiter\",\"https:\/\/x.com\/PCRecruiter\",\"https:\/\/linkedin.com\/company\/PCRecruiter\"]}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Two Minute Tuesday: Import Contacts from LinkedIn - PCRecruiter","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/","og_locale":"en_US","og_type":"article","og_title":"Two Minute Tuesday: Import Contacts from LinkedIn - PCRecruiter","og_description":"Another\u00a0Two Minute Tuesday video is here! This time we're going to walk through exporting your contacts from LinkedIn as a CSV file and importing them into your PCRecruiter database with the Generic File Mapper\/Importer. This is a great way to load up contacts for a new recruiting desk or when you're getting started with a fresh database.","og_url":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/","og_site_name":"PCRecruiter","article_publisher":"https:\/\/facebook.com\/PCRecruiter","article_published_time":"2016-01-26T19:23:40+00:00","author":"PCRecruiter","twitter_card":"summary_large_image","twitter_creator":"@PCRecruiter","twitter_site":"@PCRecruiter","twitter_misc":{"Written by":"PCRecruiter","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/#article","isPartOf":{"@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/"},"author":"PCRecruiter","headline":"Two Minute Tuesday: Import Contacts from LinkedIn","datePublished":"2016-01-26T19:23:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/"},"wordCount":674,"publisher":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#organization"},"articleSection":["Topics","Two Minute Tuesday","Video"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/","url":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/","name":"Two Minute Tuesday: Import Contacts from LinkedIn - PCRecruiter","isPartOf":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#website"},"datePublished":"2016-01-26T19:23:40+00:00","breadcrumb":{"@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pcrecruiter.net\/site\/2016\/01\/26\/csv-linkedin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pcrecruiter.net\/site\/"},{"@type":"ListItem","position":2,"name":"Two Minute Tuesday: Import Contacts from LinkedIn"}]},{"@type":"WebSite","@id":"https:\/\/www.pcrecruiter.net\/site\/#website","url":"https:\/\/www.pcrecruiter.net\/site\/","name":"PCRecruiter","description":"PCRM & PCR - Software for Recruiters","publisher":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pcrecruiter.net\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pcrecruiter.net\/site\/#organization","name":"PCRecruiter","alternateName":"Main Sequence Technology, Inc.","url":"https:\/\/www.pcrecruiter.net\/site\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/","url":"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png","contentUrl":"https:\/\/www.pcrecruiter.net\/site\/wp-content\/uploads\/2020\/08\/PCRecruiter-1200px.png","width":1200,"height":627,"caption":"PCRecruiter"},"image":{"@id":"https:\/\/www.pcrecruiter.net\/site\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/PCRecruiter","https:\/\/x.com\/PCRecruiter","https:\/\/linkedin.com\/company\/PCRecruiter"]}]}},"_links":{"self":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/posts\/5176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/comments?post=5176"}],"version-history":[{"count":0,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/posts\/5176\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/media?parent=5176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/categories?post=5176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pcrecruiter.net\/site\/wp-json\/wp\/v2\/tags?post=5176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}