Map Extract
Free tool

Keyword grouper for messy keyword lists

Paste keywords one per line, optionally with a search volume after a tab or comma. The grouper puts keywords that share a word or a two-word phrase together, adds up the volumes you supplied and leaves the odd ones out in a group called Other.

Runs in your browser. Nothing you enter is uploaded.

Grouping a list

  1. Paste the list

    One keyword per line. If a line ends in a number, separated from the keyword by a tab, comma or semicolon, that number is taken as the volume, so a two-column paste from a spreadsheet works. Exact duplicates are removed.

  2. Choose what to group by

    Shared word groups on single words. Shared two-word phrase is stricter and suits long lists where single words are too broad.

  3. Ignore words that appear everywhere

    Type your town, brand or the main service word if every keyword contains it, separated by commas. Otherwise everything lands in one giant group.

  4. Set the smallest group

    Groups with fewer keywords than this go to Other. Two is the lowest allowed.

  5. Download the result

    The CSV has one row per keyword with its group and volume, ready to sort or filter in Excel.

Example: a York photographer's keyword export

A wedding and family photographer (fictional) exported nine keywords with monthly volumes from a keyword tool. With york ignored and the smallest group set to 2, they fall into three groups and one leftover. Notice that photographer and photography stay apart: the grouper merges plurals, not related words.

Input
wedding photographer york	1300
wedding photographers yorkshire	880
york wedding photography	590
engagement shoot york	140
pre wedding shoot	320
family photographer york	390
newborn photographer york	260
newborn photography prices	210
photo booth hire york	170
Result
photographer (4, 2,830 volume): wedding photographer york, wedding photographers yorkshire, family photographer york, newborn photographer york
photography (2, 800 volume): york wedding photography, newborn photography prices
shoot (2, 460 volume): engagement shoot york, pre wedding shoot
Other: photo booth hire york

How the groups are chosen

Small words such as in, for, near, me, best and cheap are removed first, along with numbers and the words you chose to ignore. Plurals are trimmed so plumbers and plumber count as one. Then the word or phrase shared by the most keywords becomes the first group, those keywords are taken out of the pool, and the counting starts again on what is left. It repeats until no word is shared by enough keywords.

Because each keyword joins only one group, the order matters: in the example, wedding appears in four keywords too, but photographer won first because it tied on count and is the longer word. If you would rather see a wedding group, ignore photographer and run it again.

What to do with each group

Group looks likeUsually means
A service plus placesOne service page, or a service page with area pages if the areas differ
Prices, cost, quotesA pricing section or page; these searchers are close to buying
Questions (how, what, why)A guide or FAQ rather than a sales page
OtherCheck by hand: some are noise, some are a new service idea

Questions people ask

Does the keyword grouper look up search volumes?

No. It only adds up numbers you paste after each keyword. Leave them out and the groups still form, just without totals. Volumes from any keyword research tool or from your own search console export work, as long as each sits at the end of its line after a tab or comma.

Why are related words such as fitters and installation kept apart?

The grouper works on the words keywords share, not on their meaning, so synonyms and related terms are never merged. That keeps the result predictable and explainable. If two groups belong together, merge them in the CSV, or rerun with one of the words added to the ignore list.

How many keywords can I group?

Up to 20,000 lines are read. Grouping runs on your own computer, so very long lists may take a moment on an older machine. For huge exports, group one product or service line at a time; the groups are easier to act on anyway.

What is the difference between word and phrase mode?

Word mode groups keywords that share any single meaningful word. Phrase mode only groups keywords that share two consecutive meaningful words, such as boiler repair, after small words are removed. Phrase mode makes tighter, smaller groups and sends more keywords to Other.

Where your data goes

Your keyword list and volumes are grouped by code running on this device. Nothing about the list, including which terms you target, is uploaded.

Checked against the tool on

Top