• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Good Books
  • Tools
  • Blog
  • Darren
  • Contact
  • Hire Me
Small Biz Geek

Small Biz Geek

Small Business Design, Marketing & Technology Journal

Solving small business design, marketing & tech problems

  • The Internet
  • Marketing
  • Graphic Design
  • Web Dev
  • Web Design
  • Social Media
  • Privacy & Security
  • Tech
  • Misc

Plan Your Website On Page SEO: Free Excel Template 🚧

Published: June 30, 2015; Updated: September 8, 2023 Filed Under: Featured, Video, Web Development

Are you building a website? Do you have a plan? A basic wire frame? This free Excel spreadsheet is aimed at webmasters taking a common sense approach to website project planning.

Website Architecture, Planning & Development Spreadsheet

It’s helpful to imagine your website as a property – virtual real estate, if you will entertain the analogy. Architects, engineers, surveyors and designers need a blue print or a project plan, and work will usually not commence without such plans.

A Common Point of Reference

The “architecture” of a website is most definitely in the category of web development. Turning your development plans into coherent data provides a means of quick analysis for fellow designers/developers working on the same project.

Dividing responsibilities, monitoring progress and communicating clearly is vital to the success of any project. It’s especially true if you’re outsourcing.

Download Spreadsheet

This spreadsheet is Microsoft Excel format. If you don’t have Excel, you might want to try the free Open Office software by Apache.

I successfully opened the Excel .xlsx file using the spreadsheet program bundled with Open Office. The character count formulas I created to measure page title and meta description length were intact.

Most Windows operating systems have Microsoft Office preinstalled. If you don’t have it and you’re looking for a suite of cloud based Microsoft Office tools (which include Excel) try Office 365. 

Download the free spreadsheet here (MS Excel)

(Updated December 2017 – new Google meta description max length)

Spreadsheet Icon

Video Demo

This 10 minute video analyses the spreadsheet and explains each row and column in detail.

By the end of the video you should have gained an understanding of the document and be confident in modifying it.

It may be worth your while taking a few lessons on using Excel. Use YouTube to search for Excel video tutorials.

Watch video on YouTube

 

Recording Changes

It’s likely your website will change over the next few years. As priorities evolve so to do the strategies.

The structure and content of a website usually undergoes revisions and those tweaks/changes need to recorded.

  • If your page titles change on your website, go change them in the spreadsheet
  • If meta descriptions change on a blog posts, make sure those changes are reflected in the spreadsheet also
  • Page hierarchy (parent/child structure) can be altered using the colour coded rows

A Quick Breakdown of the Spreadsheet

  • New rows are easily inserted in the spreadsheet when pages are added to your website
  • Character counts are included (using Excel forumlas) to ensure website page titles/descriptions fall within the recommended length to avoid truncation in search engine results.
  • You can quickly look at the running theme of keywords in titles, descriptions and URLs to avoid conceptually disjointed pages
  • Uses a recommended colour coded “Silo” structure for search engine spider preferences as well as ideal user experience

The “Silo” Website Structure Explained

The silo structure is a method for organising your website content into specific pages that use a family tree structure. This is similar in principle to the way you would organise a dissertation or academic essay.

There are two types of silo: virtual and physical. The example below is a “virtual” silo.

Website Silo structure

A “physical” silo uses a hard coded directory structure of folders within folders using topical keywords.

The URL of a physical silo is structured like this:

www.fruitjuice.com/apples/apple-juice/apple-tree/purchase-seeds/

A physical silo folder structure is recommended if you are building a site with lots and lots of content and pages. But since many small businesses use WordPress today, you will probably not be using physical directories for your content.

You’ll be pleased to know WordPress does support parent and child pages, so you can imitate the physical silo folder directory structure.

The URL of a WordPress URL can structured like this:

https://www.smallbizgeek.co.uk/tools/genesis/

Permalink structure for content in WordPress is stored entirely in your SQL database, meaning the URL structure is virtual.

Whatever your URL structure, record it in the URL column in the spreadsheet. It is mentioned in the video.

Spreadsheet Columns

The spreadsheet has a series of vertical columns. These are resizable if you want expand the columns by clicking and dragging with your mouse cursor.

Spreadsheet SEO Planning Development

Titles & Description Length

Keep in mind that page titles and descriptions have a character limit in the search engines.

In other words, when users are browsing results, you don’t want your description so long that it gets truncated just as you’re trying to say something important.

In the worst case scenario amateur webmasters will drop entire paragraphs into meta description tags meaning it is not only cleaved in twain but looks like keyword stuffing from the perspective of search engine algorithms.

If you tweak titles or descriptions on your website, be sure to copy them and paste them into the correct column in the document.

Excel Formulas

On the subject of titles/descriptions length, I’ll take the opportunity to tell you Excel formulas have been used to calculate the average ideal character length.

Make no mistake: you want your text to come under par instead of running over.

Character Count

For more information about title tag appearance in search engines, see this handy free Google SERPs title simulator.

Analysis

The setup of your site is valuable information. Being able to provide such information to other team members makes it easier to work with anyone who may be hired to work on a project.

Do you really want to spend hours on the phone or in person trying to explain something that already exists as data? Keep the document safely stored on USB sticks or a USB backup drive.

Consider storing a copy in a shared folder that all team members can access on the fly. DropBox is good for this, and free.

 

By all means, let your ideas start on the back of a napkin but don’t leave them there. A marketing plan doesn’t just reflect your intentions/plans, it inspires your choices along the way.

Use the tools at your disposal to save time and money. Use this spreadsheet correctly and you’ll thank yourself for doing so in the future.

You Might Also Be Interested In...

  • Create a Twitter Automatic Voucher Code System
  • The Long Term View on Digital Marketing
  • Twitter Tweet Chats: The Good, The Bad and The Spammy

Filed Under: Featured, Video, Web Development Tagged With: Analysis, Google, Planning, SEO, Spreadsheet, Websites

About Small Biz Geek

I'm Darren, helping small businesses with design, marketing & tech.

Small Business Website Design

Do you need help with something web related?

Hire Me

Reader Interactions

Subscribe to Blog Feed by Email

Your email address won't be shared. You'll never be spammed. Check your inbox to confirm opt-in.

Comments

  1. electric bicycles says

    November 10, 2016 at 1:10 am

    Good post, love this sharing so much, thank you!

    Reply

Add Your Thoughts Cancel reply

Your email address is safe and will NOT be shared with anyone else.

Hateful, spammy or abusive comments will not be tolerated.

For more information please see the comment policy.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search Website

Latest Blogs

  • Is Generative Engine Optimisation (GEO) the Answer to the Future of Search? 🎨
  • How Hiding Your Phone Number and Using a Booking System Repels Time Wasters and Helps “Positioning” 🗓️
  • “Fucking Good Content” – Dan Kelsall (Book Review) 📘
  • Scam Poetry: The Time I Was Recruited to the Cult of Amway ⚠️
  • A Story of Seductive Social Media Success and Neglected Email Strategy 🏚️
  • The Classic Social Media Trend Destined to Ruin Your Business 😭
  • Looking for Online Work? Don’t Fall for this Fake Hays Recruitment WhatsApp Scam ⚠️
  • Cream of the Crap: How Fake Reviews, Bad Businesses and Dangerous Products Rise to the Top 💣
  • Exposed: The Hong Kong Investment “Fraud Recovery” Scammer Deceiving Victims 🤑
  • Computer Says No: Does Your Website Work for People with Disabilities? ♿
  • Chinese Tinder Profiles Are Using Photos of Pretty Girls to Scam “Investors” 💋
  • Small Biz Owners “Trapped” Using Email Addresses Belonging to Internet Service Providers 🪤
  • In the Pandemic, QR Codes are Finally Proving Worthy in the West 😷
  • Small Businesses Finally Start Marketing… and All It Took Was a Global Pandemic 🏁

Footer

Primary Navigation

Home
About Darren
Good Books
My Tools
Blog Posts
Hire Me
Contact Me

Derby & Nottingham Area

The Internet
Marketing
Graphic Design
Website Development
Website Design
Social Media
Technology
Miscellaneous
Privacy & Security

Let’s Connect

Twitter
YouTube
LinkedIn
RSS

Small Business Blog · Privacy Policy · Commenting Policy · Website Disclaimer · ICO number: ZA305900


Written and designed by Ilkeston Web Design

  • Home
  • Good Books
  • Tools
  • Blog
  • Darren
  • Contact
  • Hire Me