Free Keyword Position Rank Checker Tool

by Jaco
669 comments

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.

Free keyword position rank checker google sheet addon

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!

Free keyword position rank checker original 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!
You can also Make a Copy of this Google Sheet SEO tool, help fix and improve it for others.

Get this SEO tool for free!

Click the "Free Download" button below...


Instantly receive a link to access this free SEO tool.

FREE DOWNLOAD

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!

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 “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.

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 @ $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.

Leave a Comment

669 comments

Master batch 28 May 2019 - 4:15 am

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!

Julie 27 May 2019 - 1:31 pm

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 !

Jaco 27 May 2019 - 2:52 pm

Hi Julie, still working on it. Infinite Suggest was down for a pro-longed period, but it should be online again.

Robert Smith 26 May 2019 - 4:34 pm

Looks like the V19 sheet is down, stuck on crawling for all keywords

Brian Rubin 28 May 2019 - 5:14 pm

Same here. Stuck on captcha or crawling for all keywords.

Laura 29 May 2019 - 3:30 pm

Same thing here. Stuck on crawling for all. No captcha shown.

Balvir Singh 26 May 2019 - 4:44 am

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”

Diablo Skerim Belanı 22 May 2019 - 9:52 pm

Hi Jaco,
In results there are more than fifty percent Google Captcha error. Looking forward to see the new version!

Jaco 23 May 2019 - 1:58 pm

We are working on a solution, will let you know as soon as we have it ready.

Jaco 16 May 2019 - 12:08 pm

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. 😀

Frank Wengerek 21 May 2019 - 6:34 am

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

Frank Wengerek 21 May 2019 - 8:40 am

Update: Everything ok again!

Jaco 21 May 2019 - 12:15 pm

Hi Frank, you we’re hitting the Google Apps API limit for your account.

Raj 22 May 2019 - 8:42 am

Hey Jaco, i think it is giving lots captcha than rankings. can you solve or we should wait for new version.😀
Thanks

Jaco 23 May 2019 - 1:59 pm

Not much we can do Raj, we will try improve this in v20.

rOm 15 May 2019 - 8:07 pm

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 🙂

Jaco 15 May 2019 - 8:36 pm

This will work for now but we’ll find a better fix for you soon.

Al 15 May 2019 - 3:12 pm

Hi,

Getting the following error message: {“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}

Jaco 15 May 2019 - 3:14 pm

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.

Lulu Won 13 May 2019 - 1:11 pm

I’m getting this error too!
{“message”:”Unexpected token: u”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:1,”stack”:”\tat RankTank_GoogleTricks:1 (getRank)\n”}

Jaco 13 May 2019 - 1:59 pm

Thanks Lulu, we’re working on a new version to resolve this. Google is limiting sheet queries.

Lulu Won 14 May 2019 - 2:52 pm

<3

Evasa 15 May 2019 - 7:57 am

Same error. Thanks for working on it!

Roland 13 May 2019 - 7:47 am

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.

Using SEO & PPC Insights to Improve Your Digital Marketing Conversions in Both Channels | SEOno 30 April 2019 - 9:16 am

[…] 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 […]

Vishal Tiwari 27 April 2019 - 11:15 am

Best keyword tool.

Flix Expo 19 April 2019 - 8:17 am

This is a excellent stuff for check all keywords position and backlinks source.

Thanks for sharing with us.

Manali 11 April 2019 - 6:35 am

Hey, how many keywords can it crawl for at a time?

Albert 10 April 2019 - 7:05 pm

Does it work like the keyword planner on google? I need this for my websites keywords for my outdoor website.

Yunus Korkmaz 10 April 2019 - 8:46 am

Does it re-scan the rankings every time I open the file? If it is not, what can be done to scan.

the wordpress 6 April 2019 - 2:42 pm

awesome tool

strteam 16 March 2019 - 5:07 am

This Tool Working Perfectly

Thanks for sharing this tool 🙂

Abhishek Jain 14 March 2019 - 6:49 am

Its not working properly.

Jaco 14 March 2019 - 9:13 am

What is not working, please explain?

Jaco 27 February 2019 - 9:25 am

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. 😛

Jaco 27 February 2019 - 9:28 am

Do grab the latest version here (Choose “Make a Copy”)

Raj 12 May 2019 - 7:31 am

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

Jaco 12 May 2019 - 7:59 am

Hi Raj, please hit me up on Twitter or share your sheet with Jaco at RankTank.

1 13 14 15 16 17 23

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