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
Hi, Could you please show me how to check the keyword ranking? I did not see any tool which help me to find out the keyword position. Thank you alot and have a nice day!
Hi Jaco,
Any update on a working version of the file? I still get Google captca warns.
BTW, I also checked your “Infinite Google Suggest Keywords” link and it seems that infinitesuggest is no longer working.
Thanks !
Hi Julie, still working on it. Infinite Suggest was down for a pro-longed period, but it should be online again.
Looks like the V19 sheet is down, stuck on crawling for all keywords
Same here. Stuck on captcha or crawling for all keywords.
Same thing here. Stuck on crawling for all. No captcha shown.
I always use this tool to track my projects ranking. But facing problems to track. It show kind of error: “Google is asking to solve the CAPTCHA”
Hi Jaco,
In results there are more than fifty percent Google Captcha error. Looking forward to see the new version!
We are working on a solution, will let you know as soon as we have it ready.
I’ve released a new version 19 of the keyword position tool sheet which delays requests a bit and warns of Google CAPTCHA requests so you can manually retry them. We are working on a better fix for this, but in some regions the sheet already performs much better. 😀
Hi Jaco,
free sheet (newest version 19) and pro sheet (version 18) both are getting the following error: {“message”:”Service invoked too many times for one day: urlfetch.”,”name”:”Exception”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
The error persists since yesterday while two days ago everything was just fine. I hope you can find a solution soon.
TIA, Frank
Update: Everything ok again!
Hi Frank, you we’re hitting the Google Apps API limit for your account.
Hey Jaco, i think it is giving lots captcha than rankings. can you solve or we should wait for new version.😀
Thanks
Not much we can do Raj, we will try improve this in v20.
This is such an awesome Tool. I have been using RankTank for quite some time now. I also encounter the error message. A quick fix is just to copy the keyword – then delete – then paste it back again. I am quite confident the developer would be able to come up with a solution on their next update 🙂
This will work for now but we’ll find a better fix for you soon.
Hi,
Getting the following error message: {“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
Just to explain this error, it is due to Google asking us to complete a CAPTCHA, we will see if there is a way to work around this and will release a new version if we find one.
I’m getting this error too!
{“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
Thanks Lulu, we’re working on a new version to resolve this. Google is limiting sheet queries.
<3
Same error. Thanks for working on it!
Hello!
Actually lots of error messages: {“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
Can you please check that.
Thanks.
[…] can do the job, but for something quick where you just want to pick the current rankings once, try this free tool created by RankTank.org (no registration needed and you can get your rankings via Google Sheets in […]
Best keyword tool.
This is a excellent stuff for check all keywords position and backlinks source.
Thanks for sharing with us.
Hey, how many keywords can it crawl for at a time?
Does it work like the keyword planner on google? I need this for my websites keywords for my outdoor website.
Does it re-scan the rankings every time I open the file? If it is not, what can be done to scan.
awesome tool
This Tool Working Perfectly
Thanks for sharing this tool 🙂
Its not working properly.
What is not working, please explain?
I’ve just released an update for the keyword position tool. The new version is 18, it features a massive code cleanup and speedup as well as minor adjustments to how we speak to the Google API. If you experience issues with the new version please let me know. 😛
Do grab the latest version here (Choose “Make a Copy”)
Hi Jaco, its not giving all keywords ranking, having issue in displaying ranking
{“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}
showing this message in many keywords
Thanks
Hi Raj, please hit me up on Twitter or share your sheet with Jaco at RankTank.