Free Keyword Position Rank Checker Tool

by Jaco
594 comments

Search engine keyword position and rank tracking has never been so easy or free. Use and share this free SEO tool as you wish.

There is a new RankTank keyword position and rank tracking tool which is also available in a limited free version.

The RankTank Google Sheet Add-on, is an improvement over the legacy tool below and comes with many enhancements including the ability to automatically re-scan failed keywords.

Free keyword position rank checker google sheet addon

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 so you don’t 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. The position tool 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.

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!

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

Where do I rank on Google?

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, but 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 that’s totally free! Automate keyword ranking reports, track and set alerts on Google position changes, and get a full understanding of what keywords you do rank for on Google – and where – totally free!

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 or selecting “Reset” and “Run” again to re-scan all keywords. Alternatively 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.) and pull back all of the Google 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.

This 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 which 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.

SEMrush

Leave a Comment

594 comments

Free Rank Tracking Tools – A Complete List for 2020 | Press App 2 July 2020 - 8:19 pm

[…] RankTank Google Sheets AddOn – Never tried it but looks interesting. Maybe not for automated tracking but if you just need to check your rankings once every few days/weeks and prefer to have your data saved into your Google Sheets it might be worth giving it a try. […]

Reply
Rijan Ghimire 29 June 2020 - 10:50 am

I think this app is Very nice

Reply
Md Gulam Rabbi 25 June 2020 - 1:14 pm

Thanks for the great tools

Reply
Osama Almasri 21 June 2020 - 2:53 pm

Thank you for all of these free SEO tools ….

Reply
Free Rank Tracking Tools – A Complete List for 2020 – NicheScanner 20 June 2020 - 7:08 am

[…] RankTank Google Sheets AddOn – Never tried it but looks interesting. Maybe not for automated tracking but if you just need to check your rankings once every few days/weeks and prefer to have your data saved into your Google Sheets it might be worth giving it a try. […]

Reply
Abdelrahman Ahmed 17 June 2020 - 9:00 am

Thanks for the great tools

Reply
mydigistock 12 June 2020 - 5:28 pm

Thank you. This tool is very helpful.

Reply
seekkr pk 2 June 2020 - 2:00 am

This is a great blog to look at SEO performance. Thanks to the one who made me learn so much from this information.

Reply
tnpsc rock 26 May 2020 - 12:45 pm

nice tool very usefull to seo

Reply
aysha sweet 20 May 2020 - 2:17 am

Thank you so mutch for sharing free tools

Reply
Nishant 8 May 2020 - 7:40 am

This is just amazing. Thanks for sharing for free 🙂

Reply
Favour Cohray 1 May 2020 - 8:08 am

Actually, this tool is very nice

Reply
Etisalat Internet Plans 29 April 2020 - 9:57 am

I want to check my rank in google for my website but there are multiple tools available in google that tell me about ranking, some off them shows me in top 100 or some are not what should i do now?

Reply
Sad poetry 21 April 2020 - 10:14 am

Awesome I personally realy liked this tool

Reply
Natalie 20 April 2020 - 8:53 pm

First off I would like to say this is awesome! I have been looking for a method to check my rankings as much as I would like without getting banned by Google. I do have one question for you though. Is there anyway to have the rankings only pull for my domain? I have a few keywords that are showing up with the ranking and ranking URL for walmart or amazon. Granted they are my products but I would like to just have only my domain itself. Other than that this tool is epic. Thanks Again

Reply
iConnectX 20 April 2020 - 6:59 am

Very Useful tool for searching many keywords. I usually search many types of nonprofit fundraising keywords. This tool helps me a lot.

Reply
Jeniffer 16 April 2020 - 5:04 am

This tool is no doubt a neat and clean tool with very accurate result.

For the free legacy version, I wanted to know exactly what are the limits?
I see somewhere 1000 KW. What does that mean?

1. Can I fetch as many KW ranks ( within 1000) as I want or
2. Total rank fetch is 1000?
3. What will happen after that?
4. In case fetch is attempted after 1000, will it block the ranking domain? Will the block go off after some time or it is prermanent?

Reply
Jaco 16 April 2020 - 7:17 am

Hi Jeniffer

1. You can fetch 1000 SERPs for any amount of domains/keywords.
2. Total fetch per month is 1000 on the free sheet.
3. You will get a limit exceeded message after this.
4. Your limit resets on the 1st of the new month for the legacy sheet and 30 days from signing up on the add-on.

Reply
Jeniffer 17 April 2020 - 11:59 am

Thank you, @Jaco for the pointed replies.

Reply
Jaco 15 April 2020 - 10:32 am

–===–
RankTank Legacy Google Sheet v.30 Released

– Supports up to 1000 keywords in the sheet.
– 1000 free scans per month.
– Desktop and mobile user agent support.

–===–
RankTank Google Sheet Add-on v.20 Released

– Supports unlimited keywords in the sheet.
– 1000 free scans per month.
– Desktop and mobile user agent support.

Reply
sandeep 14 April 2020 - 1:04 pm

RankTank is very good. i liked it.

Reply
Fotograf Aalborg 13 April 2020 - 9:04 pm

Just wondering, how do I manage multiple websites in one sheet?

Reply
Jaco 14 April 2020 - 9:14 am

You would need to make a copy of the sheet for each domain, or you can look at using the new Google Sheet addon which will support a new tab for each domain, language or locale configuration.

Reply
11 Top Free SERP Tools That Track Your Keyword Rankings 13 April 2020 - 6:18 pm

[…] 1. Rank Tank […]

Reply
Namaste Technology 7 April 2020 - 7:19 am

This is a very nice tool and I like it. It is very simple and easy to use.

Reply
Jaco 2 April 2020 - 6:34 pm

I’ve released v30 of the free keyword position tool. The new version now supports up to 1000 keywords in the sheet (as scan limits are imposed for free users) and also includes support for desktop and mobile device rankings. Let me know what you think and stay safe.

Reply
Dilip 30 March 2020 - 4:08 am

this could be extremely helpful. Yet, for me, it just continues saying “need to retry” when I include my watchwords. In any case, possibly I am accomplishing something incorrectly.

Reply
Jaco 2 April 2020 - 6:32 pm

Hit me up on Twitter with your domain and share your sheet or a screenshot and I’ll help out.

Reply
Sara Taylor 27 March 2020 - 3:31 pm

its really nice and working tool thank you admin

Reply
Sara Khan 25 March 2020 - 9:18 am

when a Google Sheet grabs a URL, it does it from a Google internal IP address and not yours. It’s really awesome

Reply
Fajad Ali Shah 21 March 2020 - 11:50 am

its really work for me.

Reply
Shihab 18 March 2020 - 9:06 am

I could get a copy of that spreadsheet you created? I’ve been looking for that type of tool for automated analysis. Thank you!

Reply
Jaco 12 March 2020 - 11:40 am

Remember to try the new RankTank Google Sheet Add-on: https://docs.ranktank.net/ranktank_google_sheet_add-on.

It features automated retries and improved scan credit management. We are therefore also offer 1000 scan credits per month to all users.

Reply
RESET KEY 12 March 2020 - 11:35 am

Complletely Perfet SEO Tools, But Expensive for Some User , Specially Me . I wish Will You Give Some Opportunity

Reply
Bitwissend 10 March 2020 - 6:51 am

Awesome tools. Thanks for sharing

Reply
The UK Solicitor 5 March 2020 - 5:43 pm

I Really loved this tool, thank a lot for adding awesome stuff to your site, it helped me a lot to find mine niche relevant keywords

Reply
Akash 19 February 2020 - 10:32 am

Hey there, this is a amazing tool and I want to purchase it for my website and also I have many site. What’s the price.

Reply
pat 12 February 2020 - 3:24 pm

Great tool

Reply
Radu 10 February 2020 - 12:03 pm

This is indeed a very useful Google rank tracker. Congrats on the effort.

Reply
Jaco 8 February 2020 - 3:12 pm

You only need to consider upgrading to version 28 if you experienced issues with keyword branded domains being detected as ranking incorrectly. For example: domains containing your domain name as keyword showed as ranking for your keyword instead of your own domain.

Reply
sohanobgyn 31 January 2020 - 1:23 pm

I need to know is this a paid tool or a free tool as i am having issues in finding a suitable free tool for keyword rank checking.

Reply
Jaco 3 February 2020 - 2:24 pm

We now allow for 1000 free scans per domain per month. Limits reset every month.

Reply
Evgeni 14 January 2020 - 8:58 pm

personally google planner does it.

Reply
Jaco 15 January 2020 - 7:09 am

I don’t get it, how does Google planner show you in real-time where your domain ranks for specific keywords and phrases?

Reply
Ascent World 10 January 2020 - 9:04 am

Great tool, I would like to say this is awesome! I have been looking for a method to check my rankings as much as I would like without getting banned by Google. I do have one question for you though.

Reply
fakera 21 December 2019 - 9:18 pm

When a keyword gets stuck, simply copy it, delete it, and paste it back in the cell. This will force the keyword to crawl again.

Reply
Ali Raza 16 December 2019 - 10:07 am

it’s free or paid tool?

Reply
Jaco 18 December 2019 - 11:52 am

This tool is free with limitations on how many times a free domain can be scanned.

Reply
David 14 December 2019 - 7:22 am

For several days, although I have updated version 27, it does not work. All keywords indicate the option to buy the pro version

Reply
Jaco 14 December 2019 - 8:07 am

We’re currently limiting free use due to Google limitations, this should again improve over time.

Reply
Mary 18 December 2019 - 11:24 am

I am using paid version but it still takes slower and return https://mydomain/google-rate-limiting-your-account-try-again-later. Please resolve it

Reply
Jaco 18 December 2019 - 11:52 am

Hi Mary, This is a Google limit and not a RankTank limit. It happens to some accounts, we are looking into it and will release an update in the next few days.

Reply
Digitalize Training 12 December 2019 - 3:27 pm

One of the best tool of keyword research, I have ever used.

Reply
Jaco 9 December 2019 - 1:24 pm

I’ve released v27 of the “free” keyword position tool, the new version has much more liberal limits and can again be used for free granted we don’t detect commercial use. Please upgrade to the new version to try it out 😀

Reply
Jaco 10 December 2019 - 8:43 am

Keyword position tool versions prior to 27 will cease working over time so I urge everyone to upgrade at their earliest convenience.

Reply
jayden 3 December 2019 - 9:47 am

Is this tool paid or free yet?

Reply
Jaco 3 December 2019 - 10:06 am

Semi-free with lower limits, the Google keyword rank checker sheet add-on releasing soon will have more liberal limits and would be able to be used free for personal use.

Reply
saleem baloch 29 November 2019 - 4:20 am

I am trying to rank my keyword but It’s not working for me.
Can u help me how I can get rank my blog.

Reply
kishan 23 November 2019 - 6:24 am

When a keyword gets stuck, simply copy it, delete it, and paste it back in the cell. This will force the keyword to crawl again.

Reply
Ali 6 November 2019 - 1:45 pm

Hyyy
I have a problem with the tracker. When I put in the keywords they all just turn to 0 MSV. How come this happens?

Reply
Jaco 13 November 2019 - 12:48 pm

Did you add your SEMrush API key under Settings tab?

Reply
jimmy handris 30 October 2019 - 8:04 am

Try to log out of Google and back in, and then copy, delete and paste the keywords back in. That usually refreshes the IP address that the doc is using.

Reply
Rasadul 25 October 2019 - 11:12 am

Nice, Love it,

Reply
Desert Safari Dubai 22 October 2019 - 11:01 am

I also tried to put some keywords to check their ranking. but i am failed. can you explain the trick one by one.

Reply
Rohit Garg 18 October 2019 - 9:51 am

I am not able to use the sheet as it asks me to upgrade even for 4 keywords. Is this error or a trick?

Reply
Jaco 19 October 2019 - 6:09 am

Please ensure you don’t add a trailing “/” after your domain name. The match is exact.

Reply
Gaurav 17 October 2019 - 4:42 pm

Hi, I added a few keywords, but none of them were crawled successfully. I tried to copy and delete some keywords, but it didn’t help. Do you have any idea why it doesn’t work?
Thanks a lot for an answer! naukrigadget.blogspot.com

Reply
Jaco 18 October 2019 - 7:17 am

Be sure to enter only the TLD (example.com) not https:// or www, also remember to choose “Run” in the dropdown :D.

Reply
Patrick 17 October 2019 - 8:54 am

Hello,

I am using the free tool in a spreadsheet in docs.google.
In a table cell is the following message :
Version 21
UPDATE
CLICK HERE
VERSION 25

When I click on “CLICK HERE” nothing happens
The content of the cell is “=checkForUpdate(internalFunctions!A3,internalFunctions!A5)”

Could you let me know how to update to Version 25 ?

Thnak you in advance for any reply.

Patrick

Reply
Jaco 17 October 2019 - 9:21 am

Hi Patrick, just click the “Open in Google Sheets” button on this page to make a copy of the latest version.

Reply
Best Websites To Check Google Keywords Rankings - WTMatter 16 October 2019 - 8:23 am

[…] Rank Checker Tool by RankTank.org […]

Reply
My Ip To Location 8 October 2019 - 2:25 am

Hi, I added a few keywords, but none of them were crawled successfully. I tried to copy and delete some keywords, but it didn’t help. Do you have any idea why it doesn’t work?
Thanks a lot for an answer!

Reply
Jaco 8 October 2019 - 7:24 am

Hi, you can message me on Twitter and I’ll take a look for you.

Reply
Digitalize Training 4 October 2019 - 1:19 pm

Can you please advice me any free tool to check my 240+ keywords list but please refer me to a tool whose results are acurate

Reply
Emma 1 October 2019 - 11:14 am

Hi.
Once we make the $10 payment, how can we contact you to activate our account?

Reply
Jaco 1 October 2019 - 11:29 am

Hi, you can contact me on Twitter or jaco at ranktank.org via E-mail.

Reply
leon 1 October 2019 - 2:08 am

u have upgrade RankTank Basic -> $10/domain/month via email [email protected] for domain ictsaigon.vn. Please active me

Reply
Jaco 1 October 2019 - 5:56 am

Will send you an email with your key shortly, thanks!

Reply
Lars Hansen 20 September 2019 - 6:06 am

So great

I love it

Reply
Kim Thrane 16 September 2019 - 7:11 am

excellent work

I wish I found this before

Reply
Charles Wessel 13 September 2019 - 2:32 pm

When it’s not free don’t use the word”Free”. It’s misleading and annoying

Reply
Jaco 16 September 2019 - 7:12 am

Hi Charles, we are working on increasing the free limits so soon this tool will effectively be free once more.

Reply
sania mirza 8 September 2019 - 2:20 pm

I also want to check keyword position correctly kindly guide me

Reply
Alex Lp 2 September 2019 - 3:54 pm

Unfortunately, this great free keyword position checker tool is not working anymore, it is not free anymore. I had not been opened any sheet file on Google docs in more than a month, i opened it today, i have only 30 keywords that i wanted to check their positions, and i only get that annoying message again “Upgrade to RankTank Basic -> $10/domain/month ->” so i think you should completely remove the free from the name of this tool, it is obviously not free and a misleading tactic, it’s a pity! time to look for another tool

Reply
Jaco 3 September 2019 - 6:52 am

Hi Alex, we cannot offer this tool completely free anymore as Google made changes that does not allow us to crawl from within Google sheets. Since we’ve all had many years of free usage I don’t think it’s unreasonable to get the same for a small fee to cover crawlers and bandwidth cost.

Reply
pradeep 14 August 2019 - 10:52 am

Keyword position checker for free tool is not working, check it. it is really free tool?

Reply
Roland 6 August 2019 - 2:50 pm

Hi,
I don’t rellay understand what “RankTank Basic -> $10/domain/month” means.
Only one domain, 100Kw per sheet, but I can change Keywords and crawling frequenzie as often as I want to?
Thanks!

Reply
Jaco 8 August 2019 - 7:52 am

Hi Roland, you can change keywords and crawling frequencies for a single domain, your RankTank Basic key allows you to do unlimited scans, but is limited to your chosen domain.

Reply
Mark 6 August 2019 - 2:37 am

Hi Jaco,
i add 28 keywords row but only works for the 3, for all keywords appears
Upgrade to RankTank Basic -> $10/domain/month ->

Reply
Jaco 6 August 2019 - 7:27 am

Hi Mark, that domain must be hitting the free monthly limit, you can share your sheet with me on Twitter and I’ll check if you like?

Reply
Jaco 2 August 2019 - 12:04 pm

The new version 23 of the free keyword position checker tool now supports the ability to save your rankings to a new tab so you don’t lose any historical data when you re-scan. This feature is still in beta so let me know how it works for you.

Reply
LiveStreamRugby 28 July 2019 - 12:01 pm

This is great tool to check your website keywords position in google and it has also many features that increase your knowledge about your domains performance. It’s really awesome and I using it for a couple of months. Thanks.

Reply
Velu 26 July 2019 - 11:14 am

Do you create SEO tool with all the features for us. We are ready to pay for API too. Please let us know Jaco.

Reply
Balvir Singh 24 July 2019 - 11:16 am

Keyword Position Tracker is not working as free in 22 Version and I always used this tool to track my keywords ranking and recommend to many people….but all they are put question…that is not free. Can i know reason behind this why this tool is paid now…..

Reply
Jaco 24 July 2019 - 11:20 am

Hi Balvir, sure, the tool has a free limit now as it’s no longer free to crawl Google. They made changes to block free crawling via sheets, we now ensure we use our own crawlers which have bandwidth and server costs. Please consider supporting our efforts, as we scale we may be able to again offer more free scans.

Reply
SOTA JSC 29 July 2019 - 6:45 am

Dear Jaco,

I bought the license but I’m not getting the RankTank API key. how I can find out it?

Reply
Jaco 29 July 2019 - 6:49 am

RankTank API keys are issued within 24 hours as they take time to activate.

Reply
Keith Brumwell 20 July 2019 - 3:08 pm

Brilliant and exceedingly helpful tool!

Reply
Mac 18 July 2019 - 9:45 pm

Awesome tools.
Thank you for sharing.

Reply
Jim Grayson 16 July 2019 - 7:40 pm

Great stuff! A really awesome tool.

Reply
Suzain 15 July 2019 - 2:48 pm

Hey, Thanks. How can I donate here.

Reply
Radhika 15 July 2019 - 2:43 pm

Nice. Thanks for sharing.

Reply
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?

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

Reply
Mandy 15 July 2019 - 2:43 pm

Great! Thanks for the quick response.

Reply
Gautam Sharma 14 July 2019 - 9:10 am

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

Reply
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!

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

Reply
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 ?

Thanks,

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

Reply
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 !

Reply
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: https://www.ranktank.org/upgrade/

Reply
Adams 26 June 2019 - 1:20 pm

This tool is really useful.. thanks

Reply
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…). 🙂

Reply
Andreas 26 June 2019 - 2:45 pm

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

Reply
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 :)).

Reply
Andreas 1 July 2019 - 5:50 am

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

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

Reply
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”.

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

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

Reply
Raj 4 June 2019 - 5:38 am

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

Reply
Brian Rubin 4 June 2019 - 5:51 pm

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

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

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

Reply
Andreas 13 June 2019 - 9:39 pm

I want to donate. Where can I do that?

Reply
Jaco 14 June 2019 - 6:12 am

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

Reply
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

Reply
Jim 3 June 2019 - 3:14 pm

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

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

Reply
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

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

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

Reply
Jaco 31 May 2019 - 1:34 pm

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

Reply
Sandeep Pattanaik 29 May 2019 - 10:01 am

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

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

Reply
Diamond Susngi 23 July 2019 - 1:17 pm

how to use this thing?

Reply
Jaco 23 July 2019 - 1:26 pm

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

Reply
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!

Reply
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 !

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

Reply
Robert Smith 26 May 2019 - 4:34 pm

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

Reply
Brian Rubin 28 May 2019 - 5:14 pm

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

Reply
Laura 29 May 2019 - 3:30 pm

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

Reply
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”

Reply
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!

Reply
Jaco 23 May 2019 - 1:58 pm

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

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

Reply
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

Reply
Frank Wengerek 21 May 2019 - 8:40 am

Update: Everything ok again!

Reply
Jaco 21 May 2019 - 12:15 pm

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

Reply
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

Reply
Jaco 23 May 2019 - 1:59 pm

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

Reply
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 🙂

Reply
Jaco 15 May 2019 - 8:36 pm

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

Reply
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”}

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

Reply
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”}

Reply
Jaco 13 May 2019 - 1:59 pm

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

Reply
Lulu Won 14 May 2019 - 2:52 pm

<3

Reply
Evasa 15 May 2019 - 7:57 am

Same error. Thanks for working on it!

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

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

Reply
Vishal Tiwari 27 April 2019 - 11:15 am

Best keyword tool.

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

Reply
Manali 11 April 2019 - 6:35 am

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

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

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

Reply
the wordpress 6 April 2019 - 2:42 pm

awesome tool

Reply
strteam 16 March 2019 - 5:07 am

This Tool Working Perfectly

Thanks for sharing this tool 🙂

Reply
Abhishek Jain 14 March 2019 - 6:49 am

Its not working properly.

Reply
Jaco 14 March 2019 - 9:13 am

What is not working, please explain?

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

Reply
Jaco 27 February 2019 - 9:28 am

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

Reply
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

Reply
Jaco 12 May 2019 - 7:59 am

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

Reply
sandeep kumar 27 February 2019 - 4:03 am

Hey Olaf! I just tried it with Google.de tracking Amazon.de. Does it give you an error? What domain did you try to track in Google.de?

Reply
LagartijoRank: tu herramienta SEO gratis y revisable 10 February 2019 - 8:12 pm

[…] RankTank Keyword Position Tracker […]

Reply
afreen 31 January 2019 - 4:26 am

this is so easy to use thank you so much i like it

Reply
Banking 21 January 2019 - 6:03 am

Hello!
Thanks for that Amazon tool. Is there a way to let it check Best -200 search results?
Thanks.

Reply
Jaco 21 January 2019 - 6:06 am

Hi, I think you mean Google tool. You can try the Pro or Elite versions which can do thousands.

Reply
Klein Mendez 14 January 2019 - 6:59 am

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

Reply
Roland 11 January 2019 - 10:37 am

Hello!
Thanks for that great tool. Is there a way to let it check TOP-200 search results?
Thanks.

Reply
Jaco 16 January 2019 - 7:49 am

Hi Roland, yes you would need to look at using the paid for Pro sheet version.

Reply
Cyber Stumble 2 January 2019 - 7:09 am

Thank You So much

Reply
bookmarks manager 18 December 2018 - 5:28 pm

It’s a great tool. It helped me a lot to analyse keywords position for my website.

Reply
John Smith 16 December 2018 - 5:58 am

Great tool. It really helped me a lot.

Reply
Rustum Manzoor 12 December 2018 - 6:27 am

this is very cool

Reply
Muhammad Umair 11 December 2018 - 11:30 am

outstanding tools . thanks for free these tools

Reply
Consultant Marketing 7 December 2018 - 3:50 pm

wow! how you mass querying google without a proxy? cant google block you? or do they see the query coming from a google doc and so let you off. from my experience if i add say 1000 keywords … G will block me.. and give me a captcha to solve. are they dtecting my IP?

Reply
Wijdan Shahid 6 December 2018 - 4:15 pm

Awesome and I will use these keyword position checker tools and will notify you

Reply
Julian F. Christmas 6 December 2018 - 2:55 pm

That is a jolly smart solution to simple rank tracking.

The beauty of this “rank tracker” is that it can be easily integrated into Google Data Studio for client visualisation.

Thanks for sharing this Jaco

Reply
abnehmen ohne sport 2 December 2018 - 2:46 pm

Its really a great tools for check keywords !

Reply
Sandip Routh 29 November 2018 - 7:26 am

Hi nice work keep on doing the nice work

Reply
john 21 November 2018 - 1:04 pm

One of the best tool of keyword research, I found over the internet. Million of thanks to ranktank team.

Reply
Jaco 29 November 2018 - 10:30 am

Thanks John, appreciate the kind words.

Reply
Wijdan Shahid 14 November 2018 - 5:01 pm

This is the best online research tool i have seen and it will make seo more easy. Much Thanks for sharing

Reply
MAHESH 11 November 2018 - 8:10 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 ! Mahesh Dhokale

Reply
Jaco 12 November 2018 - 6:19 am

Specific locations can be checked with the Pro “Local Result Keyword Checker” Tool.

Reply
Amrinder 9 November 2018 - 7:27 am

Its really a great tools for check keywords and help a lot to get rank in Google.

Reply
lista firme 8 November 2018 - 11:57 am

Hi! Awesome tool. Thank you!

Reply
Aayush 4 November 2018 - 12:30 pm

I tried it on my site. Work fine Thanx…

Reply
Cynthia 2 November 2018 - 9:33 am

Hi,

i added some keywords, none of them crawled successfully.

-Cynthia

Reply
Jyoti 31 October 2018 - 1:14 pm

Thanks for sharing the posts. It is really simple to use

Reply
Dananjaya 26 October 2018 - 5:52 pm

Its very easy to use. Copy , paste , i satisfied

Reply
Datacity.dk 14 October 2018 - 5:48 pm

Love your software – Keep up the good work!

Reply
symun roni 13 October 2018 - 1:26 pm

Hi, I added a few keywords, but none of them were crawled successfully. I tried to copy and delete some keywords, but it didn’t help. Do you have any idea why it doesn’t works?

Reply
Anja 12 October 2018 - 3:12 pm

Is there a possibility that a ranking is displayed in the Google Map Pack. This shortcoming would have to be fixed so that the ranking is displayed correctly. Nevertheless, Rank Tank is a great tool.

Reply
Pankaj 10 October 2018 - 1:09 pm

Keyword checker tool is good

Reply
Philip McLeod 9 October 2018 - 4:22 am

hi there is it still possible to get the free rank tank tool that shows the ranking a keyword phrases for A SPECIFIC DOMAIN ????
I have been here for 20 minutes and signed up to two different pages but i am unable to find any download
Regards
Phil

Reply
Jaco 9 October 2018 - 7:24 am

Hi Philip, it sure is, just click on the “Open in Google Sheets” button on the page. Then click on “Make a Copy” to copy the sheet to your own Google account.

Reply
Andre 29 August 2018 - 9:21 am

I entered a few keywords but it still didn’t fit with google search….

Reply
Jaco 30 August 2018 - 1:59 pm

These are live search results and may differ with each request.

Reply
Effat Rubab 25 August 2018 - 9:27 am

Maybe a silly question, but will subdomains come up as well as the main domain under “Ranked URL”? Thanks!

Reply
Jaco 30 August 2018 - 2:02 pm

Yes, they should also show as we match on TLD only.

Reply
Shristhi Mukherjee 15 August 2018 - 8:01 am

It is not showing our website ranking.

Reply
Jaco 15 August 2018 - 9:35 am

Share your sheet with jaco at ranktank.org and I’ll check why.

Reply
Peter Morris 10 August 2018 - 6:18 pm

Awesome tool. thanks for sharing.

Reply
Haresh Chaudhari 7 August 2018 - 12:09 pm

Hi Sean,
Thank for your time to develop such great tool.

Reply
Master topic 7 August 2018 - 9:49 am

Nice ranktank. Thanks for sharing this tool.

Reply
Akashdeep dhillon 31 July 2018 - 5:50 pm

Hii, m getting robots.txt error in search console can help me?

Reply
Rizwan Ali 13 July 2018 - 7:06 am

SEMRUSH is a paid tool. Can you tell me about the free tool?

Reply
ugi 27 December 2018 - 11:23 am

Kwfinder is also one of the best keyword finder tool free for demo use.

Reply
Alaa Abdelsamie 9 July 2018 - 11:55 am

This is by far the most unique tool we have ever come across and will be testing this tool over the course of the coming days. Great work by the way

Reply
Rune Andersen 4 July 2018 - 10:33 am

What an awesome tool! It works perfect!

Reply
Mount Toubkal Trek 20 June 2018 - 10:49 am

Very useful! Thank you.

Reply
Shweta Dubey 19 June 2018 - 7:50 am

great share.. But it showing different rankings than other tools.

Reply
Jaco 19 June 2018 - 8:17 am

Hi Shweta, yes this tool shows real-time keyword ranking, much more accurate than other tools.

Reply
gudtalent 13 June 2018 - 11:35 am

Semrush and Google keyword planner have always been my best tools for getting keyword ideas for link removed.
Thanks for sharing.

Reply
Gaurav kumar 12 June 2018 - 11:25 am

My keyword rank in google page number is 40. How to increase the rankings of my article?

Reply
Digimarkseo 12 June 2018 - 2:58 am

Really good for the keyword position checker.

Reply
kuldeep dogra 31 May 2018 - 10:01 am

does not working

Reply
Jaco 31 May 2018 - 2:18 pm

The new keyword position checker is working correctly. If you have an issue make sure you only enter the TLD without http(s)://.

Reply
sheetal raj 5 June 2018 - 7:50 am

Send me path please

Reply
Immobilier 28 May 2018 - 11:22 am

I tried to check keyword ranking. I am so impressed about rank tank. But it have limitation on the number of keyword rank checker. By the way, thank you for giving the useful information! Have a nice day!

Reply
Jaco 28 May 2018 - 11:34 am

The free sheet has a limit of 100 keywords. The RankTank Pro sheet can accommodate 2K+ real-time tracked keywords for only $149/month, this also includes access to all the RankTank Pro sheets. The Elite account will allow for up to 100K keywords, but you need to contact me directly to discuss this.

Reply
Jaco 24 May 2018 - 8:31 am

Hi Tankers, I’ve released an update for the keyword position tool. The new version is 17, if you experience issues with the old version please update and let me know what you think. 🙂

Reply
Nishad 24 May 2018 - 11:35 am

the sheet only shows the website ranking first on the SERP. It is not showing my website ranking and other columns provided like above and below are not working.

Reply
Jaco 24 May 2018 - 12:29 pm

Please only enter your TLD e.g. domain.com (not http:// or https:// or www).

Reply
Tom 24 May 2018 - 8:13 am

Is Version 16 currently not working?

Reply
Jaco 24 May 2018 - 8:32 am

Released version 17 to resolve Google API issues.

Reply
Tom 24 May 2018 - 8:38 am

Thanks.

Reply
flav 24 May 2018 - 6:56 am

I tried the free tool but it does not work since yesterday

Reply
Jaco 24 May 2018 - 8:33 am

Thanks for pointing this out. Grab the new version and enjoy!

Reply
Jacob 20 May 2018 - 9:20 pm

Thank you! Really an awesome tool! Worked flawless first time!

Reply
carolin 14 May 2018 - 11:00 am

hey i have asuggestion for you. why dont you use moz api for keywords? it will make work much easier
i was searching for “best demat accounts” for the domain http://bestdemataccounts.com/ but not able to found it anywhere and the competitor sites showed me the keyword position

Reply
kuldeep dogra 9 May 2018 - 6:10 am

Best keyword tool

Reply
Tony 5 May 2018 - 7:00 pm

Hi there,
This looks like a fantastic tool, and I’m sure it is! However, are there any instructions anywhere? As soon as I plucked in my first url to track my position, the rest of the data in that column disappeared. Do I need to get an API key from Semrush as a prerequisite to use this tool??
Please help…

Reply
Fernanda Laura 1 May 2018 - 1:38 pm

I loved this tool!!!

Reply
Emil 8 May 2018 - 10:01 am

It’s incredible, it’s smart and fast, it tracks the position right away!
Lately i’ve notticed a few of Need to retry in the Live Rank column, but it’s very OK overall!
Congrats for this awesome tools!

Reply
Rene 28 April 2018 - 5:41 am

hey sean. thank you for this tool. In the latest version (15) i only get “not ranked” no matter what i try (setting google german language deutsch). version 13 still works though. any idea why this happens?

Reply
Jaco 28 April 2018 - 7:53 am

Hi Rene, looks like Google made changes then realised their mistake and reverted them. I have now defensively coded v16 to take into account both types of result sets. Please try and let me know if this resolves your issue?

Reply
rene 1 May 2018 - 7:36 pm

hi jaco, thank you for the update! now it seems to work. i will notice you if this changes. 🙂

Reply
Jaco 25 April 2018 - 2:28 pm

I released version 15 of the keyword position checker to take into account the latest Google changes. The sheet now works better than ever 🙂

Reply
Onur 26 April 2018 - 6:42 am

Works like a charm!

Reply
Jaco 26 April 2018 - 9:25 am

🙂

Reply
Jaco 24 April 2018 - 10:26 am

Hi Guys, it looks like Google made some API changes which is causing the keyword position checker to fail. I’m currently look to release v14 with a workaround for the problem. Please be patient as we’re working on it.

Reply
Jaco 24 April 2018 - 12:19 pm

I added version 14 as a *beta* fix making use of a proxy to fetch the result data. This may result in limiting from Google or even blocking so please keep me posted on how it’s working.

Reply
Thomas 24 April 2018 - 2:00 pm

v14 version doesn’t work for me. Get an error “{“message”:”Empty JSON string”,”name”:”SyntaxError”,”fileName”:”RankTank_GoogleTricks”,”lineNumber”:49,”stack”:”\tat RankTank_GoogleTricks:49 (getRank)\n”}”

Reply
Onur 25 April 2018 - 12:27 pm

same here

Reply
VB Easy 24 April 2018 - 1:02 pm

Hello, can you please share with us latest version link once you are implemented, Thanks 🙂

Reply
Guillermo V. 24 April 2018 - 6:56 pm

awesome Jaco
youre the best
i was wondering why my ranktank was not working
thank you soo much!

Reply
Bekky 24 April 2018 - 9:07 am

Hey suddenly rank tank shows that my site doesnt rank anymore to no keyword at all. But if i google them, I can still find my site. What could be the reason for it? Is there a bug in ranktank? Or do I have a problem with my site?

Reply
Techcrunch 9 April 2018 - 5:04 pm

Very useful site

Reply
Adithya 16 March 2018 - 4:47 pm

Thanks for providing me an amazing tool

Reply
Rune Breinholt 13 March 2018 - 9:07 am

Thanks for the software update! Maybe one of the best SEO tool 🙂

Reply
Leo 9 March 2018 - 3:27 am

Is there a way to track the ranking for a specific landing page with this tool?

Reply
Jaco 9 March 2018 - 8:51 am

Hi Leo, the free keyword position tracker currently only tracks domain, but this can be a future addition.

Reply
Leo 11 March 2018 - 5:25 pm

It would be amazing actually. Please let us know when it’s ready 😉

Reply
Andy 2 March 2018 - 5:59 pm

How/where do I edit region to get local (city) results?

Reply
Mark Alexander 1 March 2018 - 2:30 pm

One of the best free Google keyword position checker tools out there!

Reply
alamin sojjon 10 February 2018 - 11:04 am

great tool. thanks

Reply
Fami Julia 4 February 2018 - 4:41 pm

Hello dear
thanks for suggesting the best keyword position checker tool. However, I have a keyword and it was 3 position on the first page. It was still 2 month. After two months my keyword showing 1 position on the first page without any additional work or SEO. Now I have a question that what kinds of SEO worked behind of this result?

Reply
Kids Fun 3 February 2018 - 7:17 pm

It’s a awesome SEO tool for us. Thank you.

Reply
explain 16 December 2017 - 12:05 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.

Reply
shayna 13 December 2017 - 2:37 pm

thanks for this very good tool

Reply
Bikram 23 November 2017 - 3:10 am

very good tools i am using it for 3 week.Hope to see new feature soon.

Reply
Jaco 8 November 2017 - 12:06 pm

I found a locale issue after a Google November 2017 update. For this I used a new hack in sheet v13. Grab it and let me know your feedback. 😛

Reply
Alex 8 November 2017 - 3:56 pm

so i have to open new sheets and add all the keywords, can i update the older sheets?

Reply
Jaco 22 November 2017 - 1:28 pm

You have to load up the new sheet Alex.

Reply
Jaco 1 November 2017 - 10:51 am

Just added a new version 12 of this tool as Google API rankings we’re varying greatly on each sheet load.

Reply
Jaco 30 October 2017 - 10:24 am

New awesome version of the Free Google Keywords Rank Checker Tool sheet (version 11) now available with many improvements including better updating, faster responses and revised links. Click “Open in Google Sheets” to get it now.

Reply
annonces 14 October 2017 - 1:42 am

thank you for this tool very helpful for me

Reply
Infochola solutions 25 September 2017 - 6:47 am

Its Just awesome. Fastest tool. Thanks for sharing!

—-
Editor, Infochola

Reply
makanaki 9 September 2017 - 8:08 pm

best keyword research tool

Reply
Greek Directory 29 August 2017 - 7:37 am

Fantastic work, also the tools are very helpful.

Reply
apksecurity 26 August 2017 - 5:24 pm

Your tools are awesome.
Thanks for great contribution to seo community.

Reply
Rizwan Ali 25 August 2017 - 2:33 pm

Do you not have your own keywords research tool?

Reply
Shivani Bhatt 24 August 2017 - 6:22 am

Such a best tool to check your serp thanks admin for it.. .. thanks

Reply
Jaco 12 July 2017 - 12:36 pm

Hi Guys, I have released a new version of this sheet (version 10) with many improvements including speed enhancements, a fix for with or without www and com.br domains. 😛

Reply
Andrew 14 July 2017 - 2:17 pm

I’m still having an issue with Not Ranked showing for every domain I enter.

Reply
Jaco 16 July 2017 - 10:42 am

Hi Andrew, please do try from a different Google account and keep me posted if this works!

Reply
Hillary Patin 18 July 2017 - 10:50 pm

I am also having this issue. Even when I have a domain under “Your Domain” that is also showing as “Who ranks number one?,” it shows “not ranked” under “Ranked URL” and ” – ” under “Rank.” Obviously it’s ranked if it’s ranked number one…

I’ve tried different Google accounts.

Please help!

Reply
Jaco 19 July 2017 - 6:48 am

Hi Hillary, please share your sheet with me via twitter or jaco at RankTank.

Reply
Lucas 11 July 2017 - 1:17 pm

I’m having a issue trying to use this tools in two of my domains. It shows me ‘not ranked’, but when i look at the SERP, its ranked. Can you help me?

Reply
Jaco 11 July 2017 - 8:20 pm

Hi Lucas, there is a bug with .com.br will look into this!

Reply
Jaco 12 July 2017 - 11:21 am

Hi Lucas, this has been corrected.

Reply
Theis 10 July 2017 - 6:18 pm

This is awesome. Thank you so much!

Reply
Harry 30 June 2017 - 5:59 am

hi Jaco,

sorry for noob question, but where is the tool for keyword ranking. I landed on this page but i see nothing

Reply
harry 30 June 2017 - 6:11 am

just knew, it is on the google sheet !!! I thought it would be like a software or something.. . Great job.

Reply
Jaco 30 June 2017 - 11:40 am

Thanks Harry, glad you found it 🙂

Reply
Aman Potlia 28 June 2017 - 3:50 pm

Its really a great tools for check keywords and help a lot to get rank in Google.

Reply
Atalantic 28 June 2017 - 10:24 am

Great tool,
Easy to use and very useful to follow your keywords

Reply
Prosperity Kenneth 18 June 2017 - 7:33 am

It is working very fine; some of my keywords though were not crawled successfully but this tool is pretty much better and great compared to others I have used before.

Reply
tuanqb 15 June 2017 - 5:59 pm

A free copy to see progress and testing is not used. I want to use before see how new results decide to buy pro

Reply
Kristi Ambrose 1 June 2017 - 3:46 am

I have dealt with a LOT and I mean a lot of keyword position tools. Almost all of them are wrong placement lol. SMH. I don’t know how these companies get people to pay $40, $100, $500 for their software and then the software SUCKS. I used Rank Tank a few weeks ago; easy to set up, free, and what can I say its freaking correct on the placement all damn day every damn day lol. Plus, I asked Jaco a question (albeit stupid lol) on Twitter and he answered pretty damn quickly. So ya. I will never buy another keyword rank checker as long as Rank Tank is available! :o)

Reply
Sanaya 19 May 2017 - 9:54 am

Can this tool provide a regular ranking update?

Reply
Mythdk 15 May 2017 - 8:16 am

Excellent site!! I have a question: How do i know which are the right positions ?

Reply
Free Recommended Keyword Ranking Tool - Rocio del Moral 13 May 2017 - 1:38 am

[…] RankTank is an open source tool for SEOs. In fact, they brag about having over 10 million users. They have great learning materials, spreadsheets, and other tools for free. But the one tool that really got my attention was their Rank Checker Tool. […]

Reply
Jaco 12 May 2017 - 1:57 pm

The keyword position tracker with row limits removed can be found as a “Pro Sheet”. You can also check the Monthly Keyword Tracking sheet for those who are looking to maintain ranking history using SEMrush API.

Reply
phann son 11 May 2017 - 3:35 pm

Awesome Tracker, but I can’t get it to work with google.de ?
Any help would be greatly appreciated : )

Reply
Jaco 12 May 2017 - 6:48 am

Hi, share your sheet with me and I’ll check 😉

Reply
Anirudh Pulikonda 9 May 2017 - 2:48 pm

Only 110 Keywords are showing the ranking details. More than that are not working. Also, how can I sort it by ranking? Please help

Reply
Roland 5 May 2017 - 3:14 pm

Hi and thanks for that great tool.
But I do not understand – where is the code?
How can I have a look inside code to modify?
Thanks and regards
Roland

Reply
Ana 2 May 2017 - 2:36 pm

I would like to know if the tool is broken. I check a lot of keywords last month, and most of them had good rankings. And now the tool says that the entire list of keywords is not ranked. How is that possible? Would appreciate your help.

Thank you, Ana.

Reply
Jaco 3 May 2017 - 1:22 pm

Not that I am aware of, please share your sheet with me and I’ll take a look 🙂

Reply
http://www.zarszerviz24.eu/ajto-zarcsere.html 23 April 2017 - 9:44 pm

It seems the tool is broken. It’s crawling forever for all my keywords and for several different domains. I’ve also tried your tool again (Open The Tool Here) but same result. Hopefully you can soon fix it again because it’s d*mn usefull !!

Reply
Jaco 24 April 2017 - 7:10 am

I am not experiencing the same issue. Please share a link to your sheet in a tweet to me or mail me a few screenshots.

Reply
mustakin sarker 20 April 2017 - 2:12 pm

Hi jaco,
Your tools is so easy to use but the tools using some problem. please correction it.

Reply
Jaco 21 April 2017 - 8:19 am

Hi mustakin, tweet or mail me through a list of issues.

Reply
Rameez Ul Haq 17 April 2017 - 9:31 am

Hi,

I am using this tool for a year now but for last two months I am facing issue, It is showing “not ranked” for some keywords which are ranked on 2nd or 3rd page. Although I track 60+ keywords at a time and it takes only 15 minutes to update ranks for all.

It is highly recommended and a huge request from the community to offer a premium version of this tool that can track keywords for multiple projects and an option to maintain record and export reports.

Reply
Jaco 18 April 2017 - 11:36 am

Hi Rameez, we are working on this with RankTank.Pro.

Reply
Amit 8 April 2017 - 6:10 am

I just added 2 keywords one of which rank on Google at #22 and second was the domain it self. But both of them show not ranked. How is it possible when my site is ranking in google at #22 for keyword and #1 for domain it self. Why the ranking is not shown.

Reply
Jaco 10 April 2017 - 7:07 am

Hi Amit, please ensure you are only entering the TLD without http(s) or www.

Reply
tommy 9 March 2017 - 2:20 pm

Can delete my comment…just saw the tweet reply. Looking forward to pro version.

Reply
Jaco 7 March 2017 - 5:14 pm

Hi Guys, I released version 9 of the Free Google Keywords Rank Checker Tool. It now respects language and regional data in API requests. Thanks to @_ThisChris_ for pointing out my oversight.

Reply
tommy 9 March 2017 - 2:12 pm

Hi, is there a limit to 100 kws (mine stop at row 111)? I am dragging down the cells but its blank. Any help would be greatly appreciated and would be happy to paypal donate to help keep this tool kickin’.

Reply
Alan 24 February 2017 - 7:23 pm

Been using Rank Tank for a while to check my keyword ranking. Last few times though that i have been in it has all my keywords as not ranked. Even though if I go to google and use those same keywords I can see I am #1.

google.ca
shop.skitakhut.com

Reply
Benji 22 February 2017 - 12:12 am

Thanks for keeping this great tool free and up-to-date. Unfortunately, I can’t get it to work past row 110. Any ideas?

Reply
Jaco 7 March 2017 - 5:16 pm

Hi Benji, as discussed I will release RankTank.Pro soon which will address current limitations as well as providing awesome managed SEO solutions.

Reply
MUKESH MAJUMDER 9 February 2017 - 2:49 pm

One of the best keyword research tool that I ever seen.. thanks this tool…

Reply
Jaco 10 February 2017 - 10:03 am

Thanks Mukesh.

Reply
Anton P 3 February 2017 - 11:49 pm

Jaco,

Yeah, seems like it’s not working anymore. Is there an approximate delivery date on the fix?

You guys are the best! :-*

Thanks!!

Reply
Jaco 5 February 2017 - 12:18 pm

Hey Anton, we have released a new version of the Free Keyword Position Tool and now use a different Google API to obtain results. This should be quicker, more reliable and result in less limitations. 😀

Reply
Anton P 7 February 2017 - 12:55 am

You are amazing! I love you!!

Reply
leanne 1 February 2017 - 12:49 am

hey guys, this doesnt seem to be working anymore which is a shame, is there a problem with it? I’ve tried deleting the keyword and re-entering, also logging out and back in again but getting errors, or just stuck on ‘crawling’

Thanks 🙂

Reply
Jaco 2 February 2017 - 8:13 am

Hi Leanne, we are aware that Google is currently limiting queries via sheets. We are working on a better solution. 🙂

Reply
Faizan 19 January 2017 - 3:17 pm

very great tool i used it so many times thanks for sharing

Reply
Krystian 19 January 2017 - 7:29 am

Might be a great tool, but unfortunately it does not work for me. For some Keywords it sais, it does not rank (but it does on position 1) but most of the keywords are crawling hours for hours and nothing happens. Maybe it doesnt work for Germany?

Reply
Jaco 20 January 2017 - 8:41 am

Hi Krystian, I checked your sheet and removed http://www before your domain. Please only provide the domain name in the sheet. This resolves the issue. 🙂

Reply
Cristian 12 January 2017 - 5:12 pm

Great tool, I had used it for the last month and It worked ok.

But right now I’m getting the following error on almost every keyword: “Failed on CAPTCHA after 5 retries using proxies: 107.178.193.11, 107.178.193.8, 107.178.193.30, 107.178.193.11, 107.178.193.30 (503)”

I tried login out and login in, but it still does not work.

Reply
Jaco 16 January 2017 - 2:02 pm

Hi Cristian, this may happen from time to time as Google chooses. Please allow some time and try again.

Reply
Josiah 11 January 2017 - 12:00 pm

Wow dude … totally impressed that this even exists. Thanks so much for making this available!

Reply
Minecraft Survival Server 25 December 2016 - 11:24 pm

Very nice post, this keyword position checker tool helps me a lot from time to time.

Reply
Jaco 5 December 2016 - 9:03 am

The free keyword position tool now uses a new way to get Google SERP’s and works beautifully. Remember you can use SEMrush $15 API to supercharge the sheet. Enjoy 😛

Reply
Hillary 20 January 2017 - 1:52 am

Hey Jaco! Thanks for the update. Could you please explain the “new way” that this sheet gets rankings, and how location data plays into it?

I noticed a few comments above talk about how the location of the server (California) affected ranking results in the sheet, and I wanted to know if this was still the case. I just want to make sure I’m understanding the data I’m looking at since the data can vary a LOT based on location, user history, etc.

I took a look at the code to see if I could figure it out myself, but I am no coder 🙂

Reply
Jaco 20 January 2017 - 8:28 am

Hi Hillary, the server would not play a role as the data is obtained by crawling country specific Google locales directly as Google itself. The results should be 100% correct based on location.

Reply
Sukhen Tanchangya 31 October 2016 - 10:53 pm

Excellent tools, I was afraid when I get error. Now perfect and exact results showing.

Thanks for creating awesome tool in the web.

Reply
Frederik Larsen 18 October 2016 - 8:18 am

Oh man. I have been looking for at tool like this for so long. Seems like everyone today jumps right onto the business wagon with their software.

Reply
Gayathri 10 October 2016 - 4:34 pm

Nice…. Tool.

Reply
cheree 5 October 2016 - 2:39 am

I have tried using your spreadsheet multiple times to no avail. What is wrong? Your website says you updated it in May 2016. But – It’s still not working.

Reply
Jaco 28 November 2016 - 1:06 pm

Hi Cheree, the spreadsheet is updated and working better than ever!

Reply
juwelier 30 September 2016 - 5:21 pm

hello
Is is possible to check rank for Persian language ?
this website support UTF-8 ?

Juwelier Genk

Reply
Dariusz Jurek 23 September 2016 - 8:02 pm

I love your keyword-position-checker-tool, thanks for sharing.

Reply
lawlaw 16 September 2016 - 3:36 pm

The googlesheet doesn’t work anymore 🙁 It says not ranked for all keywords

Reply
Jaco 29 November 2016 - 11:43 am

This should now be corrected and no longer pose a problem. 🙂

Reply
Pradeep Gupta 16 September 2016 - 6:59 am

I was using older version of ‘keyword position checker tool’ which was superb. But this new version is not working at all. Just showing ‘not ranking’ for any keyword. Even for website name used as keyword.

Can anyone help me in it? any instruction?

Thanks for previous version. Looking for help on new version..

Thanks a lot Rank tank team for their awesome products..

Reply
Jason Aj 14 September 2016 - 8:15 am

Thanks a lot

Reply
We Buy Any Car 8 September 2016 - 3:26 pm

I have added 100 KW but none of them been crawled and i am still waiting for it. Any help would be apperciated.

Reply
Marilie Doman 7 September 2016 - 2:21 pm

Hi there,

RankTank keyword positioning tool isn’t working… it it just me?

Reply
Jaco 29 November 2016 - 11:45 am

Hey Marilie, the tool is working fine for me at the moment.

Reply
frances 1 September 2016 - 6:47 pm

HI again – as a followup to my last question, it seems to be generating an error in all the saved copies:

Error
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col3

#VALUE!

I would love to be able to use this tool as it sounds amazing. Really hope you can help.

Thank you!

Reply
frances 1 September 2016 - 6:45 pm

Hi there, I have made a copy of the spreadsheet in google docs – then logged out and back in – then deleted and repasted the keywords…

I’m still getting no data. It says “not ranking” ….however, that’s not true. I’ve tried it with multiple domains and a variety of keywords with the same results – and I know their current rankings, so “not ranking” is not accurate.

Please help.

Thank you!

Reply
Austin 19 August 2016 - 7:05 pm

I can’t get this to work at all. I update the domain and enter keywords and all it ever returns is Not Ranked. I tried keywords I know I rank for and some blatantly obvious domains and keywords that would rank as well and those appeared the same with Not Ranked. For example, espn.com doesn’t rank for ‘sports’ according to the tool. Do I need to configure something?

Reply
website for sale 18 August 2016 - 4:14 am

i think it’s still working, it just need some updating.

Reply
Jason 13 July 2016 - 2:15 pm

Copied the sheet, inputted my site URL and keywords (no SEMRush API) and the results for all of them are “not ranked” which is not accurate…How do I get the tool to refresh/update the ranks? Or otherwise display what is correct?
Jason

Reply
Jaco 29 November 2016 - 11:51 am

Hi Jason, this should be working fine with the SEMrush API.

Reply
Michael Neal 10 July 2016 - 8:03 pm

I’ve tried this for 2 of my domains with keywords I know I rank top 3 for but it says not ranked. Set for UK. Any ideas?!

Reply
johj45 7 July 2016 - 5:55 pm

Does not work, no results att all even though I have several of them on google page one. 🙁

Reply
Nick 29 June 2016 - 3:59 pm

I continue to receive “not ranked” in a gray color within the tool, can you help diagnose?

Reply
abdmobi 27 June 2016 - 8:16 am

Thanks Jess! I’d love to take a look at an example so I can see what’s going on. What is the domain and search query you’re using

Reply
M 26 May 2016 - 1:35 pm

Does the rank checker us the user’s ip address/locality?

Reply
Bali Tour 25 May 2016 - 12:18 pm

The keyword index google is work 100% keyword

Reply
Randy Garcia 18 May 2016 - 4:11 pm

You guys are amazing, this tool has helped me a ton with finding my domains positions on Google. Thanks.

Reply
Daniel 14 May 2016 - 2:33 am

Hi Sean,
Please clarify if the Semrush API Key is a once-off purchase for $15 or is it $15 per month.
Many Thanks

Reply
David 11 April 2016 - 6:22 pm

Need to retry on all keywords. Even if I download the sheet again the already inserted info is saying need to retry. Deleted multiple times.

Reply
Numbi 11 April 2016 - 4:47 pm

Got also on every keyword “need to retry”. When it works it would be a awesome tool, everyone has a versions that works?

Reply
Inty 11 April 2016 - 12:42 am

Hey, awesome tool, however I can’t get it to work 🙁

Is there any update on this? Thanks!

Reply
Franz 4 April 2016 - 2:36 pm

SEMRush API Key goes for how long?

Reply
altkia 18 March 2016 - 12:15 pm

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.

Reply
nir 16 March 2016 - 12:57 pm

Getting “Need to Retry” on all keywords.

Does this spreadsheet still work?

Nir

Reply
Alex 25 February 2016 - 7:14 pm

i have been getting lot of errors in the keyword position checker, are you still working on it? i know it is a beta version, i just want to know you are working on it to make it better; otherwise, i will have to look for another tool 🙁

http://awesomescreenshot.com/0b85nwbu22

Reply
Vincent 15 February 2016 - 11:43 am

Sean, any update?

Reply
stuart 10 February 2016 - 3:54 am

hey is the tool broken? Ive tried for a while and its hit an miss with google imporXML…

Thanks

Reply
Daniel 4 February 2016 - 7:48 pm

I am getting “Need to Rety” for every keyword. Have tried deleting and pasting back in, logging in and out of Google, changing domains, copying the sheet again. Please let me know if there is anything else I should try.

Reply
Ritchie Pettauer 31 January 2016 - 7:05 pm

You are freaking AWESOME. I’ve been looking for an automated rank tracker for a long while – in fact, your tool works so well that there is no more need for a 3rd party service. Thank you!

Reply
gagan 31 January 2016 - 4:32 pm

hi can you please make a sheet for find bulk urls (backlinks) in google indexed or not … just paste links and it will show the result the url indexed or not in google … thanks in advance .. sorry for bad english .. waiting for response …

Reply
Jessica G 28 January 2016 - 1:11 pm

I am also getting “Need to Retry” even with one keyword search. Is there any news on this issue? This tool could be amazing! 🙂

Reply
stuart 27 January 2016 - 11:55 pm

Hey guys – been playing with these tools for a while… is there any new restrictions been placed on the importxml from the google results? I am having terrible trouble getting anything to return…. maybe they are blocking me :/

thanks

Reply
Alan 26 January 2016 - 9:07 pm

Not sure it is totally working properly for me. When I click to open it asks if I want to make a copy in google docs – i click copy and I get into the program. All the keywords say is needs to retry – if I copy, delete and paste it back in it says its crawling with however many keywords remaining – but seems to hang up there for ever and I never get a ranking

Reply
Navid 20 January 2016 - 12:51 pm

hello
Is is possible to check rank for Persian language ?
this website support UTF-8 ?

Reply
Bill 19 January 2016 - 7:23 pm

Doesn’t work NO API KEY

Reply
peter 18 January 2016 - 12:06 am

Hi Sean,

Tried to post, but don’t see it so I will repost

I am seeing the “need to retry” on almost every keyword, have deleted, signed out and tried again. Any thoughts?

Thanks for the help and thanks for the tool!

Reply
peter 17 January 2016 - 10:55 pm

Hi Sean, Love the concept and thanks for the tool. However I cannot get it to work getting the “need to retry” every time. I signed off and on again, deleted and re-pasted, etc… Nothing. Any thoughts on how I can get it to work or is there a newer version?

Reply
Roland 15 January 2016 - 2:55 pm

Hi there,
no matter which Keyword I type in, I get allways “Need ty retry” back.
Any Idea why this happens?
Thanks and regards
Roland

Reply
BLAKE 14 January 2016 - 9:41 pm

Are you working out a bug for Keyword Ranker? Other tools work fine but in the Live Rank column on this one it’s always saying “need to retry”. Not just for my keywords but for the Zappos example.

Reply
Jaco 29 November 2016 - 1:24 pm

Hi Blake, this bug has been corrected and the keyword ranker updated to work even better!

Reply
Dirk 8 January 2016 - 12:40 pm

Hi why does it have need a retry error? How do we fix this? thanks

Reply
Jaco 29 November 2016 - 1:27 pm

This was a bug which is now corrected. For improved performance please consider the SEMrush $15 API.

Reply
Ivan 5 January 2016 - 3:52 pm

Bulk Keyword Rank Checker.
Dear Developer,
Was using your Keyword Rank Checker tool for few month and despite few dependencies was very happy.
But suddenly about month ago it stopped working completely.
Despite amount of keywords or internet connection all i get is “Need to Retry” for every single keyword.
Is there any ideas suggestion?

Kindest Regards
Ivan Hulka

Reply
Mika 29 December 2015 - 5:04 pm

hi
actult somehow i delete some rows but now i start from new 1 again and its saying me need to retry for crawl
please help
you made awesome thing

thx

Reply
Najam 27 December 2015 - 5:53 pm

Your tool are really awesome. Thanks

Reply
Madhu S R 26 December 2015 - 11:15 am

As digital marketers, we all know that the right tools can make a big difference. They can increase our efficiency, help us collaborate, and organize everything that’s going on. With the help of these tools, we can do our jobs better.Thanks for developing such an awesome tool.

Reply
jon 23 December 2015 - 1:31 am

Hi Sean this seems really interesting, could you share with me the doc you created please 🙂

Reply
rafa 22 December 2015 - 7:47 pm

Hey,

Is this working with google UK? I tried to run it for mobile non-friendly websites but nothing…

Reply
rafa 22 December 2015 - 7:46 pm

Hey,

Is this not working for google UK? I tried to run it for non-mobile friendly websites but nothing

Reply
jedweb 17 December 2015 - 10:50 pm

Getting “Need to Retry” on all keywords and “No API Key” in the MSV column.

Does this spreadsheet still work?

Reply
طراحی سایت 17 December 2015 - 10:00 am

thanks a lot

Reply
Gerd 16 December 2015 - 10:13 pm

Hey Sean,

I try your spreadsheet, but got everytime “need to retry”. Test different domains and google localizations 🙁
Does Google block your tool?

Gerd

Reply
Patricio 16 December 2015 - 8:06 pm

Hi Sean, I just started using this amazing tool. I set up the semrush api at field 9 but when I add 1, 10, or 25 kwrds for my domain and google.co.cr for Costa Rica it says Need to retry.

Is there any way to fix this… it did not work even if I add google.com

Please advice on this.

Reply
Vincent 15 December 2015 - 10:06 am

Hi Sean, any update on this?

Reply
Alex Stoyanov 13 December 2015 - 11:36 am

Hey,

Really awesome tool. I used it at office to check ~3k keywords and the five random ones I checked for accuracy gave like a 2-3 position discrepancy, which is more than tolerable.
However, I have a weird problem. I can’t get the tool to work on my home computer. Every and any keyword I add to the que times out and says to retry, but no matter how much I retry it never actually crawls it.
I tried the most common troubleshooting steps:
Log out / in from google
Get a new copy of the spreadsheet
Change the website
Try different samples – small and large, even a single keyword
Retried like 10 times to make sure it wont budge

I’m grateful for any help. I really want to keep using this tool for my personal projects as well. Thank and cheers !

Reply
Luca 12 December 2015 - 8:41 am

Hello,
i’m tracking some keywords from google.it and google.com but the only response for different sites and many keywords is the same: Need to Retry

Reply
Karsten Madsen 9 December 2015 - 8:27 pm

Same “Need to retry” error on several documents. One document works fine though. The errors seem quite random. Must be a pain to debug, but please keep us posted 🙂

Reply
Tu Cao 8 December 2015 - 4:35 am

Hello,

I trust that this it best tools, because it is very simple. But it not support for my country (google.com.vn). Now, when i copy your sheet, it is not work. Please check or update.

Reply
Venslice 24 November 2015 - 9:26 am

For me too, I always get “Need to retry” since yesterday (23 Nov 15) from Singapore.

Reply
Dentist australia 24 November 2015 - 7:21 am

I have added only 20 keywords none of them crawled I tried both the ways but didn’t solve. please suggest me the next process

Reply
Tomislav 23 November 2015 - 12:05 pm

Same here, not working since Friday the 20th of November 2015 🙁
Is it a bug or Google stopped it?

Reply
Jorgen 19 November 2015 - 6:19 pm

I am also getting “Need to Retry” on all keywords, I have tried many different Google domains as well. None is working since yesterday.

Reply
suadieuhoa 19 November 2015 - 8:56 am

Great! Keep up good job.

Reply
Brett 18 November 2015 - 4:49 am

I’m also getting the “Need to Retry” every time now. Wasn’t before. Nothing’s changed. Try multiple times to paste in keyword. Re-downloaded your beta 4 also. Is this broken?

Reply
Kim 15 November 2015 - 4:36 pm

Hi Sean,

Thanks for sharring your KW Rank tool.

First i past around 200 KW into the tool and it’s almost work. Then i try with 100 other KW and know a have same issue like Michael. It says “need to retry.”

The Search is in Google.dk

– Can you help / fix it ?

Reply
Essay help 14 November 2015 - 11:58 am

Best rank checker and you make it so easy…

Reply
Czerny Peter 9 November 2015 - 2:50 pm

Hello there,

Supertool I’ve been looking for years after something.
But with me I get no results. For each keyword is:
“Need to retry”
Please help.

Thank you

Reply
Michael 4 November 2015 - 11:40 pm

Hi Sean, awsome tool, thanks for sharing it, I was wondering how to remove the 713 row limit, I’ve tried adding rows but the rows are just blacked out and when i paste the keywords in it won’t check them, also tried changing the ranges but that just screwed it up. hope you can help, Regards
Michael

Reply
krosme 4 November 2015 - 10:29 am

Hey Sean. Really great tool. Unfortunetly, everything worked fine the first 3 days and since, it just keeps saying “need to retry” for every keywords when I open the sheet. Is there anything i can do to change that? My ip is good in the FAQ, i haven’t changed any script. I tried to copy the file, same thing. Tried to delete a lot of keywords from my sheet, no change at all. Maybe is it because i left the sheet opened all day long yesterday? Is there a maximum number of tries? Am i banned in anyway?
Anyway, thanx for your work and your help.

Reply
usun wirusa 29 October 2015 - 4:27 pm

Your tools are really awesome!

Reply
Michael 21 October 2015 - 5:12 pm

Not sure if the tool requires an SEMRush api key, but every keyword I have tried says “need to retry.” I have logged in and out of Google, and have tried to delete and reenter the keywords multiple multiple times. Thoughts?

Reply
Sean Malseed 27 October 2015 - 4:49 pm

Hey Michael! What Google country are you searching on?

Reply
Giuseppe 28 October 2015 - 11:58 am

Hello Sean, and thank you very much for this awesome tool.
I’ve used it happily for some weeks but now, suddenly, it won’t work.
Every keyword displays the “need to retry” message, no matter how many times i cut and paste them, or log out and in into my account.

In addiction, the “need to retry” box promptly appears in like 1 or 2 seconds for all the keywords at the same time, unlike in the past if a keyword failed it took several seconds to give the error message.
So I worried that google changed something in the way these requests are managed to avoid people using such kind of tools.
I’m using google.it.

Have you any idea?

Reply
Vincent 14 October 2015 - 9:22 am

Ey Sean,

Just bought the Semrush API, but I get a lot of “no data” or “#N/A” in cell’s and just 2 correct rows with data (out of 16 keyword rows). Any idea what the problem could be? I have enough credits for the API: 299000.

Thanks for the great tools on your site!

Reply
Vincent 16 October 2015 - 3:15 pm

I guess those keywords have just too low volume

Reply
Attila 12 October 2015 - 9:59 am

Hey Sean,

I just wanted to say thank you for this tool! I’ve been looking for something like this for years!

Thanks again.

Reply
Michael 11 October 2015 - 9:04 am

Hi there,

thanks for developing this tool.
However the localization does not seem to work. For google.com or google.hr i get results, for google.de, google.co.uk, google.fr..I get “Need to retry”.

Any Ideas?

I would love to use this tool.

Michael

Reply
Sean Malseed 12 October 2015 - 12:28 am

Hey Michael, happy to help. Could you share your sheet with me? [email protected]

Reply
Michael 12 October 2015 - 8:54 am

Hi Sean,

thanks für the quick reply.

I tried again in my office today and now it seems to work 🙂

Micael

Reply
Andrew 9 October 2015 - 8:07 pm

When I click the link, I am getting “Sorry, the file you have requested does not exist”…

Reply
Sean Malseed 12 October 2015 - 12:29 am

Whoops, fixed!

Reply
Jorgen 9 October 2015 - 7:46 pm

Google Docs says “file doesn´t exist”, has the file been removed?

Reply
Sean Malseed 12 October 2015 - 12:29 am

Fixed!

Reply
teddy marie 9 October 2015 - 10:21 am

Hi Sean,

As always your tool rocks ^^

I think it can be usefull for others too (to invert the sparkline)

So if you want to see if your ranking growth change your formula like this SPARKLINE(J11:AG11,{“charttype”,”line”;”rtl”,true})

It will invert the sparkline accordingly ^^

Cheers,

Reply
Sean Malseed 9 October 2015 - 12:01 pm

Thanks Teddy!!

Reply
Dan @Write My Essay Service 8 October 2015 - 8:03 am

I think I’m going to try this tool out, looks cool.

Reply
jak usunac 5 October 2015 - 7:30 pm

Awesome tool.

Reply
Sean Malseed 5 October 2015 - 7:54 pm

Thanks Jak!

Reply
Dhwanil 29 September 2015 - 8:21 am

Hi I just tried the tool and it’s awesome.

Some of the keyword positions are not accurate, I think that is due to location set in the google settings. I hope soon you add the location (city/zip) with the tracker.

also is there any limitation on number of keyowords and sites this can track?

I have more than 50 sites with all over 3000 keywords to track daily. any solution?

Thanks and great effort !

Reply
Kyle B 29 September 2015 - 1:33 am

Hey Sean,

Awesome tool… I read through all the comments and saw quite a few mentions of people having issues with “Need to Retry”, but it is happening for the majority of my keywords. Tried posting in smaller batches, but still keep getting the message on a bunch of the keywords. Trying to keep track of around 300 keywords, and if I have to manually copy, delete, paste for each of the ones that don’t work, it will take hours.

Any suggestions? Is there any way to make the doc continue to retry on it’s own until it gives you data? What about a button that retries all the cells that “Need to be Retried?

Appreciate the help.

Reply
Francesco 27 September 2015 - 9:24 pm

To clarify more, I am using “Google.it” as locale engine.

Reply
Francesco 26 September 2015 - 10:52 pm

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!

Reply
Sean Malseed 26 September 2015 - 11:53 pm

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.

Reply
Francesco 27 September 2015 - 9:46 am

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.

Reply
Sean Malseed 27 September 2015 - 1:52 pm

Awesome! Thanks Francesco!

Reply
Francesco 27 September 2015 - 9:21 pm

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.

Francesco 30 September 2015 - 8:50 am

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

Sean Malseed 3 October 2015 - 2:29 am

Dude, thank you so much for figuring that out!

Francesco 26 September 2015 - 10:25 pm

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!

Reply
Mike 20 September 2015 - 11:14 am

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.

Reply
Sean Malseed 20 September 2015 - 11:09 pm

Hey, that’s strange! Could you share your sheet with me? [email protected]

Reply
HC 17 September 2015 - 10:25 pm

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.

Reply
Jack 15 September 2015 - 12:21 pm

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?

Reply
Sean Malseed 22 September 2015 - 4:34 pm

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.

Reply
Jack 23 September 2015 - 12:26 pm

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?

Reply
Sean Malseed 26 September 2015 - 11:55 pm

Since you’re in the UK, you’re probably getting an IP address from a UK data center actually.

Reply
Jorgen 11 September 2015 - 9:47 pm

Thank you! Really an awesome tool! Worked flawless first time!

Reply
Tomislav 11 September 2015 - 4:48 pm

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

Reply
Tomislav 11 September 2015 - 4:56 pm

Ah sry, I deleted the “www.” part and now it works. 🙂

Reply
William 11 September 2015 - 9:32 am

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

Reply
Sean Malseed 22 September 2015 - 4:34 pm

Thanks William! Should be fixed.

Reply
David 10 September 2015 - 9:19 pm

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?

Reply
Sean Malseed 20 September 2015 - 10:10 pm

Hey David! It’s fixed 🙂 Took the IP display out for now, but it’s still using the internal Google IP.

Reply
Mike 10 September 2015 - 12:00 pm

Great tool! Really simplifies keeping up with my keyword rankings

Reply
Sean Malseed 20 September 2015 - 10:09 pm

Thanks Mike! Really means a lot!

Reply
ecchi 8 September 2015 - 12:33 pm

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.

Reply
Sean Malseed 20 September 2015 - 10:08 pm

Thanks! The IP thing is fixed 🙂

Reply
Vino 3 September 2015 - 5:47 am

Thanks for this wonderfull tool

Reply
Thinh 2 September 2015 - 9:53 pm

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?

Reply
Sean Malseed 20 September 2015 - 10:06 pm

Is your SEMrush API key still active? If you share your sheet with me – [email protected] – I’ll be happy to take a look.

Reply
Thinh 2 September 2015 - 3:26 pm

I can’t seem to get this to work for some odd reason.

Reply
Sean Malseed 20 September 2015 - 10:05 pm

Hmm, what’s it doing exactly?

Reply
Alex 1 September 2015 - 3:20 pm

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?

Reply
Sean Malseed 20 September 2015 - 10:02 pm

Hey Alex! It should be working now. Is it working for you? Thanks!

Reply
imran 30 August 2015 - 6:25 pm

friend it is great tool.
but wanted to know why it showing some wrong ranks for keywords.

Reply
Sean Malseed 20 September 2015 - 10:00 pm

Thanks! It’s probably location influence. What bad results are you seeing?

Reply
Haberler 30 August 2015 - 12:06 am

Is there a way to tap into Google’s location info? Thank you.

Reply
Sean Malseed 20 September 2015 - 9:59 pm

Not that I can figure out yet. If you have any ideas I’d love some help with that feature!

Reply
Pavan 28 August 2015 - 12:40 pm

I tried to buy API at SEM Rush but it’s 70$, How can I buy it for 15$.

Reply
Sean Malseed 20 September 2015 - 9:20 pm

Did you try the link in the sheet? It should take you to the $15 page.

Reply
Adam 27 August 2015 - 12:12 pm

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.

Reply
Sean Malseed 20 September 2015 - 9:18 pm

Hey Adam, could you share your sheet with me? I’ll check it out. Share it with [email protected] – thanks!

Reply
Corey Robinson 23 August 2015 - 8:30 pm

So this tool is awesome. But the last two days it keeps reloading and telling me that Safari went down. Any advise?

Reply
Sean Malseed 20 September 2015 - 9:17 pm

Hey Corey! This tool is in a Google sheet, so it shouldn’t be crashing Safari. What version of Safari are you on? Have you tried this on Chrome or Firefox? Thanks!

Reply
DECON 22 August 2015 - 4:21 am

Thanks for sharing it, its a woderful tool..

Reply
abdwap 15 August 2015 - 7:19 pm

Thank You

Reply
RNS SEO: How 52 research networking sites perform on Google, and what that tells us | BioMed 2.0 14 August 2015 - 1:01 pm

[…] looked at search rankings for 24,583 profile pages across 52 different RNS sites, using the RankTank keyword rank checker tool to do bulk […]

Reply
Jordan 13 August 2015 - 10:46 am

Sean, have you found any solution of the issue with http://www.realip.info/api/p/realip.php ?

Reply
jacobo 11 August 2015 - 2:44 pm

The tool is not working since 2 weeks ago :S I think the realip.info is down

Reply
Sean Malseed 20 September 2015 - 9:10 pm

Fixed 🙂

Reply
Nat 11 August 2015 - 8:55 am

Hi, graeat tool and thanks for it! I have an issue….The “IP Used” cell shows an error: “Could not fetch URL: http://www.realip.info/api/p/realip.php” How can I fix it??
Thanks a lot!

Reply
Brett 8 August 2015 - 12:01 am

What’s the highest result number before being listed as “not ranked”?

Reply
Sean Malseed 11 August 2015 - 1:42 pm

It should go up to 100/101 before it says not ranked, depending on SERP structure.

Reply
Brett 7 August 2015 - 11:40 pm

Maybe a silly question, but will subdomains come up as well as the main domain under “Ranked URL”? Thanks!

Reply
Sean Malseed 11 August 2015 - 1:42 pm

Yep!

Reply
PJ 5 August 2015 - 6:43 pm

Hi Sean,

Such an awesome tool, I use it often and have incorporated the data into a lot of other research methods. Today it seems to be stuck. I’ve got about ~500 keywords I’m playing with and I’ve been copying and deleting, then pasting in my keywords, but it’s stopped working, and I still have about 200 keywords I want to run data on. Everything just saying, “crawling”. It’s from a copy I made from Rank Tank today, so it should be the most up to date version. Any help is appreciated. Thanks!

Reply
Sean Malseed 20 September 2015 - 9:09 pm

Hey PJ, did it start working again for you? It should be fixed.

Reply
Matt 5 August 2015 - 4:02 pm

Hey Sean
Nice tool. I am very interested in it. It worked great the first day, but since has given me all sorts of problems… many of which are documented above (i.e. “Need to retry”, “Not Ranked”, etc.). One problem I did not see above is that the “IP Used: field is “#NA, sayin:
“Could not fetch url: http://www.realip.info/api/p/realip.php

I’ve tried all the tricks you recommend above, but still can’t get it to work… (i.e. copying, pasting, loggin out and in, etc.)…
any ideas?
Thanks, Matt

Reply
Sean Malseed 20 September 2015 - 9:09 pm

Hey Matt, it should be fixed. Is it working for you now?

Reply
Andy 31 August 2016 - 6:13 pm

Facing same problem here. All of the keywords showing Not Ranked. Can you please help.

Reply
netanel 4 August 2015 - 6:33 am

Works great for me
Thanks!

Reply
Jeff 30 July 2015 - 8:17 pm

Hello! Love this tool thank you so much for sharing it. I noticed the hidden IP is missing now and I am getting all ‘need to retry” responses. Is this something that can be fixed? Thanks again for sharing, it is awesome.

Reply
Alex 30 July 2015 - 12:47 pm

Hey, thanks for this tool! Have been using it for a while now and it’s great.

But recently it has stopped working? It doesn’t seem to get the Google Internal IP, and wont track anything. I tried making new copies of the file but no luck.

Is it down for the time being?

Thanks, Alex.

Reply
Dave 29 July 2015 - 3:17 pm

Doesn’t seems to be working any more… Google IP is showing as #N/A and all the results Need to Retry and doesn’t work even when delete and try again.

Reply
noman 27 July 2015 - 5:43 pm

Awesome tool. thanks

Reply
Maroc Geek 27 July 2015 - 5:40 pm

I hope I’m wrong… But this stopped working and it doesn’t show anymore the Google’s IP! It shows #N/A instead 🙁

Reply
Sean Malseed 20 September 2015 - 9:06 pm

Sorry about that – it’s fixed! 🙂

Reply
Venkat 24 July 2015 - 7:43 am

Great work! Thank you very much for developing this tool 🙂

Reply
Bob 23 July 2015 - 12:32 pm

Great Tool! Thank You! If I wanted to search as example the results for keywords in the local town of myrtle beach how would i set the Google Localization for doing search as if i were in myrtle beach sc?

Reply
jim 23 July 2015 - 9:19 am

Hi Sean

Your google keyword ranking tool is absolutely amazing; however the last few days it has not worked and I see the error: could not fetch url: http://www.realip.info/api/p/realip.php.

Is this because you are experiencing problems or have I somehow corrupted my copy?

Thanks and best regards

Jim Leary

Reply
Sean Malseed 20 September 2015 - 9:05 pm

Hey Jim, it’s fixed! 🙂

Reply
stefanos 20 July 2015 - 3:26 pm

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

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

Reply
Sean Malseed 19 July 2015 - 9:56 pm

Great idea!

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

Cheers!

Reply
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 🙂

Kudos!

Reply
César 23 June 2015 - 6:55 pm

This is a master piece. ¡Congratulations!

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

Reply
Jay 19 June 2015 - 7:15 pm

This is dope! You are my Hero 😎

Thank You!!!

Reply
Sean Malseed 19 June 2015 - 8:39 pm

Thanks Jay!

Reply
Free Google Keyword Rank Checker Tools for Webmasters • emoo.eu 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 […]

Reply
limon\\fxbonusinfo.com 10 June 2015 - 1:41 pm

Awesome tool. thanks for sharing.

Reply
Sean Malseed 16 June 2015 - 2:47 pm

Thanks!

Reply
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 !

Reply
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 w