It may take a while depending on how many keywords you have, but at least you can get on with some other tasks. You’ll notice it also gives a probability score. I tend to just filter for anything less than 50% and delete them. I’ve got 100,000 keywords, I won’t miss the odd few. 

1. Next, we make a copy of the sheet, delete the two columns, and do exactly the same thing for category 2:

1. Once we have both categorizations and have deleted keywords that have a low “confidence score”, you’ll just need to clear the formatting and then run a vlookup to pull them together:

Run for as many categories as you need, and then pull in any other important data for your finalized keyword research document: