Save Hours Using Excel For Big SEO Meta Tag Projects

4 Flares Twitter 0 Facebook 1 Pin It Share 0 LinkedIn 3 Buffer 0 Google+ 0 4 Flares ×
Wikipedia youngsters SEO meta tags?

Image via Wikipedia

For search engine optimization “break through”, there are many factors that count towards total success. Meta tags are one piece of the puzzle. Learn a quick way to address this concern on a large site.


Google claims over 200+ signals to their core algorithm.

That’s a lot of variables to consider. And, every site, marketplace and strategy is different. Talk about SEO-soup! On top of that, SEO is a never-ending task.

However, all SEOs agree that having a  search friendly website with clean code, easy navigation/architecture, great content that inspires, educates and informs are cornerstones for long term success. I’m not talking about a quick overnight job. That’s best left to the search engine spammers (read: why?).

Most serious websites in the business & search engine sense will have hundreds and thousands of pages. They will be based on a CMS (content management system) platform, running on Apache webservers or Microsoft/IIS, for example.

Assuming you have built a here-to-stay website, how can you manage all the tags on your website? Excel to the rescue.

Now, many sites are what I call “brochure-ware” sites – a home page, contact us, about us, terms, privacy policy and a couple of product pages all talking about themselves. Not very useful, and hard to “optimize”, unless you are a brand, or have created a contest, quizz or video site that is intended as a bridge to somewhere else.

In this example, we assume a large website. With that scope of a project, managing a seemingly simple thing called (SEO) meta tags on your site will appear too much.

Without getting into specifics of how to write tags (TITLE, DESCRIPTION as primary), here’s an easy way to get a birds-eye view into your SEO website project.

Step 1 – Spider the site

You can use several tools for this, but make sure that the elements are available in CSV format. When you spider your site, be sure you can access TITLE, DESCRIPTION, etc for each page. Make sure that each element has a value assigned, ie. true/false, 1 or 0 to indicate compliance.

Step 2 – Fire up Excel

Import the CSV file. Depending on the version of Excel (Office 2010 in the version below), find the Conditional Formatting option. Then, it’s just a matter of selecting your region, and setting the formula to toggle your values. In the below, you can see the TRUE/FALSE is highlighted based on condition met.

Step 3 – Work &  Finalize

Track your work obviously, but start applying the changes to this change management worksheet, and either apply yourself, or send to webmaster.

Figure 1 – Excel with conditional formatting from a search spider


seo meta tag view in excel

What do you think?

About 

Entrepreneur Magazine says Jon Rognerud is one of the most sought-after SEO and Digital Marketing Experts for Small Business. He is famous for his high-return and passionate approach to optimizing websites and integrated marketing solutions that brings process, profits and brand loyalty...without wasting time. His brand NEW website optimization book, "The Ultimate Guide to Optimizing Your Website" from Entrepreneur Press/McGraw-Hill is in bookstores now. Act fast, and get a free gift here. Jon on Google+. To receive future updates, Click HERE to subscribe to our mailing list

Hey, give me your thoughts below: