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 original tool. It therefore comes with many enhancements including the ability to automatically re-scan failed keywords.
RT Sheet Extension Review and “How To” by Ritesh
Free Keyword Position Tool
Note: This version of the original 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!
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:
Bitcoin
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!
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!
Lift the 100 keyword limits of the “original” 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 @ $185.00/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. domain.com and not http(s)://domain.com/page.html 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.
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 @ $185.00/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.
671 comments
I am also getting “Need to Retry” on all keywords, I have tried many different Google domains as well. None is working since yesterday.
Great! Keep up good job.
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?
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 Google.dk
– Can you help / fix it ?
Best rank checker and you make it so easy…
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
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
Michael
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.
Your tools are really awesome!
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?
Hey Michael! What Google country are you searching on?
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 google.it.
Have you any idea?
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!
I guess those keywords have just too low volume
Hey Sean,
I just wanted to say thank you for this tool! I’ve been looking for something like this for years!
Thanks again.
Hi there,
thanks for developing this tool.
However the localization does not seem to work. For google.com or google.hr i get results, for google.de, google.co.uk, google.fr..I get “Need to retry”.
Any Ideas?
I would love to use this tool.
Michael
Hey Michael, happy to help. Could you share your sheet with me? [email protected]
Hi Sean,
thanks für the quick reply.
I tried again in my office today and now it seems to work 🙂
Micael
When I click the link, I am getting “Sorry, the file you have requested does not exist”…
Whoops, fixed!
Google Docs says “file doesn´t exist”, has the file been removed?
Fixed!
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 ^^
Cheers,
Thanks Teddy!!
I think I’m going to try this tool out, looks cool.
Awesome tool.
Thanks Jak!
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 !
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.