Had to categorise some keywords, if there’s a quicker way of doing it – please let me know

• Paste keywords into column A
• In column D – Paste all relevant words for a category.
  For example – I pasted all the words I could think of relating to gardening – such as “tree”, “fruit”, “garden”, “bush”, etc. – There were 18 words in total
  
• In cell E2 paste the formula:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$1:$D$19,A2)))>0, "Contains value from range", "Does not contain value from range")

• Now drag the formula down
• Filter column E to “contains value for range”
• Colour in the keywords green – or a chosen, relevant colour

Add another list of relevant words – for example, above I have added sports, to highlight sports netting keywords.

Drag formula down and repeat

I found a quicker way – use Chat GPT and the prompt:

“please can you group these keywords by theme or words containing – e.g. keywords containing “golf”.

Please include the search volume.

The list is set out with a keyword – then a comma, – then the search volume for the keyword, – then a second comma – before the next keyword is listed

funny polo shirts , 170 ,
funny polo shirt , 30 ,

“

replace “funny polo shirts” with a list of your own keywords.