{"id":728,"date":"2008-08-19T08:03:10","date_gmt":"2008-08-19T15:03:10","guid":{"rendered":"http:\/\/www.pdxtc.com\/wpblog\/?p=728"},"modified":"2014-12-04T13:23:45","modified_gmt":"2014-12-04T20:23:45","slug":"make-my-links-live-in-excel","status":"publish","type":"post","link":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/","title":{"rendered":"Make My Links Live in Excel"},"content":{"rendered":"<p>If you&#8217;ve ever imported large quantities of URLs into a spreadsheet, or even copy\/pasted just a few rows, one of the things that you&#8217;ve probably disliked is the fact that those URLs are not &#8220;live&#8221;.<\/p>\n<p>In fact, in order to actually visit those URLs as needed, you have to copy\/paste each one of them into the browser address bar, which takes extra time.<\/p>\n<p><strong>2011 Update &#8211; Watch this!<\/strong><\/p>\n<div align=\"center\">\n<iframe loading=\"lazy\" title=\"YouTube video player\" width=\"450\" height=\"368\" src=\"http:\/\/www.youtube.com\/embed\/kcrnR33qEiw?rel=0\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<p>You may have engaged in the ridiculous process of double clicking into each cell and then pressing the enter key. This moves your cursor down the spread sheet line after line, making each URL miraculously &#8220;live&#8221;. I&#8217;ve even had my 11 year old son do this for hundreds of rows before.<\/p>\n<p>You would THINK that Microsoft would be &#8220;smart&#8221; enough to make these URLs immediately live upon entry, but sadly; that&#8217;s not the case. Even with http:\/\/ before the URL, Excel simply cannot understand that it should be a link.<\/p>\n<p>A couple of weeks ago, I gave a presentation at the Oregon Computer Consultants Association meeting, where I was reviewing some of the <a href=\"https:\/\/www.pdxtc.com\/wpblog\/microsoft\/things-to-hate-about-office-2007\/\" target=\"_blank\">things I hate about office 2007<\/a>, and the <a href=\"http:\/\/www.occa.org\/sobi2\/ksw-consulting-inc.html\" target=\"_blank\">Excel Queen<\/a> <a href=\"http:\/\/www.linkedin.com\/pub\/4\/643\/216\" target=\"_blank\">Karen Westermann<\/a> seemed to think this would be an easy problem to solve.<\/p>\n<p>Well apparently, it wasn&#8217;t quite as easy as she thought it would be. Since she&#8217;s the Queen though, she did come up with a solution, so here&#8217;s a spreadsheet for this miserable task that I can share with you all.<\/p>\n<p>The <a href=\"http:\/\/www.searchcommander.com\/seo-tools\/make-imported-links-live-in-excel\/\">Make my links live<\/a> tool is available now, complete with directions <a href=\"http:\/\/www.searchcommander.com\/seo-tools\/make-imported-links-live-in-excel\/\" target=\"_blank\">here<\/a>. My son doesn&#8217;t like it though, since he&#8217;s now out of a job&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;ve ever imported large quantities of URLs into a spreadsheet, or even copy\/pasted just a few rows, one of the things that you&#8217;ve probably disliked is the fact that those URLs are not &#8220;live&#8221;. In fact, in order to actually visit those URLs as needed, you have to copy\/paste each one of them into [&hellip;]<\/p>\n","protected":false},"author":76,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[173],"tags":[228,229,231,366],"class_list":["post-728","post","type-post","status-publish","format-standard","hentry","category-tools","tag-excel","tag-hyperlinks","tag-live-links","tag-seo"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Make My Links Live in Excel<\/title>\n<meta name=\"description\" content=\"If you&#039;ve ever imported large quantities of URLs into a spreadsheet, or even copy\/pasted just a few rows, one of the things that you&#039;ve probably disliked\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Make My Links Live in Excel\" \/>\n<meta property=\"og:description\" content=\"If you&#039;ve ever imported large quantities of URLs into a spreadsheet, or even copy\/pasted just a few rows, one of the things that you&#039;ve probably disliked\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Scott Hendison&#039;s Old Search Commander Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SearchCommander\" \/>\n<meta property=\"article:published_time\" content=\"2008-08-19T15:03:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-12-04T20:23:45+00:00\" \/>\n<meta name=\"author\" content=\"Scott\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@shendison\" \/>\n<meta name=\"twitter:site\" content=\"@shendison\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/\"},\"author\":{\"name\":\"Scott\",\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/#\\\/schema\\\/person\\\/3142c7d28dc676725ac62cd6c9de8371\"},\"headline\":\"Make My Links Live in Excel\",\"datePublished\":\"2008-08-19T15:03:10+00:00\",\"dateModified\":\"2014-12-04T20:23:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/\"},\"wordCount\":275,\"commentCount\":13,\"keywords\":[\"Excel\",\"hyperlinks\",\"live links\",\"SEO\"],\"articleSection\":[\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/\",\"name\":\"Make My Links Live in Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/#website\"},\"datePublished\":\"2008-08-19T15:03:10+00:00\",\"dateModified\":\"2014-12-04T20:23:45+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/#\\\/schema\\\/person\\\/3142c7d28dc676725ac62cd6c9de8371\"},\"description\":\"If you've ever imported large quantities of URLs into a spreadsheet, or even copy\\\/pasted just a few rows, one of the things that you've probably disliked\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/tools\\\/make-my-links-live-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Make My Links Live in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/#website\",\"url\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/\",\"name\":\"Scott Hendison&#039;s Old Search Commander Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pdxtc.com\\\/wpblog\\\/#\\\/schema\\\/person\\\/3142c7d28dc676725ac62cd6c9de8371\",\"name\":\"Scott\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba275e23c0aad37526141e715b54cd3eeac27b071e4395b2b39e801ca68355d6?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba275e23c0aad37526141e715b54cd3eeac27b071e4395b2b39e801ca68355d6?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba275e23c0aad37526141e715b54cd3eeac27b071e4395b2b39e801ca68355d6?s=96&r=g\",\"caption\":\"Scott\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/shendison\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Make My Links Live in Excel","description":"If you've ever imported large quantities of URLs into a spreadsheet, or even copy\/pasted just a few rows, one of the things that you've probably disliked","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.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Make My Links Live in Excel","og_description":"If you've ever imported large quantities of URLs into a spreadsheet, or even copy\/pasted just a few rows, one of the things that you've probably disliked","og_url":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/","og_site_name":"Scott Hendison&#039;s Old Search Commander Blog","article_publisher":"https:\/\/www.facebook.com\/SearchCommander","article_published_time":"2008-08-19T15:03:10+00:00","article_modified_time":"2014-12-04T20:23:45+00:00","author":"Scott","twitter_card":"summary_large_image","twitter_creator":"@shendison","twitter_site":"@shendison","twitter_misc":{"Written by":"Scott","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/"},"author":{"name":"Scott","@id":"https:\/\/www.pdxtc.com\/wpblog\/#\/schema\/person\/3142c7d28dc676725ac62cd6c9de8371"},"headline":"Make My Links Live in Excel","datePublished":"2008-08-19T15:03:10+00:00","dateModified":"2014-12-04T20:23:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/"},"wordCount":275,"commentCount":13,"keywords":["Excel","hyperlinks","live links","SEO"],"articleSection":["Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/","url":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/","name":"Make My Links Live in Excel","isPartOf":{"@id":"https:\/\/www.pdxtc.com\/wpblog\/#website"},"datePublished":"2008-08-19T15:03:10+00:00","dateModified":"2014-12-04T20:23:45+00:00","author":{"@id":"https:\/\/www.pdxtc.com\/wpblog\/#\/schema\/person\/3142c7d28dc676725ac62cd6c9de8371"},"description":"If you've ever imported large quantities of URLs into a spreadsheet, or even copy\/pasted just a few rows, one of the things that you've probably disliked","breadcrumb":{"@id":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pdxtc.com\/wpblog\/tools\/make-my-links-live-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pdxtc.com\/wpblog\/"},{"@type":"ListItem","position":2,"name":"Make My Links Live in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.pdxtc.com\/wpblog\/#website","url":"https:\/\/www.pdxtc.com\/wpblog\/","name":"Scott Hendison&#039;s Old Search Commander Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pdxtc.com\/wpblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pdxtc.com\/wpblog\/#\/schema\/person\/3142c7d28dc676725ac62cd6c9de8371","name":"Scott","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ba275e23c0aad37526141e715b54cd3eeac27b071e4395b2b39e801ca68355d6?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ba275e23c0aad37526141e715b54cd3eeac27b071e4395b2b39e801ca68355d6?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ba275e23c0aad37526141e715b54cd3eeac27b071e4395b2b39e801ca68355d6?s=96&r=g","caption":"Scott"},"sameAs":["https:\/\/x.com\/shendison"]}]}},"_links":{"self":[{"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/posts\/728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/users\/76"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/comments?post=728"}],"version-history":[{"count":0,"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/posts\/728\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/media?parent=728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/categories?post=728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pdxtc.com\/wpblog\/wp-json\/wp\/v2\/tags?post=728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}