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


stefanos 20 July 2015 - 3:26 pm

Thank you!!I was looking for such tool long time.Great work!!

Marvin 17 July 2015 - 5:40 am

I REALLY like this tool. I’m wondering if you could add alternating colors to each row so it’s easier to analyze. That would be super cool.

Sean Malseed 19 July 2015 - 9:56 pm

Great idea!

Ashley 13 July 2015 - 7:00 am

Hey Sean,

Your tool is absolutely fantastic! Can’t wait to try the updated one.

You rock. Keep it up. Thanks for sharing this wonderful tool. It’s a great help.


Rommel 11 July 2015 - 11:12 am

Just one word – AWESOME!

Thank you so much Sean. You made my work so much easier with this tool 🙂


César 23 June 2015 - 6:55 pm

This is a master piece. ¡Congratulations!

Kristi Ambrose 22 June 2015 - 8:19 am

Damn, this could be really useful. But, for me, it just keeps saying “need to retry” when I add my keywords. Oh well, maybe I am doing something wrong.

Jay 19 June 2015 - 7:15 pm

This is dope! You are my Hero 😎

Thank You!!!

Sean Malseed 19 June 2015 - 8:39 pm

Thanks Jay!

Free Google Keyword Rank Checker Tools for Webmasters • 14 June 2015 - 12:54 pm

[…] search engine optimisation products and services like oneway link checking.     Rank Tank   This is a loose key phrase rank checker software that permits you to paste in an inventory of […]

limon\\ 10 June 2015 - 1:41 pm

Awesome tool. thanks for sharing.

Sean Malseed 16 June 2015 - 2:47 pm


Sasa Cazar 21 May 2015 - 1:29 pm

Hello and thank you again for this marvel of ranking tool, still using it (beta3) – have issues with 4.

I have an suggestion on how to overcome the “crawling…” stuck at bottleneck, before Google starts monitoring it and decides to put an end to our fun .. (is this possible at all ? doubts..)

1. To insert another column next to “live rank” column, and add a button in every cell related to keyword – assign this button to a script performing “select+copy+delete+paste+enter” – as this we have to do when it hangs… in batches or individual keyword. Then it is stil semi-manual.

2. Same as above, BUT with no action but TIMER/TRIGGER with eg. 60 seconds until executing this script.

Looking forward for any more ideas – community please step up and help and support the author giving this for free !

Ben J 11 May 2015 - 6:11 pm

First of all. THANK YOU! What an awesome tool. Really appreciate a tool like this that is available for free!

A thought I had. Most of the clients I work for only do local businesses. Is there a way to tap into Google’s location info? Even in you had to type in the city or zip yourself? I realize this may defeat the purpose of running the searches off of Google’s servers if you have to use your IP, but wasn’t sure about added in a location manually.

Thanks again!

Greggory Wiley 19 July 2015 - 10:49 pm

I would also love to know how to localize this tool. If I could do that I would no longer need

HC 17 September 2015 - 10:43 pm

Gosh, YES PLEASE!!! I just posted a message about this. Would love to see this because I generally track 3 geographic locations for a particular client.

Sean Malseed 20 September 2015 - 11:10 pm

Hey! Thanks for using the tool! I haven’t been able to get localizations in Google sheets yet. Have you tried SEMrush’s position tracker? It works down to the city level 🙂

Patricia 11 May 2015 - 10:42 am

Hi Sean,

Thank you so much for taking the time and effort to develop such a valuable tool!
I’ve been using it for a couple of months, but recently ran into trouble: the tool either won’t crawl at all or it will deliver a “need to try again” message.
Ocasionally, a couple of keywords will register.

Is there a workaround?

Thanks in advance!

Sean Malseed 15 May 2015 - 1:49 pm

Hmm – I think it’s Google being slow, and the sheet timing out because of it. With all the updates, wouldn’t be surprising. I’m watching it though!

Peter 22 April 2015 - 1:10 pm

Keep getting Need To Retry even in small batches of 10 kw.
Hopefully you can fix this problem because your tool is awesome !

Oliver 3 September 2015 - 12:56 am

Nearly all of my keywords get this response, too.

Sean Malseed 20 September 2015 - 10:06 pm

Is your SEMrush API key still active?

Sasa Cazar 20 April 2015 - 11:19 am

Hi, The tool is priceless and idea is trully out the box! May force be with you to keep it going and improving, adding new features.

Seems that *V4 update does not work properly *also at my end. Beta 3 does.
Noted 2 clicks trick when it stucks at “crawling” – select keywords, delete and UNDO, works as well.

Thanks for this .

Domotua Marketing Online 19 April 2015 - 5:07 pm

Great stuff guys! Good work. I have mentioned this tool in one of our posts related to key tools to use to know your Google positioning for free. The post is written in Spanish….sorry about it 🙁
Thanks for sharing this awesome tools!

Sean Malseed 21 April 2015 - 6:01 pm


Herramientas para revisar el ranking de páginas web para palabras clave en Google (u otros motores de búsqueda) - SEO-Quito, Posicionamiento web en Quito, Ecuador 10 April 2015 - 1:16 pm

[…] RankTank ofrece algunas herramientas interesantes para el SEO. Entre estas es la “Free Keuword Rank Checker Tool”. Esta herramienta funciona a través de una hoja de cálculo de Google que simplemente debes guardar en tu Google Drive (y hacer una copia). […]

Dani 8 April 2015 - 11:51 pm

Thank you so much for sharing your knowledge. It’s nice to know there are friendly people out there! I do have a question though. Is there a way for me to check rankings from a specific location? For example, I’d like to check ranking for the keyword “puppies for sale” that are done from Sacramento, Ca. Is this possible?

Jack 31 March 2015 - 1:35 am

Awesome tool. Can this tool track up to Rank 200?

Venkat 24 July 2015 - 7:42 am

Nope, I don’t see a 3 digit position for a few keywords . I guess this tool checks for the domain on the first 10 pages of Google result.

Malte Landwehr 30 March 2015 - 7:24 am

It says “need to retry” for 90% of keywords I enter. Deleting and reentering them does not seem to help.

Sean Malseed 30 March 2015 - 3:26 pm

Hmm, could you share the sheet you’re using with me? I’ll try to see what’s going on. [email protected]

Sometimes Google is just running slow and and the sheet times out. When this is the case, trying the keywords in smaller batches can get around it.

webraven 26 March 2015 - 9:13 pm

Nice tool. It seems to work really fabulous. However, I can’t seem to verify any of the results at all. As an example, keyword = luxury interior design miami using domain = Result is #48. I know this can vary but I don’t see the result on any of the pages returned after going through all of them.

I was using IE in private mode as well as normal chrome mode.

Any ideas??

Thank you!

1 2 3 4 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