{"id":8015,"date":"2015-01-12T16:24:00","date_gmt":"2015-01-12T16:24:00","guid":{"rendered":"https:\/\/www.heartinternet.uk\/blog\/?p=8015"},"modified":"2015-01-12T16:24:00","modified_gmt":"2015-01-12T16:24:00","slug":"excel-for-seo-how-to-conduct-a-backlink-audit","status":"publish","type":"post","link":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/","title":{"rendered":"Excel for SEO: How to conduct a backlink audit"},"content":{"rendered":"<p>In light of the latest Google updates, more webmasters are getting penalised for having dodgy links. If you own a site, you need to conduct a backlink audit in order to assess the risk your website might be under, even if you\u2019ve not been penalised by the search engine giant.<\/p>\n<p>So, conducting a backlink audit is not important just for SEOs but for anyone who owns a website as it gives you the chance to take a closer look at the quality of your links.<\/p>\n<p>To make the auditing process easier, Excel is an invaluable tool. If you have thousands of links to analyse, Excel makes it simpler to go through all of them and remove those bad links that might be harming your site.<\/p>\n<p>This guide will teach you how to gather, sort and clean up your list of links in just a few steps.<\/p>\n<p>Let\u2019s get started.<\/p>\n<hr \/>\n<h3>Get the data<\/h3>\n<p>Whatever backlink checker tool you\u2019re using, export the data in any Excel compatible format available.<\/p>\n<p>You may need to use more than one tool to ensure you get all the links. I usually use Webmaster Tools (WMT) (both the All Domains and Latest links options), Ahrefs, Moz&#8217;s Open Site Explorer and MajesticSEO to get all the links. Why all of these tools? Because each one has its own crawlers which means there\u2019s a good chance one tool will get backlinks that another didn\u2019t.<\/p>\n<p>Even if Google shows you the links in WMT, those are not all the links that Google knows about in relation to your site, so make sure you use other tools as well to ensure you find as many links as possible.<\/p>\n<p>Next, gather all the links in one sheet. Different tools will come back with different data. Make sure all the exports from each tool have the backlink page in the first column. Rearrange columns as needed to ensure when you combine the reports, the information is in a format that makes sense.<\/p>\n<p>Here\u2019s a tip: When you\u2019re working with long lists and lots of columns, it\u2019s always helpful to keep the header of the list in place when you scroll down to see what each column represents.<\/p>\n<p>To do this, simply go to <em>View &gt; Freeze Panes<\/em> and select if you want to freeze the header or the first column. Watch the video below to see how:<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/c-v0PsFbeQo\" width=\"420\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>So now you have a full list of links \u2013 what next?<\/p>\n<hr \/>\n<h3>Step 1: Clean up the data<\/h3>\n<p>The chances are that the backlink checker tools you\u2019ve used have returned some links that are duplicated across all one or several tools. So now you need to remove these duplicate links.<\/p>\n<p>Excel has a built-in function called Remove Duplicates. To locate it, go to <em>Data &gt; Remove Duplicates<\/em>.<\/p>\n<p>This video shows you how to use this function in Excel:<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/4ZCupY5XTOo\" width=\"420\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Make sure you select your entire table before removing duplicates. Then, when asked\u00a0 which columns you want to delete duplicate values from, only select the column that you want to de-dupe. Doing this will ensure you don&#8217;t remove rows which include different URLs but have duplicate values in other columns.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/excel-for-seo-part-2.jpg\" alt=\"\" \/><\/p>\n<p><strong>Extract all URLs from your list of linked keywords<\/strong><\/p>\n<p>Next, you will need to extract all URLs from your list of linked keywords. Some tools will give you the anchor text as a hyperlink so to extract those links:<\/p>\n<p>1. Open Visual Basic Editor (use ALT + F11 shortcut);<br \/>\n2. Navigate Insert -&gt; Module to adds a module<br \/>\n3. Paste the code below<\/p>\n<pre>Sub ExtractHL()\nDim HL As Hyperlink\nFor Each HL In ActiveSheet.Hyperlinks\nHL.Range.Offset(0, 1).Value = HL.Address\nNext\nEnd Sub<\/pre>\n<p>4. Navigate Run &gt; Run Sub\/UserForm (or hit F5)<br \/>\n5. Close the Visual Basic Editor (use ALT + Q)<\/p>\n<p>When you return to your sheet you will see that the links have been pulled from the anchor texts.<\/p>\n<p>Watch the video to see this in action:<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/YmwzWNPipMQ\" width=\"420\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Here\u2019s a tip: When you extract the links, it will always pull the links to the next column on the right. Make sure you leave that column empty so you don\u2019t overwrite your data.<\/p>\n<p>You need to create this module every time you want to apply it. If you want a more permanent solution you will need to <a href=\"https:\/\/blog.udemy.com\/excel-macros-tutorial\/\" target=\"_blank\">create a macro<\/a>.<\/p>\n<p><strong>Show just one URL per domain<\/strong><\/p>\n<p>Not all exports will show you the main domain that links to you. Some will just give you the page.<\/p>\n<p>To extract the domain only from any URL you can use another Add-In called <a href=\"https:\/\/connect.icrossing.co.uk\/url-tools-addin-excel_5458\" target=\"_blank\">URL Tools Excel<\/a>. Download it and follow the instructions provided on that page.<\/p>\n<p>Once installed you will get access to new functions such as:<\/p>\n<ul>\n<li><strong>subdomain()<\/strong> \u2013 This returns the domain part of a URL including any subdomains e.g \u2018https:\/\/www.example.com\/index.htm\u2019 becomes \u2018www.example.com\u2019.<\/li>\n<li><strong>nowww()<\/strong> \u2013 This removes \u2018www.\u2019 from the URL (note that www must be at the very beginning of the URL).<\/li>\n<li><strong>wwwsubdomain()<\/strong> \u2013 This is a combination of the above functions, equivalent to \u2018nowww(subdomain(A1))\u2019. This is what you\u2019ll want to use most of the time so make sure you memorise it.<\/li>\n<li><strong>urlencode()<\/strong> \u2013 This converts a string so that it can be used on a URL query string. It replaces characters that are illegal in URLs, such as blank spaces, with the code that represent those characters as defined in RFC 3986, Uniform Resource Identifier (URI): Generic Syntax. For example, blank spaces are replaced with %20, and exclamation points are replaced with %21.<\/li>\n<li><strong>urldecode()<\/strong> \u2013 Un-encodes a URL string. Try it on a string like \u2018Hello%20World%21\u2019 and you will see that it replaces %20 with a blank space and %21 with an exclamation point.<\/li>\n<li><strong>tld()<\/strong> \u2013 Returns the TLD of a URL. For example, you can choose to retrieve only links with a .co.uk extension.<\/li>\n<li><strong>geturl()<\/strong> \u2013 Extracts the URL from a Hyperlink. For example, from a hyperlink like https:\/\/www.allrecipes.com\/\/Recipes\/desserts\/cookies\/Main.aspx it will extract the actual link which is allrecipes.com.<\/li>\n<\/ul>\n<p>As you can see, geturl() does the same thing as the module we\u2019ve created above. So if you use the add-in you won\u2019t need to create the module every time you want to extract the URL from a hyperlink.<\/p>\n<p>Now on to step two.<\/p>\n<hr \/>\n<h3><span style=\"line-height: 1.6em;\">Step 2: Sort by anchor texts<\/span><\/h3>\n<p>To exclude good backlinks, sort your list by anchor texts. This allows you to see more clearly how many pages are linking to the same anchor or if links are targeting money keywords.<\/p>\n<p>Remove all the links that use a branded anchor or a natural sounding one so you\u2019ll have a shorter list to work with.<\/p>\n<hr \/>\n<h3>Step 3: Get the status of the pages that link to you<\/h3>\n<p>Not every tool will scan your links on the spot and some pages that have linked to you in the past might not even be there anymore. If you want to see their header status, you can use an Excel Add-in called <a href=\"https:\/\/nielsbosma.se\/projects\/seotools\/download\/\" target=\"_blank\">SEO Tools for Excel<\/a>.<\/p>\n<p>Follow the installation steps from the download page and when you\u2019re done you\u2019ll notice a new tab has appeared in your Excel:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/excel-for-seo-part-2-2.jpg\" alt=\"\" \/><\/p>\n<p>You can use all the functions by either writing them yourself or by selecting them from the menu.<\/p>\n<p>Watch this video to see how to use this function:<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/nZlBgVEqRg0\" width=\"420\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Be aware that your Excel might freeze when you\u2019re trying to check the status of a long list of URLs. So, to be safe I recommend applying a formula for batches of pages. I usually do it for 50 pages at a time or my entire work sheet and leave Excel open to work throughout the night.<\/p>\n<p>Now you\u2019ll be able to remove websites from your list that return a 4XX or 5XX status. You will also see which websites have been redirected (3XX) and where, and then check if the new site still has links.<\/p>\n<p>Here\u2019s a tip: Having a large number of formulas in a sheet might slow down Excel so make sure you always copy your cells that have formulas and paste them as values. Watch the video to learn how to do this:<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/a4bzbmDHuvs\" width=\"420\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<hr \/>\n<h3>Step 4: Is my URL still on the page?<\/h3>\n<p>Some of the pages that returned a 200 OK status might have been cleaned up since the backlink checker tool found it. Instead of going through all the links, you can trim down some of them by searching for your URL in the code of the page. You don\u2019t even need to leave your Excel sheet!<\/p>\n<p>To do that, you will need to use the <em>isfoundonpage<\/em> function that comes with SEO Tools for Excel.<\/p>\n<ul>\n<li>You need to have all the pages you want to search in in one column. (column A)<\/li>\n<li>You also need to have the URL you\u2019re looking for in another column. (column B)<\/li>\n<li>Then in column C you add the formula =isfoundonpage(A,B) \u00e0 On Page A is text B found?<\/li>\n<\/ul>\n<p>Watch the video to see how it\u2019s done:<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/pQqHeexlSR8\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>In this video, I\u2019ve searched for:<\/p>\n<ul>\n<li><strong>Twitter.com<\/strong> \u2013 It has been found 11 times as each post has a Twitter link and there are also social buttons in the footer of the website.<\/li>\n<li><span style=\"line-height: 1.6em;\"><strong>Plus.google.com<\/strong> \u2013 It only shows once in the footer.<\/span><\/li>\n<li><strong>Heartinternet.uk<\/strong> \u2013 This URL is present 126 times as I\u2019m searching the Heart website and there are links to various pages and they all include \u201cheartinternet.uk\u201d<\/li>\n<li><strong>Google.de<\/strong> \u2013 Comes back as 0 since there aren\u2019t any mentions of this domain.<\/li>\n<\/ul>\n<p>You can also use the same formula to find keywords on a page without having to actually go on that page.<\/p>\n<p>I also like to use it when checking my own websites for things like code snippets (canonical tags, hreflangs).<\/p>\n<hr \/>\n<h3>Your turn now<\/h3>\n<p>I hope you get a chance to play with Excel and see how efficient it is when conducting your backlink audit. If you\u2019ve already used Excel for this purpose and have other tips you\u2019d like to share, leave them in a comment below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In light of the latest Google updates, more webmasters are getting penalised for having dodgy links. If you own a site, you need to conduct a backlink audit in order to assess the risk your website might be under, even if you&rsquo;ve not been penalised by the search engine giant. This guide will teach you how to gather, sort and clean up your list of links in just a few steps.<\/p>\n","protected":false},"author":2,"featured_media":998,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":{"0":"post-8015","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-search-engine-tips"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel for SEO: How to conduct a backlink audit - Heart Internet<\/title>\n<meta name=\"description\" content=\"How to gather, sort, and clean up your list of backlinks in just a few steps.\" \/>\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.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel for SEO: How to conduct a backlink audit - Heart Internet\" \/>\n<meta property=\"og:description\" content=\"How to gather, sort, and clean up your list of backlinks in just a few steps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/\" \/>\n<meta property=\"og:site_name\" content=\"Heart Internet\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/heartinternet\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-12T16:24:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1620\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Eliot Chambers-Ostler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@heartinternet\" \/>\n<meta name=\"twitter:site\" content=\"@heartinternet\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eliot Chambers-Ostler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/\"},\"author\":{\"name\":\"Eliot Chambers-Ostler\",\"@id\":\"https:\/\/heartblog.victory.digital\/#\/schema\/person\/58ed7f27cc0f3ab6e69135742a5eee28\"},\"headline\":\"Excel for SEO: How to conduct a backlink audit\",\"datePublished\":\"2015-01-12T16:24:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/\"},\"wordCount\":1654,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/heartblog.victory.digital\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg\",\"articleSection\":[\"Search Engine Tips\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/\",\"url\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/\",\"name\":\"Excel for SEO: How to conduct a backlink audit - Heart Internet\",\"isPartOf\":{\"@id\":\"https:\/\/heartblog.victory.digital\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg\",\"datePublished\":\"2015-01-12T16:24:00+00:00\",\"description\":\"How to gather, sort, and clean up your list of backlinks in just a few steps.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage\",\"url\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg\",\"contentUrl\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg\",\"width\":1620,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.heartinternet.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel for SEO: How to conduct a backlink audit\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/heartblog.victory.digital\/#website\",\"url\":\"https:\/\/heartblog.victory.digital\/\",\"name\":\"Heart Internet\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/heartblog.victory.digital\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/heartblog.victory.digital\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/heartblog.victory.digital\/#organization\",\"name\":\"Heart Internet\",\"url\":\"https:\/\/heartblog.victory.digital\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/heartblog.victory.digital\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/02\/HeartInternet_Logo_Colour.webp\",\"contentUrl\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/02\/HeartInternet_Logo_Colour.webp\",\"width\":992,\"height\":252,\"caption\":\"Heart Internet\"},\"image\":{\"@id\":\"https:\/\/heartblog.victory.digital\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/heartinternet\/\",\"https:\/\/x.com\/heartinternet\",\"https:\/\/www.linkedin.com\/company\/heart-internet-ltd\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/heartblog.victory.digital\/#\/schema\/person\/58ed7f27cc0f3ab6e69135742a5eee28\",\"name\":\"Eliot Chambers-Ostler\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/heartblog.victory.digital\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/08\/cropped-Eliot-96x96.jpg\",\"contentUrl\":\"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/08\/cropped-Eliot-96x96.jpg\",\"caption\":\"Eliot Chambers-Ostler\"},\"url\":\"https:\/\/www.heartinternet.uk\/blog\/author\/eliot-chambers-ostler\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel for SEO: How to conduct a backlink audit - Heart Internet","description":"How to gather, sort, and clean up your list of backlinks in just a few steps.","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.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/","og_locale":"en_GB","og_type":"article","og_title":"Excel for SEO: How to conduct a backlink audit - Heart Internet","og_description":"How to gather, sort, and clean up your list of backlinks in just a few steps.","og_url":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/","og_site_name":"Heart Internet","article_publisher":"https:\/\/www.facebook.com\/heartinternet\/","article_published_time":"2015-01-12T16:24:00+00:00","og_image":[{"width":1620,"height":720,"url":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg","type":"image\/jpeg"}],"author":"Eliot Chambers-Ostler","twitter_card":"summary_large_image","twitter_creator":"@heartinternet","twitter_site":"@heartinternet","twitter_misc":{"Written by":"Eliot Chambers-Ostler","Estimated reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#article","isPartOf":{"@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/"},"author":{"name":"Eliot Chambers-Ostler","@id":"https:\/\/heartblog.victory.digital\/#\/schema\/person\/58ed7f27cc0f3ab6e69135742a5eee28"},"headline":"Excel for SEO: How to conduct a backlink audit","datePublished":"2015-01-12T16:24:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/"},"wordCount":1654,"commentCount":1,"publisher":{"@id":"https:\/\/heartblog.victory.digital\/#organization"},"image":{"@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage"},"thumbnailUrl":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg","articleSection":["Search Engine Tips"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/","url":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/","name":"Excel for SEO: How to conduct a backlink audit - Heart Internet","isPartOf":{"@id":"https:\/\/heartblog.victory.digital\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage"},"image":{"@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage"},"thumbnailUrl":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg","datePublished":"2015-01-12T16:24:00+00:00","description":"How to gather, sort, and clean up your list of backlinks in just a few steps.","breadcrumb":{"@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#primaryimage","url":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg","contentUrl":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2015\/04\/seo-tips.jpg","width":1620,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.heartinternet.uk\/blog\/excel-for-seo-how-to-conduct-a-backlink-audit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.heartinternet.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel for SEO: How to conduct a backlink audit"}]},{"@type":"WebSite","@id":"https:\/\/heartblog.victory.digital\/#website","url":"https:\/\/heartblog.victory.digital\/","name":"Heart Internet","description":"","publisher":{"@id":"https:\/\/heartblog.victory.digital\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/heartblog.victory.digital\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/heartblog.victory.digital\/#organization","name":"Heart Internet","url":"https:\/\/heartblog.victory.digital\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/heartblog.victory.digital\/#\/schema\/logo\/image\/","url":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/02\/HeartInternet_Logo_Colour.webp","contentUrl":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/02\/HeartInternet_Logo_Colour.webp","width":992,"height":252,"caption":"Heart Internet"},"image":{"@id":"https:\/\/heartblog.victory.digital\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/heartinternet\/","https:\/\/x.com\/heartinternet","https:\/\/www.linkedin.com\/company\/heart-internet-ltd"]},{"@type":"Person","@id":"https:\/\/heartblog.victory.digital\/#\/schema\/person\/58ed7f27cc0f3ab6e69135742a5eee28","name":"Eliot Chambers-Ostler","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/heartblog.victory.digital\/#\/schema\/person\/image\/","url":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/08\/cropped-Eliot-96x96.jpg","contentUrl":"https:\/\/www.heartinternet.uk\/blog\/wp-content\/uploads\/2025\/08\/cropped-Eliot-96x96.jpg","caption":"Eliot Chambers-Ostler"},"url":"https:\/\/www.heartinternet.uk\/blog\/author\/eliot-chambers-ostler\/"}]}},"_links":{"self":[{"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/posts\/8015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/comments?post=8015"}],"version-history":[{"count":0,"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/posts\/8015\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/media\/998"}],"wp:attachment":[{"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/media?parent=8015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/categories?post=8015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.heartinternet.uk\/blog\/wp-json\/wp\/v2\/tags?post=8015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}