Hey everyone!

For those of you who have checked out our 2016 Local SEO Ranking Factors study, and if you haven’t now is a great time to, then you know that here at Local SEO Guide that we look at a grouping of 3 keywords to represent most local queries. For example, if the client is a dentist in Costa Mesa it would look something like this:

dentist costa mesa
costa mesa dentist

And for those of you that have had to localize top level keywords before you know what a huge, time consuming and manual PITA it can be. Well not anymore!

Local Keyword Generator

In order to streamline this process I developed a Google Sheet’s script that can take a couple of inputs (city and keyword list) and generate a localized set of keywords. I like to call it…


This tool is really simple to use:

  1. Make a copy of the sheet for you to use yourself (don’t ask me for edit access, I’m not going to give it to you)
  2. Put the city you want to localize for (or zip code) in cell A4
  3. Put the keywords you want to localize in A10+
  4. Click the “Generate Keywords” button
  5. Check the new tab that has the localized versions of all your keywords

Simple enough right? Now you can spend time doing keyword research instead of localizing your keywords lists!

Share This Story!

About Author

12 Response Comments

  • MiriamEllis  August 11, 2016 at 1:51 pm

    Well, isn’t that nifty! Thanks for creating this guys. Worthy of sharing.

    • Dan Leibson  August 11, 2016 at 1:53 pm

      Thanks Miram!

  • EricRohrback  August 12, 2016 at 5:27 am

    Great idea guys! This is a nice time saver. What other google sheet/spreadsheet ideas do you have in the works?

    • Dan Leibson  August 12, 2016 at 6:34 am

      Stuff, and things! 😉

  • Gerry A Foster  August 15, 2016 at 6:23 am

    Dan…the generate button says I need permission?!? Can’t I just tell it that I know you and such?

    Nice job though. You are a saint.

    • Dan Leibson  August 15, 2016 at 7:38 am

      Rule #1 Gerry 😉

      “Make a copy of the sheet for you to use yourself (don’t ask me for edit access, I’m not going to give it to you)”

  • Ben Wright  August 17, 2016 at 10:02 am

    Cool little tool. Thanks for sharing! Copied and saved to my Drive.

    • Dan Leibson  August 17, 2016 at 10:06 am

      Glad you dig it Ben!

  • Geoff Todd  August 23, 2016 at 4:11 am

    Sweet! That is really useful. Thanks Ben!

  • Mike  March 23, 2017 at 2:38 am

    Hi Dan,
    I made a cope of the sheet. However, when I insert keywords and city’s and click the Generate keywords script it displays this – Script function generateKeywords could not be found.

  • Neil Cheesman  March 24, 2017 at 10:10 am

    Downloaded the spreadsheet but it doesn’t work… the ‘Generate’ button seems to be disabled…

  • Neil  March 24, 2017 at 10:13 am

    Sorry – sorted! Great tool 🙂