Skip to content
The title slide and first slides of the SEO Keyword Tracker template

SEO Keyword Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Style
Modern
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

A keyword tracker for SEO specialists, content writers and site owners. The Keywords tab lists each search term with its intent, monthly searches, difficulty, the page you are aiming at, and its ranking last month and this month. The Summary tab counts keywords and searches by intent, shows average rank and charts search volume so you can see where the effort should go.

The template comes with sample keywords. Make a copy, then replace the rows with your own. Places gained and the summary update as you change the ranks, and rows where a ranking has dropped turn red.

Useful for

  • Checking which target pages are moving up or down each month
  • Planning content by search intent
  • Reporting keyword progress to a client

What's included

  • 3 tabs: Summary, Keywords, How to use
  • Summary: a dashboard with 4 summary figures
  • Keywords: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Keywords tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this SEO Keyword Tracker template free?

Yes. Download the template and make a copy for your own use at no cost.

Does it work in Excel?

Yes. Download the .xlsx file from this page and open it in Microsoft Excel. The tabs, formulas, dropdowns and charts all work there.

Where do the rank figures come from?

You type them in. Take the ranks from your rank tracking tool or search console each month, enter them in the two rank columns, and the template works out the change.

  • #seo-tracker
  • #seo-keyword-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More seo strategy templates

See all 4

Also in Marketing

All marketing templates
Get this template

Preparing your template…