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
To clarify more, I am using “Google.it” as locale engine.
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?
Thanks!
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.
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.
Awesome! Thanks Francesco!
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.
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!
Thanks.
All the best
Dude, thank you so much for figuring that out!
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.
Thanks!
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.
Hey, that’s strange! Could you share your sheet with me? [email protected]
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.
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 example.com. 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?
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.
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 google.co.uk. Won’t that provide better accuracy?
Since you’re in the UK, you’re probably getting an IP address from a UK data center actually.
Thank you! Really an awesome tool! Worked flawless first time!
Hey man, great tool. I’m having some problems when I enter a localized google (www.google.hr), 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
Ah sry, I deleted the “www.” part and now it works. 🙂
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:
Error
Could not fetch url: http://www.realip.info/api/p/realip.php
Please advise.
Thanks!
William
Thanks William! Should be fixed.
Hi,
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?
Hey David! It’s fixed 🙂 Took the IP display out for now, but it’s still using the internal Google IP.
Great tool! Really simplifies keeping up with my keyword rankings
Thanks Mike! Really means a lot!
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.
Thanks! The IP thing is fixed 🙂
Thanks for this wonderfull tool
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?
Is your SEMrush API key still active? If you share your sheet with me – [email protected] – I’ll be happy to take a look.
I can’t seem to get this to work for some odd reason.
Hmm, what’s it doing exactly?
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:
Error
Could not fetch url: http://www.realip.info/api/p/realip.p
Do you have any clue?
Hey Alex! It should be working now. Is it working for you? Thanks!
friend it is great tool.
but wanted to know why it showing some wrong ranks for keywords.
Thanks! It’s probably location influence. What bad results are you seeing?
Is there a way to tap into Google’s location info? Thank you.
Not that I can figure out yet. If you have any ideas I’d love some help with that feature!
I tried to buy API at SEM Rush but it’s 70$, How can I buy it for 15$.
Did you try the link in the sheet? It should take you to the $15 page.
This tool doesn’t seem to be working with my domain, http://www.leagueofsmurfs.com. It never finds the position. It also doesn’t display the positions for zappos.com.
Hey Adam, could you share your sheet with me? I’ll check it out. Share it with [email protected] – thanks!