Our Excel Extension for Google Adwords relies on a framework called ExcelDNA – a .NET Framework runtime that allows developers a great deal of freedom to develop add-ins using either C# or VB.NET. While I was checking out the web site for ExcelDNA I came across an incredible tool called SEOtools created by Neils Bosma.
SEOtools is a must have for Excel enabled SEOs
Here’s a screenshot of Excel extracting the H1 elements found on the URLs listed on the left hand side. That’s an incredibly efficient way to extract your competitors keywords. The platform does a lot – and I’m hopeful it may be extended to provide even more features in the future.
SEOtools functions are highly self explanatory and incredibly reliable – even with a lot of data. Here’s a run through of the best ones (refer to the guide page for the full list.)
=GooglePageRank([URL]) - Retrieves the Google PageRank by URL
=GoogleIndexCount([URL]) - Returns an approximation of the number of pages indexed by Google by domain (the equivalent to “site:yourdomain.com”)
=WhoIs(string domain) - Retrieves WhoIs for a domain
=IsDomainRegistered([DOMAIN]) - Returns “true” if a domain is registered. WhoIs servers are configured in SeoTools.config.xml
=FacebookLikes([URL]) – Retrieves the the number of total Facebook Likes of an url (same count as in a badge)
=AlexaReach([URL]) – Retrieves Alexa Traffic Reach Rank
=ResolveIp([URL]) – Resolves the IP address of the domain in an URL
=HttpStatus([URL]) – Returns the HTTP status code and its description. Also retrieves the Location header (useful for debugging redirects)
=ResponseTime([URL]) – Returns the number of milliseconds it takes for an url to load (cached)
=LinkCount([URL]) – Returns the number of links on a page (cached)
=HtmlTitle([URL]) – Returns the HTML title on a page (cached)
=HtmlMetaDescription([URL]) – Returns the HTML meta description on a page (cached)
=HtmlH1([URL]) – Returns the first HTML H1 element on a page (cached)
=HtmlH2([URL]) – Returns the first HTML H2 element on a page (cached)
=HtmlH3([URL]) – Returns the first HTML H3 element on a page (cached)
=XPathOnUrl([URL]; [XPATH]) – Fetches the url and returns the result from xpath expression (cached).
On XPath – a great little tool to help you construct XPaths for search engine results pages is the brilliant XPathBuilder which has been carefully constructed to help Google Docs hacks users form XPath to extract data from search engines results. You can take the XPath generated by that tool and use it in this query too.
Download this tool now
Download the spreadsheet extension here: http://nielsbosma.se/projects/seotools/ - SEO with Excel got even easier today. Thanks Niels, and if you’re listening, we’d love to see a few things added:
- Tweets to URL
- Facebook Shares
- Google +1′s
- Ranking for keyword in Bing and Google