Serp Ranking Excel Spreadsheet

Search Engine Results Pages (SERP)

There are various types software and tools available in the market that allow search marketers to check their web page rankings on Google SERP (Search Engine Results Pages)

I created this spreadsheet a few years ago and still works perfectly which helps you get an overview where your website sits in search engine’s search results.

It also allows keeps the history so you can track how you perform over time in SERP

  • Get the download link below
  • Enter your website’s name in cell B2
  • Enter your search terms in cells B4, C4, D4, and so on (as many as you like)
  • Click into the next available cell in Col A
  • Press Ctrl-Shift-U to refresh the results.

Note: You may need to enable Macros in Excel.

To update the spreadsheet with Rankings hit: Ctrl+Shift+U

serp ranking

Change Search Engine
It is setup for checking SERP google.ie, however if you need to change the search engine you need ‘Open the VBA Editor’ and change a little bit of code:

VBA
(Const GOOGLE_WEBSERVER = “search engine”)
To Open the VBA Editor in Excel in Windows hit Alt+F11 in Excel

 

I believe in synergy skills for creating quicker, more efficient experiences in technology and workflows I am a Photo Restoration artist & SEO consultant specialising in small business and start-ups.

Leave a Comment

    • Melpo
    • May 30, 2019
    Reply

    Hello,

    thank you so much for sharing this awesome tool .

    Please have a look at the file providen here https://realsocialseo.com/serp-ranking-excel-spreadsheet/
    as when you download and open with excel 2016 it is mentioned as “corrupted file”

    • Reply

      Hi, thank you for highlighting this. I have change the method to receive the #Serp spreadsheet now and emailed you a copy …should work now.

    • ian
    • February 15, 2019
    Reply

    Wont work in excel 2016
    Corrupt,, sorry, it won’t run!

    • Reply

      Sorry I haven’t tried it in Excel 2016. It should work as it’s basic code. Make sure u enable macros?

  1. Reply

    Awesome tool for SERP tracking. Thanks for sharing. 🙂