Creating a keyword spreadsheet

So we started our initial view, of all the keywords that could be used to find our website. But what we want to do, is start downloading all those keywords into some form of manageable document. I find a spreadsheet to be the most obvious, and easiest for managing these keywords, because the amount keywords you have is going to be directly relational to the amount of products or information, you want to push through your website. So it's possible that these lists could be in the thousands or tens of thousands of key words.

Here's a couple of things that you need to keep in mind as you start this initial process. I'm starting in keyword discovery, which allows me to pull all this keyword data, and see which keywords are related to my business. So I can go through and put a check in the checkbox of the keywords that are relevant. As you can see, I can also add the entire column into my keyword project. So I want to find all the relevant keywords and sometimes maybe I'll just add an entire column into that so I can just look at that later.

But if the vast majority look relevant, I'm going to go ahead and add them. So, I can get as big a picture as possible. Usually when I'm going through this, I'll create an individual project for each grouping of keywords. So this group of keywords is about the spa and resort vacations. All of my keywords are going to be related to that vertical. My hiking keywords for the other products, I'm going to save those and add them to a different project so I can manage them differently.

Now once I've got all these keyword in my project, I know I've already added them because there's a check mark next to them, and I can still go though and see what I've of missed, and what's open and just keep looking at pages and pages of additional keywords to add to the project. Now once I'm ready and I feel like I've got a good grasp, of the entire market of keywords, then I'll go to export them. And almost every tool has an export feature, that will allow you to determine which format you should export, what you want to include such as how many searches, what does the keyword data include as far as competition or occurrences or daily.

And then how you want to look at it? And then you simply export it and open it up in a spreadsheet and that will prepare you then to start filtering and organizing all of the keywords based on your specific business and products.