SEO Excel tool: build a simple tracker that works

• A spreadsheet is enough to start tracking SEO. You do not need paid software at the beginning.
• Use four tabs: pages, keywords, links and a monthly summary.
• Fill it from free data in Google Search Console and your own audit of the site.
• Review it once a month. A tracker nobody opens is useless.
• The sheet shows you what to fix, but it cannot do the fixing.

Many small site owners buy a tool, log in twice and forget it. A sheet that you made yourself forces you to understand each column. It is also easy to share with a freelancer or a colleague.

You can use Excel, Google Sheets or any spreadsheet. The structure below works in all of them.

One row per page. Columns to include:

• Page address
• Page title
• Main topic in plain words
• Date last updated
• Word count (rough)
• Clicks and impressions from the last 28 days
• Notes: what needs fixing

Sort by impressions to find pages that are seen but not clicked. Those often just need a better title.

One row per search phrase. Columns: the phrase, the page meant to answer it, current average position from Search Console, and a priority from 1 to 3. Do not track hundreds. Thirty useful phrases beat three hundred random ones.

Record each place that links to you or names your brand: date found, source address, type (article, listing, social, directory), and whether it sent any visits. This is also where you note sites you want to approach.

Add a line chart for clicks. Even a simple trend line tells you whether work is paying off.

1. Create the four tabs and copy the column names above.
2. Export the page and query reports from Google Search Console and paste them in.
3. List your pages and match each to one main topic.
4. Highlight any page with a title longer than about sixty characters or missing a description.
5. Add a monthly reminder in your calendar to refresh the data.

• Tracking too many columns, so the sheet becomes a chore.
• Copying competitor figures from guesswork tools and treating them as exact.
• Forgetting to note what you changed, which makes it impossible to learn from results.
• Mixing paid and organic numbers in the same column.

If you also run social channels, add a fifth tab with followers, average views and the visits those channels send to your site. This helps you see whether social effort supports search interest. If you decide to try visibility boosts for a public profile, record the date and the service so you can compare results honestly. The free trial page lists offers you can test on a small scale, and the tools page has other helpful utilities. Remember that purchased numbers can drop and do not create reach or sales by themselves, so track real visits and enquiries as well.

Once you manage many pages or several clients, paid tools with automated tracking can save time. Until then, the sheet teaches the habits that matter: look at the data, change one thing, then check again. The blog has more beginner guides in the same spirit.

A few simple formulas make the sheet smarter. Use a click through rate column that divides clicks by impressions, then sort to find pages with many views and a low rate. Add a column that shows days since last update so old pages stand out. A conditional colour on any title longer than sixty characters saves you from checking by eye. Keep formulas simple so anyone can edit them later.

Can Excel replace a paid SEO tool? For a small site, yes at the start. Paid tools add automation and larger datasets, but the sheet covers the essentials.

Where do I get the data for the sheet? Mainly from Google Search Console, plus a manual list of your pages and links.

How often should I update it? Monthly is enough for most small sites. Weekly updates add effort without much new information.

Is Google Sheets better than Excel? Neither is better for this. Google Sheets is easier to share and collaborate on, while Excel works well offline.

Can I track competitors in the same sheet? You can add a simple tab with notes about their pages, but treat any estimate of their traffic as rough.