Free Google Keywords Rank Checker Tool

Search engine position tracking has never been so easy or free!

Updated for October 2016!

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. The position tool totally free and built completely into a Google Sheet!

Includes support for the SEMrush $15 API
(not required, adds extra metrics)

Get the tool for free right now!
Step 1:
Step 2:
Get the tool!
Click the button below to open Google Sheets and make a copy!

Current Version: 6

Not sure where to start your keyword research?

Keyword rank monitoring with free & open software

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!

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!

10 Million Marketers Can't Be Wrong!

When you join the RankTank mailing list, you'll be better than 9.9 million of them. You'll also get first access to cool new tools, tutorials and other neat stuff.

SPAM? Naw. Ain't nobody got time for that.

184 thoughts on “Free Keyword Position Tool

      • Really faster than copy/delete/paste : just delete the cell and restore wiht , may be used on multiple cells !

  1. 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?
    Thanks a lot for an answer!

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

  2. Love the rank tracker. Pure awesone.

    Hey I butchered together a couple of scripts in google sheets, you could do a better job. Its a competitive analysis tool using moz api, plus a pulls in google top ten for keywords you suggest then via a couple of formulas lets you know if you are worth going for.

  3. Great tool, Sean!

    Just wondering, how do I manage multiple websites in one sheet? Or I have to create individual file for each website.


  4. 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 for releasing this fro FREE!

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

  6. This is genius. And it actually works. Log in & out of your Google account; paste 200 keywords at a time; get results in 30 seconds; rinse & repeat.

    This tool is a hell of a lot better even than $200+/month cloud reporting tools.

  7. Hi Team,

    Thanks for the awesome tool.

    However, I’m unable to make a copy of this document and run on my PC. Can you please help me here?

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

  9. Hello there.

    I have a problem with the tracker. When I put in the keywords they all just turn to 0 MSV. How come this happens? Ive tried to log out and back in, delete and paste in the keywords again . Same thing happens?

  10. Genius tool! It’s working very well and I’ve been able to implement MOZ API to automatically scrape the Domain Authority of every URL that’s ranked 1st.

    One question I have is….is there anyway to automatically skip a result if its an….. or…. result?


  11. hi,

    First thanks for such a wonderful tool.. none can imagine that this kind of tool could be made.

    o by the way, i have tried your tool (Beta 3 version) many times but

    but it’s not working. i have made a copy then put my domain
    then put the search engine
    then put my keywords
    some time copy them from other sheet
    some time put them manually
    but not showing any result after waiting for 1 – 2 minutes
    just crawling
    in MSV section it shows “No Local Data” for first keyword
    in MSV section it shows “No API Key” for other keywords

    plz help me

    thanks for ur support

  12. Seems like the tools isn’t working anymore. Tested with the older versions I have as well, none of them work. So now I can’t compare the ranking position from earlier. Help! Hope you can find some time to look into this. It is just stuck at “crawling”. It doen’t crawl a single keyword, it is just stuck.

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

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

    Any ideas??

    Thank you!

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

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

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

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

    Thanks for this .

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

  17. Hi Sean,

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

    Is there a workaround?

    Thanks in advance!

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

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

    Thanks again!

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

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

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

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


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

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

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

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

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

    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

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

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

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

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

  30. Hey man, great tool. I’m having some problems when I enter a localized google (, 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

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

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

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

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


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

    • Hey Francesco! The beauty of using Google Sheets is that it doesn’t use your IP address 🙂 It uses an internal Google IP address instead. Sometimes Sheets just goes slow when it needs to make a lot of pulls.

      • Yes, you are perfectly right, my apologizes…now it works again and very well! Thanks!

        PS: I also added conditional rules for background colors! Your tools are really powerful.

      • Sorry Sean, I have again the same issues about “Need to retry”… No data are scraped. I erased and pasted ten times the keywords (also only 1 at time), it does not work for me… It works sporadically only.

      • Well, finally I found the culprit!

        I had some duplicate keywords in my list… that way it does not work and you will get the “Need to Retry” error.

        Now it finally works as it should and it is awesome!

        All the best

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

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

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


  39. Hi there,

    thanks for developing this tool.
    However the localization does not seem to work. For or i get results, for,, get “Need to retry”.

    Any Ideas?

    I would love to use this tool.


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

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

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

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

  44. Hello,

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

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

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

  47. 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 for Costa Rica it says Need to retry.

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

    Please advice on this.

  48. Hey Sean,

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


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

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


Leave a Reply

Your email address will not be published. Required fields are marked *