“File > Make a Copy”
As SEO’s, we are dealing with a huge number of keywords most of the times and it is hard to filter and tag them even the numbers are not higher than 200, it could be a very boring job for us.
While I am dealing with them, I tried to find quick ways with Google Spreadsheet. I just used mostly basic Google Spreadsheet formulas and “regexmatch” to minimize my manual efforts.
On this Google Spreadsheet I shared, I wanted to combine a few techniques I am using for keyword research processes to show you what you can do and how you can use Google Spreadsheet.
I am always sharing this stuffs with this disclaimer, I am not a programmer, I am not an expert Excel guy and I am just copy/paste expert of Regex. 🙂 But still, I want to share the quick tricks to you, which help me a lot.
How to Use?
First paste your keywords to “Past&Filter” tab.
On this tab you can filter your keywords. Negative keywords which contain word on Negative part will be removed from your final list. Positive part is for necessary words to be in a final list. You can also see the keyword density to figure out which keywords you will need and which ones you need to be removed.
! All searches work with Regexmatch. So writing “one” to negative may delete your all “iphone” keywords from the list. You can use a few regex things to make betters filters. I tried to give some examples but you can improve with your regex knowledge. Check here for Google regex reference: https://github.com/google/re2/blob/master/doc/syntax.txt
“Auto Tagging” tab is for tagging your keywords. I tried to add useful examples to make it easier to use. It uses regex search and there is “Exclude” section for better tagging. You can name tags if you want or tag names come directly from “Search Term”. (“|” means or for Regex, as on example above, if you want to tag only “iPhone X”s not XR or XS, you can add xr|xs to Exclude tab just get iPhone X searches.”
At “All Tags” tab you can see the all tags and its keywords.
“Get a Tag” section provides you yo choose the tag and get all of the keywords with this tag.
Note: I limited number of KWs with 1.000 but you can extend it. It can be slower with a huge number of KWs but I tried 5K to 10Ks and it worked well but slowly.