Website AND SEO Audit with Screaming Frog and Excel

by | Nov 26, 2018 | SEO, Website, Wordpress

Cathy Gray
Strategizing Print & Digital Marketing w/ Business Operations
(and always with coffee in hand)
About | Contact

A Step by Step Website and SEO Audit with Screaming Frog and Excel

I’ll be using this website for this website and SEO audit. 

I’ve prerecorded a video that is on my YouTube Channel, but you can also watch it below without leaving the site. 

I am currently working on a transcript and instructions to follow along if you prefer to follow along at your own pace.

All right, we’ll be going in the step by step on a website audit using Screaming Frog and Excel. Let’s have some fun.

If you guys hear any walking around that’s my dog being a dog and if he barks it’ll scare the crap out of me, too. (Luckily my dog never barked, so I didn’t have to edit out a barking dog.)  

A Glimpse at the Final Audit

The following video is a short clip of what the final website and SEO audit should look like. The video pans to the right showing the content tabs, but does not scroll down to show all of the pages that are included.

Start with Screaming Frog

Let’s get started with Screaming Frog to crawl or scrap our website and export it to Excel where we’ll do some conditional formatting. With the conditional formatting, the report will tell us where we need to make our adjustments for SEO optimizations. It will help us prioritize.

Depending on your website goals, you can add other details to keep track of as well. 

In my case, I’ll have an additional tab for page layout updates, keyword mapping and other things as they come up.

What is Screaming Frog?

First and foremost, don’t let the strange name make you scratch your head. It’s simply a website crawler that gathers meta data or details about a website.

I used the free version because it suits my purposes for this website audit.

There is a paid version which allows you to crawl a website that has more than 500 pages. This is good for an eCommerce site or one that has many pages and articles.

If you need to download it, visit the makers of the software. It’s available for Mac and PC. 

Let Screaming Frog Start Collecting From Your Site

Enter your site and hit start. The time it takes to crawl your site depends on your internet speed and the size of your site.

It isn’t like waiting for water to bowl, watch it or grab a cup of coffee then come back.

Close up of screaming frog before entering a website to crawl Closeup of Screaming Frog with a Website Crawl Complete

Closeup of Screaming Frog Export Button

Once it is complete, export the file.

In my example, I selected All from the drop down menu, but you can filter down if you would like.

For this website audit, this is all that we’ll be using Screaming Frog for. There are so many other things that it can be used for, but right now, it’s about getting prioritizing and setting up a list with what needs to be done.

Finishing Off with Microsoft Excel

In the first and original video, I used Microsoft Excel 2007. In the second video, I used the version of Excel that is connected with my hotmail account. It’s completely online, so the screenshots might be a different from the version that you may using. However it still works in the same way. The styling is the ony thing that will be different. (The Microsoft Office on my computer has been acting goofy today. I quite honestly haven’t had enough coffee today to correct the problem.)

Cathy Gray

Cathy Gray

A Marketing & Operations Aficianodo

About | Contact


Latest Articles

Matthew McConaughy Motivational Speech

The other night, I came across a video clip of...