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


Jorgen 19 November 2015 - 6:19 pm

I am also getting “Need to Retry” on all keywords, I have tried many different Google domains as well. None is working since yesterday.

suadieuhoa 19 November 2015 - 8:56 am

Great! Keep up good job.

Brett 18 November 2015 - 4:49 am

I’m also getting the “Need to Retry” every time now. Wasn’t before. Nothing’s changed. Try multiple times to paste in keyword. Re-downloaded your beta 4 also. Is this broken?

Kim 15 November 2015 - 4:36 pm

Hi Sean,

Thanks for sharring your KW Rank tool.

First i past around 200 KW into the tool and it’s almost work. Then i try with 100 other KW and know a have same issue like Michael. It says “need to retry.”

The Search is in

– Can you help / fix it ?

Essay help 14 November 2015 - 11:58 am

Best rank checker and you make it so easy…

Czerny Peter 9 November 2015 - 2:50 pm

Hello there,

Supertool I’ve been looking for years after something.
But with me I get no results. For each keyword is:
“Need to retry”
Please help.

Thank you

Michael 4 November 2015 - 11:40 pm

Hi Sean, awsome tool, thanks for sharing it, I was wondering how to remove the 713 row limit, I’ve tried adding rows but the rows are just blacked out and when i paste the keywords in it won’t check them, also tried changing the ranges but that just screwed it up. hope you can help, Regards

krosme 4 November 2015 - 10:29 am

Hey Sean. Really great tool. Unfortunetly, everything worked fine the first 3 days and since, it just keeps saying “need to retry” for every keywords when I open the sheet. Is there anything i can do to change that? My ip is good in the FAQ, i haven’t changed any script. I tried to copy the file, same thing. Tried to delete a lot of keywords from my sheet, no change at all. Maybe is it because i left the sheet opened all day long yesterday? Is there a maximum number of tries? Am i banned in anyway?
Anyway, thanx for your work and your help.

usun wirusa 29 October 2015 - 4:27 pm

Your tools are really awesome!

Michael 21 October 2015 - 5:12 pm

Not sure if the tool requires an SEMRush api key, but every keyword I have tried says “need to retry.” I have logged in and out of Google, and have tried to delete and reenter the keywords multiple multiple times. Thoughts?

Sean Malseed 27 October 2015 - 4:49 pm

Hey Michael! What Google country are you searching on?

Giuseppe 28 October 2015 - 11:58 am

Hello Sean, and thank you very much for this awesome tool.
I’ve used it happily for some weeks but now, suddenly, it won’t work.
Every keyword displays the “need to retry” message, no matter how many times i cut and paste them, or log out and in into my account.

In addiction, the “need to retry” box promptly appears in like 1 or 2 seconds for all the keywords at the same time, unlike in the past if a keyword failed it took several seconds to give the error message.
So I worried that google changed something in the way these requests are managed to avoid people using such kind of tools.
I’m using

Have you any idea?

Vincent 14 October 2015 - 9:22 am

Ey Sean,

Just bought the Semrush API, but I get a lot of “no data” or “#N/A” in cell’s and just 2 correct rows with data (out of 16 keyword rows). Any idea what the problem could be? I have enough credits for the API: 299000.

Thanks for the great tools on your site!

Vincent 16 October 2015 - 3:15 pm

I guess those keywords have just too low volume

Attila 12 October 2015 - 9:59 am

Hey Sean,

I just wanted to say thank you for this tool! I’ve been looking for something like this for years!

Thanks again.

Michael 11 October 2015 - 9:04 am

Hi there,

thanks for developing this tool.
However the localization does not seem to work. For or i get results, for,, get “Need to retry”.

Any Ideas?

I would love to use this tool.


Sean Malseed 12 October 2015 - 12:28 am

Hey Michael, happy to help. Could you share your sheet with me? [email protected]

Michael 12 October 2015 - 8:54 am

Hi Sean,

thanks für the quick reply.

I tried again in my office today and now it seems to work 🙂


Andrew 9 October 2015 - 8:07 pm

When I click the link, I am getting “Sorry, the file you have requested does not exist”…

Sean Malseed 12 October 2015 - 12:29 am

Whoops, fixed!

Jorgen 9 October 2015 - 7:46 pm

Google Docs says “file doesn´t exist”, has the file been removed?

Sean Malseed 12 October 2015 - 12:29 am


teddy marie 9 October 2015 - 10:21 am

Hi Sean,

As always your tool rocks ^^

I think it can be usefull for others too (to invert the sparkline)

So if you want to see if your ranking growth change your formula like this SPARKLINE(J11:AG11,{“charttype”,”line”;”rtl”,true})

It will invert the sparkline accordingly ^^


Sean Malseed 9 October 2015 - 12:01 pm

Thanks Teddy!!

Dan @Write My Essay Service 8 October 2015 - 8:03 am

I think I’m going to try this tool out, looks cool.

jak usunac 5 October 2015 - 7:30 pm

Awesome tool.

Sean Malseed 5 October 2015 - 7:54 pm

Thanks Jak!

Dhwanil 29 September 2015 - 8:21 am

Hi I just tried the tool and it’s awesome.

Some of the keyword positions are not accurate, I think that is due to location set in the google settings. I hope soon you add the location (city/zip) with the tracker.

also is there any limitation on number of keyowords and sites this can track?

I have more than 50 sites with all over 3000 keywords to track daily. any solution?

Thanks and great effort !

Kyle B 29 September 2015 - 1:33 am

Hey Sean,

Awesome tool… I read through all the comments and saw quite a few mentions of people having issues with “Need to Retry”, but it is happening for the majority of my keywords. Tried posting in smaller batches, but still keep getting the message on a bunch of the keywords. Trying to keep track of around 300 keywords, and if I have to manually copy, delete, paste for each of the ones that don’t work, it will take hours.

Any suggestions? Is there any way to make the doc continue to retry on it’s own until it gives you data? What about a button that retries all the cells that “Need to be Retried?

Appreciate the help.

1 3 4 5 6 7 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