If you followed my previous Wordtracker tutorial (or are already familiar with using Wordtracker), then you probably have a list of keywords saved to your computer. But the lists you export from Wordtracker are hard to manipulate. They’re not in a spreadsheet format. So what I like to do is convert my list of keywords into an Excel spreadsheet. If you’ve wanted to do this before but just weren’t sure how, then this tutorial will help you…

Here’s what the Wordtracker file looks like if you export the data to your computer…

From there, it’s easy to get the words into Excel or another spreadsheet. Just hit your ‘control + A’ key’ simultaneously to select all. Then hit the ‘control + C key’ together to copy it.

Open Notepad. Hit your ‘control + V key’ to paste everything into Notepad.

Here’s what you’ll have now…

Trim off the stuff at the top and the Copyright at the bottom. Here is what you want left in the Notepad file …

Notice it’s just the list of words with the search counts. Save your Notepad file somewhere on your hard-drive.

From here, open Excel. Click on Data > Import External Data > Import Data and find your Notepad file on your hard-drive.

Once you click on your notepad file, you’ll see this Text Import Wizard pop-up. In Step 1 of 3, make sure “Delimited” is ticked off, then click on Next >

In Step 2 of 3, make sure “Tab” is ticked and “Other”. Be sure to type in the “@” symbol next to “Other”. Then click Next >

In Step 3 of 3, be sure to click Finish …

Once you hit Finish, you should see a small screen labeled “Import Data”. Make sure you tick off “Existing worksheet”, then click OK…

Your list of keywords is now in Excel. The first column is just Wordtracker’s assignment number; you can delete this column if you want. The second column shows the search count across the search engines Wordtracker gets its data from. I don’t usually use this column (you can delete it if you want).

The third column is the Predict column. In my opinion, this is the useful column. It shows you the predicted maximum searches across all the search engines in a single day. In this example, the keyphrase “dog training” is potentially typed into all search engines 4,138 times per day. Please keep in mind that this is just an estimate.

Here is an example of a Wordtracker list in Excel…

Now that you have a nice list of words in a spreadsheet along with their counts, you can manipulate them to your heart’s content.

Remember that keyword research is the core of building a search engine magnet. So although this might seem tedious, it’s well worth it in the end.

If you don’t already have a Wordtracker account, you may want to try out their 7-day trial offer. Click here for the Wordtracker 7-day trial offer.