Free Keyword Position Rank Checker Tool

by Jaco

Free Keyword Position Rank Checker SEO Tool by RankTank

There is a new RankTank keyword position and rank tracking tool! It’s also available in a limited free version.

The RankTank Google Sheet Add-on, is an improvement over the legacy tool. It therefore comes with many enhancements including the ability to automatically re-scan failed keywords.

Free keyword position rank checker google sheet addon

Free Keyword Position Tool

Note: This version of the legacy free keyword position rank checker tool (below) now supports the ability to save your rankings to a new tab. You therefore never lose any historical data when you re-scan. It also provides for desktop and mobile user agents when scanning.

This Google keyword rank checker allows you to paste in a list of keywords, enter your domain, and pull back all of the Google keyword rankings in real-time. Above all the keyword position tool is totally free and built completely into a Google Sheet!

Free keyword position rank checker legacy google sheet

This free SEO tool includes support for SEMrush API in order to pull in MSV (Monthly Search Volume) data to show alongside your keyword ranking within the Google Sheet.

Get this SEO tool for free!

Click the "Free Download" button below...

Instantly receive a link to access this free SEO tool.


Send download link to:

Subscribe to get free SEO tool updates.

  • Bitcoin
Scan to Donate Bitcoin to 19gHVYrSygFuUKXhZ2fDcfmk1WD2t1Yoym

Donate Bitcoin to support RankTank

Scan the QR code or copy the address below into your wallet to send some Bitcoin to keep RankTank free forever!

Get this SEO tool for free!
You can also Make a Copy of this Google Sheet SEO tool, help fix and improve it for others.

Keyword rank checker SEO tool

This free SEO tool will let you check keyword rankings relative to your domain, right inside of a spreadsheet. There’s a lot of free keyword tools out there, however this tool is completely open and transparent. All of the code is right there for you to view, modify, and tweak to your needs? Create something cool out of this? Hit me up and let me know!

Keyword position rank monitoring on a schedule?

Set this sheet up to run on a schedule, and you’ve got yourself a free automated SERP rank checker. It’s totally free! Automate keyword ranking reports, track and set alerts on Google position changes. In other words you get a full understanding of what keywords you do rank for on Google – and where – totally free!

Try additional SEO tools for free!

Lift the 100 keyword limits of the “legacy” free keyword position rank checker tool, Make a Copy of the Pro Keyword Rank Checker Google Sheet SEO tool.

This is a RankTank Pro SEO tool which requires a RankTank Pro Subscription @ $149.95/month.

Know Issues

1. I get some blank rows without a result, even after waiting a few minutes. The request failed and you need to retry it by cutting and pasting the keyword in the cell again. Alternatively select “Reset” and “Run” again to re-scan all keywords. In addition you can also look at using the new RankTank Google Sheet Add-on with automated intelligent retries.

2. I am getting no results or not ranked for all keywords. Make sure you’re online, not blocking any sheet permission and that you’re only using your desired domains TLD e.g. and not http(s):// etc.

WIP: How does local results affect rankings?

The beta version of the local result keyword position rank checker tool allows you to set your region, language and local area (city, airport, municipality etc.). Importantly you can now pull all of the Google SERP local keyword rankings. We use the “uule” parameter or “near” parameter in order to filter by locale.

Try additional SEO tools for free!

You can also Make a Copy of the Local Keyword Rank Checker Google Sheet SEO tool.

This is a RankTank Pro SEO tool which requires a RankTank Pro Subscription @ $149.95/month.

In conclusion the local search rankings tool is a complex work in progress, hence the beta tag. In short we use the Google Adwords location information to generate local search results based on the “uule” parameter. Most importantly this is the same parameter Google uses in it’s own SERPs. Should it not be possible to calculate the “uule” parameter we fall back to using the more general “near” parameter in order to filter the results.


Leave a Comment


Francesco 27 September 2015 - 9:24 pm

To clarify more, I am using “” as locale engine.

Francesco 26 September 2015 - 10:52 pm

Hum… I guess I have been banned by Google, because now I always get “Need to retry”, also for one single keyword… Maybe Google became smarter and now avod such scraping through itself… Can you check it, please?

Sean Malseed 26 September 2015 - 11:53 pm

Hey Francesco! The beauty of using Google Sheets is that it doesn’t use your IP address 🙂 It uses an internal Google IP address instead. Sometimes Sheets just goes slow when it needs to make a lot of pulls.

Francesco 27 September 2015 - 9:46 am

Yes, you are perfectly right, my apologizes…now it works again and very well! Thanks!

PS: I also added conditional rules for background colors! Your tools are really powerful.

Sean Malseed 27 September 2015 - 1:52 pm

Awesome! Thanks Francesco!

Francesco 27 September 2015 - 9:21 pm

Sorry Sean, I have again the same issues about “Need to retry”… No data are scraped. I erased and pasted ten times the keywords (also only 1 at time), it does not work for me… It works sporadically only.

Francesco 30 September 2015 - 8:50 am

Well, finally I found the culprit!

I had some duplicate keywords in my list… that way it does not work and you will get the “Need to Retry” error.

Now it finally works as it should and it is awesome!

All the best

Sean Malseed 3 October 2015 - 2:29 am

Dude, thank you so much for figuring that out!

Francesco 26 September 2015 - 10:25 pm

Your tools are really awesome!

About this Keyword position checker, is there a way to add some formulas able to highlight results with colors based on rank positions, please?

So, for example, green background color for results from 1 to 10 positions, yellow for results from 11 to 20, orange for results from 21 to 40 and so on, please?

Just to have a more clear overall point of view.


Mike 20 September 2015 - 11:14 am

Hey Sean,

I tried to use your tool, but when I insert keywords (like shown in tutorial), nothing happens. Status says crawling complete, but it didn’t even start crawling 🙂

Domain and localisation are set right. What to do? Thanks for help.

Sean Malseed 20 September 2015 - 11:09 pm

Hey, that’s strange! Could you share your sheet with me? [email protected]

HC 17 September 2015 - 10:25 pm

Is there any way to use this tool as if the queries are being run from the location in my Google settings? For instance, I generally swap out location settings to test keyword performance across different areas in Northeast Ohio.

Jack 15 September 2015 - 12:21 pm

Awesome tool! One question though, does the scraping take into consideration Places and PPC? Because I’m seeing some differences in results I’m getting. For instance, I search for “example keyword” for The tool says that I’m on position 20 in SERP, but when I do a manual search (non-personalised, clearing cache and cookies, etc.) my site pops on position, let’s say, 11. If it does count Places and PPC, what could be a possible workaround?

Sean Malseed 22 September 2015 - 4:34 pm

Hey Jack, it’s actually searching from a Google server in California, so take that into consideration 🙂 Haven’t figured out a way yet to get around this in Sheets.

Jack 23 September 2015 - 12:26 pm

Oh, California. Is it possible to use a different server? Since I am currently in the UK and use it to check UK websites in Won’t that provide better accuracy?

Sean Malseed 26 September 2015 - 11:55 pm

Since you’re in the UK, you’re probably getting an IP address from a UK data center actually.

Jorgen 11 September 2015 - 9:47 pm

Thank you! Really an awesome tool! Worked flawless first time!

Tomislav 11 September 2015 - 4:48 pm

Hey man, great tool. I’m having some problems when I enter a localized google (, retried like 20 times and nothing. Any info on that?

Also I have a nice little add-on I can make if you want, a button to click retry that macro-copy-pastes the stuck keywords 🙂 Lemme know if you want, I will make it in my separate sheet and send you a link to copy it

Tomislav 11 September 2015 - 4:56 pm

Ah sry, I deleted the “www.” part and now it works. 🙂

William 11 September 2015 - 9:32 am

Hi Sean,

Great tool!

I do have an issue in the: “This tool won’t ban.

your IP. It uses a Google internal IP, shown below!” section.

In the “IP Used:” section it says “#N/A”. And when you mouse over it, it says:

Could not fetch url:

Please advise.



Sean Malseed 22 September 2015 - 4:34 pm

Thanks William! Should be fixed.

David 10 September 2015 - 9:19 pm

For some time now, IP Used shows: #N/A nd I can’t get any resaults what so ever.
Is there a workaround or can I use other IP instead?

Sean Malseed 20 September 2015 - 10:10 pm

Hey David! It’s fixed 🙂 Took the IP display out for now, but it’s still using the internal Google IP.

Mike 10 September 2015 - 12:00 pm

Great tool! Really simplifies keeping up with my keyword rankings

Sean Malseed 20 September 2015 - 10:09 pm

Thanks Mike! Really means a lot!

ecchi 8 September 2015 - 12:33 pm

you are a genius. This works great, if a little finicky. The ip thing at the top right doesn’t seem to work, but it’s still checking the keywords, and when testing it with keywords I know rank well it showed them as I was expecting them. I’ve used many keyword position tools before, and this is the first one that’s actually worked.
Thank you very much for the awesome spreadsheet, if there were more like you the world would be a better place.

Sean Malseed 20 September 2015 - 10:08 pm

Thanks! The IP thing is fixed 🙂

Vino 3 September 2015 - 5:47 am

Thanks for this wonderfull tool

Thinh 2 September 2015 - 9:53 pm

I have used this for several months now and it was working fine. Now not so much? Any helps with this? I keep seeing NO API KEY?

Sean Malseed 20 September 2015 - 10:06 pm

Is your SEMrush API key still active? If you share your sheet with me – [email protected] – I’ll be happy to take a look.

Thinh 2 September 2015 - 3:26 pm

I can’t seem to get this to work for some odd reason.

Sean Malseed 20 September 2015 - 10:05 pm

Hmm, what’s it doing exactly?

Alex 1 September 2015 - 3:20 pm

Hi Sean
First of all, congratulations for the App!

For me it’s not generating the IP, and on the cell I’ve got the Error Message:
Could not fetch url:

Do you have any clue?

Sean Malseed 20 September 2015 - 10:02 pm

Hey Alex! It should be working now. Is it working for you? Thanks!

imran 30 August 2015 - 6:25 pm

friend it is great tool.
but wanted to know why it showing some wrong ranks for keywords.

Sean Malseed 20 September 2015 - 10:00 pm

Thanks! It’s probably location influence. What bad results are you seeing?

Haberler 30 August 2015 - 12:06 am

Is there a way to tap into Google’s location info? Thank you.

Sean Malseed 20 September 2015 - 9:59 pm

Not that I can figure out yet. If you have any ideas I’d love some help with that feature!

Pavan 28 August 2015 - 12:40 pm

I tried to buy API at SEM Rush but it’s 70$, How can I buy it for 15$.

Sean Malseed 20 September 2015 - 9:20 pm

Did you try the link in the sheet? It should take you to the $15 page.

Adam 27 August 2015 - 12:12 pm

This tool doesn’t seem to be working with my domain, It never finds the position. It also doesn’t display the positions for

Sean Malseed 20 September 2015 - 9:18 pm

Hey Adam, could you share your sheet with me? I’ll check it out. Share it with [email protected] – thanks!

1 2 3 4 5 6 22

Free SEO Tools

RankTank uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More