Beginners guide to SEOTools for Excel (part 1)

Introduction

Although it is clear that using a software (or “tool”) becomes easier with experience, you still need to learn the basic functionality to start using it. This can be more or less hard based on the complexity of the tool itself and how easy it is to get access to good training materials.

What is SeoTools for Excel

Most online marketers and growth hackers have data stored across separate products, tools and services. Some example are web analytics-data, SEO-data, CRM-data and SEM-data. SeoTools for Excel offers a user-friendly method of extracting all this data straight into Excel.

Common questions

Lets get some common questions answered before we move along.

The Spider

One of the main functionalities within SeoTools is the Spider. The Spider is awesome when you want to identify SEO issues on a website such as broken links, duplicate titles, missing meta descriptions and much more.

The spider within SeoTools

How the Spider works

The spider works similar to the way a search engine such as Google does.

Settings

When you open up the Spider, you have a number of different ways to control its behavior. You also have the possibility to choose what data you want it to collect and import to your Excel sheet. Let’s go through each of these settings together.

The settings for the Spider

Choose data to collect in the crawl

This is the section where you choose what data you want the Spider to collect and populate your Excel sheet with.

  • HTTP
  • SEO
  • Connectors

URL Column

Url: the url of the crawled web page.

SEO Column

HtmlCanonical: The rel=canonical element is an HTML element with the purpose to prevent duplicate content issues.

the meta description visible in the Google search results
A truncated meta description

Http settings

Next to the Report name, can find a link named Http settings.

Day-to-day usage

We have looked at quite a few different functions within the Spider functionality of SeoTools. Now it’s time to give some examples on how you can use these functions in your daily job as a growth hacker/online marketer.

Google Search Engine Results Page (SERP)

Let’s pretend that we want to make sure that the website golf.com is displayed properly for the user in the SERP and for Google when crawling the site.

both the title and the meta description is truncated by Google

Find pages with thin content

Perhaps you have heard the saying that content is king? This is not only true from a user perspective. Google has said that “content” is among its top three ranking factors.

Final Remarks

I hope that this blog post has given you an idea of how powerful the spider functionality within SEOTools are and how you can start using it most effectively.