Grouping a list
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.
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.
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.
Set the smallest group
Groups with fewer keywords than this go to Other. Two is the lowest allowed.
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.
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
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 like | Usually means |
|---|---|
| A service plus places | One service page, or a service page with area pages if the areas differ |
| Prices, cost, quotes | A pricing section or page; these searchers are close to buying |
| Questions (how, what, why) | A guide or FAQ rather than a sales page |
| Other | Check 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