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


Keith Brumwell 20 July 2019 - 3:08 pm

Brilliant and exceedingly helpful tool!

Mac 18 July 2019 - 9:45 pm

Awesome tools.
Thank you for sharing.

Jim Grayson 16 July 2019 - 7:40 pm

Great stuff! A really awesome tool.

Suzain 15 July 2019 - 2:48 pm

Hey, Thanks. How can I donate here.

Radhika 15 July 2019 - 2:43 pm

Nice. Thanks for sharing.

Mandy 15 July 2019 - 1:18 pm

Hi Jaco, On the $10 per month subscription of 100 Kw per sheet, 1 Domain is that 100 Kw per month?

Jaco 15 July 2019 - 1:35 pm

Hi Mandy, this sheet supports 100 keywords per domain, but you can do unlimited checks on demand, there is no limit per month on the $10 subscription.

Mandy 15 July 2019 - 2:43 pm

Great! Thanks for the quick response.

Gautam Sharma 14 July 2019 - 9:10 am

Hi, I added 9 keywords, but none of them crawled successfully

Kate 10 July 2019 - 4:12 pm

Hi! It’s my first time to use the tool but it wants me to upgrade even though I only have 4 keywords to fetch. Can I request to have the limit cleared off like Julie please so we can determine if this tool is for us? Thank you so much!

Jaco 11 July 2019 - 2:21 pm

Hi Kate, we working on improving the sheet and this shouldn’t be an issue that occurs too frequently.

Julie 10 July 2019 - 9:42 am

Hi Jaco,

On my file, I get the “Upgrade to RankTank Basic -> $10/domain/month” message however this is the first time in several days I am using one of RankTank tools and I only had 70 keywords to fetch.
This means I shouldn’t have hit the daily limit you mention on your membership page : “From 1 July 2019 any RankTank free user running more than 1000 queries per domain per day per month will be rate limited and asked to upgrade to either of the two RankTank paid options below (…)”

Why do I get this message ? Could you explain ?


Jaco 10 July 2019 - 10:05 am

Hi Julie, your usage was detected heavy enough to validate the upgrade notice by our API, this notice does not clear unless you upgrade. As a once-off courtesy I have cleared it for you, but to avoid it in future please do consider upgrading as crawling does have inherit costs attached to it.

Julie 10 July 2019 - 10:20 am

Thanks for your explanation and gesture (I actually thought there was a reset each day) and totally got your point on the costs generated by this tool. Gonna think seriously about upgrading 🙂

Thanks !

Jaco 1 July 2019 - 8:23 am

If you’re receiving “No response” then your usage is too heavy for the free service and you can contact me to upgrade to a paid package to lift the restriction. Alternatively check your upgrade options here:

Adams 26 June 2019 - 1:20 pm

This tool is really useful.. thanks

Jaco 21 June 2019 - 5:11 pm

If you’re getting “No response”, assume you’re hitting some limit and consider RankTank Pro or try again later. You can contact me if you’re unsure, just include your domain (the one you’re checking rankings for…). 🙂

Andreas 26 June 2019 - 2:45 pm

It sucks :-/ There is always “no answer”. It’s no longer useful.

Jaco 27 June 2019 - 6:35 am

What domain are you checking? (You’re probably blocked, I’d recommend paying to use RankTank Pro if that’s the case :)).

Andreas 1 July 2019 - 5:50 am

I used the sheet for up to two years for the domain about twice a week for 100 keywords. I don’t need more, so the pro-sheet is oversized.

Jaco 21 June 2019 - 12:13 pm

SEMrush has provided RankTank users a special SEMrush PRO subscription with an additional 500 keywords to track keyword position (value of $159.95) for a total of only $99.95 (valid until end of June 2019). This can be a great alternative while we working on a fix for the free keyword position tool sheet.

The RankTank Pro sheet still works and you’re welcome to also upgrade to RankTank Pro and access the other amazing PRO tools. 😛

Gokhan 21 June 2019 - 3:03 pm

Jaco, thank you for your all effort fixing the issue and getting us awesome tool such a this. I am waiting for a new version about 2 months but what a pity 20. version is still giving error as “No Response”.

Jaco 21 June 2019 - 3:06 pm

Please do not abuse the free tool, if you’re getting no response please make a new copy of the sheet as I now log usage.

Jaco 3 June 2019 - 7:32 pm

We are aware of the issue with the sheet being blocked by some recent Google changes. We are working on a fix and should be able to provide feedback shortly. Please keep in mind that many of the tools are provided free of charge to assist the community. Please consider a donation to RankTank in order to assist with future development.

Raj 4 June 2019 - 5:38 am

We appreciate and will try our best, thanks for letting us know

Brian Rubin 4 June 2019 - 5:51 pm

Thank you for the update. Good luck with the fix!

Nilesh vaghela 7 June 2019 - 12:07 pm

Brother, Heartly thanks. I have used this keyword ranking sheet for 7 months. helped me a lot.
Willing to donate but low-salary. Will contribute soon. Thanks a lot to all RankTank Team.

Jaco 13 June 2019 - 7:55 pm

Update 13 June 2019: I will be releasing a new version 20 within the next week which addresses the current issues with the sheet. Please subscribe to our mailing list to be the first to know or follow me on Twitter @Jaco_van_Wyk.

Andreas 13 June 2019 - 9:39 pm

I want to donate. Where can I do that?

Jaco 14 June 2019 - 6:12 am

Please use the donate button at the top of each page 🙂

Raj 14 June 2019 - 11:52 am

This button is not allowing me to donate, i tried 4-5 times but always failed, i will send you screenshot to you Jaco

Jim 3 June 2019 - 3:14 pm

Hey Jaco, can not get keywords positions anymore, it shows only crawling..

Raaj 3 June 2019 - 6:37 am

Hello Jaco, this is sheet is not any more working and not demonstrate a solitary watchword position, it indicates just only crawling crawling crawling.

Srishti 1 June 2019 - 10:59 am

Hello Jaco, How are you?
since few days your rank sheet is not working, is there any issue, i am waiting for your reply, Thanks Srishti

Helen Killian 31 May 2019 - 8:58 pm

Hey Jaco, this is sheet is no more working and not show a single keyword position, it shows only crawling crawling crawling.

Kevin 30 May 2019 - 9:34 am

Hey Jaco, This sheet is not working as it giving captcha error. I think you need to resolve this issue.

Jaco 31 May 2019 - 1:34 pm

Yes we are aware and we’re working on it 🙂

Sandeep Pattanaik 29 May 2019 - 10:01 am

How to get rid of this “Google is asking to solve the CAPTCHA” issue?

Jaco 29 May 2019 - 12:51 pm

We’ll try expose this to the user to complete the CAPTCHA, will keep you posted in the future update.

Diamond Susngi 23 July 2019 - 1:17 pm

how to use this thing?

Jaco 23 July 2019 - 1:26 pm

Enter your domain without http:// or www (e.g. and set your desired keywords, then select Run in the dropdown at the top left.

1 14 15 16 17 18 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