Technical

International Keyword Research
with Grepwords &
SEOgadget for Excel

by on 2nd October 2014

The Grepwords API is a powerful, fast endpoint for keyword search volume collection.

For a long time, its output was for US and “global” search volumes only, but that all changed thanks to Russ and his team. Now we have search volumes from Google in around 32 countries. SEOgadget for Excel supports these new locations with just a simple change to your query syntax.

A quick primer on keyword research with Grepwords

Working with Grepwords and SEOgadget for Excel is easy – follow this introductory video for a quick primer:

What’s the change?

It’s a really simple addition to the same syntax you’re already using. There’s no need to update your installation, although I’d advise you to check and make sure you’re using the latest distribution (we’ve fixed some issues with Moz). You just add one of the country names listed in the 5th argument, just like this:

Or, if you’d like to fetch search volumes for a list of keywords in a range of cells:

Notice I’ve referred to a table called #grepwordslookup. Using the [#All] character at the beginning of the table name stops the table moving every time you refresh the formula. Handy.

Obviously, “canada” is but one location. Here’s the full list:

CountryAPI parameterKeywords
Brazilbrazil3,297,256
Bulgariabulgaria465,080
Canadacanada8,841,539
China (simplified)china_simplified665,401
China (traditional)china_traditional611,844
Finlandfinland751,213
Germanygermany6,007,999
Greecegreece315,796
Hungaryhungary378,640
Indiaindia5,333,614
Irelandireland4,050,076
Israelisrael432,298
Italyitaly4,473,976
Japanjapan1,962,432
Mexicomexico4,883,220
Netherlandsnetherlands693,626
New Zelandnewzealand2,489,884
Norwaynorway221,620
Polandpoland1,481,989
Portugalportugal1,716,764
Romaniaromania566,095
Russiarussia2,180,883
South Africasouth_africa2,559,010
South Koreasouth_korea254,535
Spainspain4,661,185
Swedensweden521,601
Turkeyturkey1,625,199
United Kingdomunited_kingdom11,392,439
United Statesus90,000,000+

Enjoy having a little more flexibility in your keyword research! Remember, you can take a closer look at SEOgadget for Excel.

Responses

  1. I downloaded and just a test … I’m curious as to SEOgadget works…

Comments are closed.

Join the Inner Circle

Stay one step ahead of the competition by staying with us. Join the Inner Circle to receive a monthly update of Organic Digital marketing resources, blogs and industry news.

Get insights straight to your inbox

Stay one step ahead of the competition with our monthly Inner Circle email full of resources, industry developments and opinions from around the web.