Title Tag Length and Excel


Recently, Google has changed they way title tags are being displayed in the SERPs, causing most tags to be truncated. Prior to this change, the rule of thumb for title tags was 65-70 characters which included any spaces and special characters. The new update has title tags showing up at a pixel width rather than length.

What Does This Mean For Me?

Should I go through my website and change all of my title tags? No. Your website may be ranking well in its current format so don’t go getting nervous just yet. If however, you titles are obscenely long and not preforming as well as expected, then I would advise switching some things up a bit. Web Shop Optimizer has created a great tool to measure the width of your title tags and will compare it to other versions you have entered as pictured below:

web shop optimizer title tag width
Screenshot of web shop optimizer title tag tool






Moz also offer a great tool (accessible from the first link in this post) that will provide a mock preview of the SERP result when you enter a title tag and target keyword.

moz title tag width tool
Screenshot of the title tag tool offered by Moz









How Can I Test This on a Large Scale?

The tools listed above are great but limit us from one to a few example of title tags. If you have a website that have more than a dozen or so URL’s, those options may not be the best use of time.

A quicker way to test your title tags

The other day I found myself working on a website w/ a few thousand URLs and couldn’t fathom checking the page title width for each page, one at a time. So what I did was find ONE title tag that was 512 pixels and pasted it into Excel. The Column width was 60.75.

Here is a screenshot of what it looks like:

excel column width
Column width dialog box in Microsoft Excel







The easiest way to test the current width of all page titles on our site is to run the website through screaming frog. This will provide us with a list of page titles, H1 tags, Meta Description and so on that we can then export. Once in Excel, right-click on the column that contains the title tags and choose Column Width.

The newly formatted column allows us to see if our title tags are too long and which ones can be adjusted accordingly.

My Two Cents

This is a great way to present a technical audit to our clients when they ask about best practices regarding title tags. I’d love to hear any success stories from anyone who has tried this method and presented it to their clients.

About the Author:

An SEO in NYC with a penchant for the technical side of things. Father, Husband, Novice Photographer and Music Lover.

1 comment

  1. Hameem Kader

    Great tool recommendations

Comments are closed.