If you don’t already have a keyword list, brainstorm a few main keywords and use a keyword research tool to obtain a keyword list.
This article assumes that you already have a broad list of keywords you wish to filter. But if you are in a hurry, you can skip directly to the new (faster) method. If you want to give the Excel method a try read further. Here are two ways to quickly filter the right keywords for your needs: the old method, and the new method. However, some keyword filtering tools have become sophisticated enough to allow for advanced filtering.
The old method to filter keywords consisted of using an Excel spreadsheet and applying complicated formulas.
Fantastic! But which ones are the best keywords for your needs? A generated list of keywords can have hundreds or thousands of keywords and handpicking even a few keywords from such a huge list can be a daunting task. So, you have an extensive list of keywords generated during your keyword research for a page you wish to rank high with.