Country Keyword Organizer
Turn one big keyword export into a list per market, so each country team knows what it owns.
About this tool
International keyword research usually ends in one large spreadsheet in which "plumber london", "klempner berlin" and "emergency plumber" all sit together. Before content can be planned, someone has to decide which market each keyword belongs to.
This tool does the first pass. It uses your country column when there is one, finds cities and countries in the keyword text, and recognizes common words in German, French, Spanish and other languages to place language-specific keywords. Keywords that belong to no market are listed separately, and terms that show up in several markets are flagged because each market needs its own page.
Why use this tool
Three ways to place a keyword
Your own column first, then city or country in the text, then the language of the words.
Overlaps flagged
See which keywords compete across markets and need separate localized pages.
Ready for planning
Export all keywords with their market and how it was matched.
How it works
- Paste keywords with an optional country code and monthly search volume.
- List your target markets if you have decided them.
- Review each market tab, check the matches, and export the CSV.