The comma separated values (CSV) data for spreadsheet: SEO - Keyword Analysis

Enter 25 keywords. Decide how relevant the keywords are to your business. Lookup the popularity (how often used in past month) and the competition. Please read the comments below for further instructions.,Relevance to your business (Score 1 - 3. 1 = hardly relevant. 3 = very relevant),Popularity - How often used in past month. Use Overture / WordTracker (Please read the comments below for further details.),Number of sites that meet exact search on Google / MSN (Please read the comments below for further details.),Keyword Effectiveness Index (this is a formula!),Go through the list and remove the poor keywords. It helps when you sort by Relevance or by KEI score. Next pick the Top 20 keywords. Out of your Top 20\, you pick your Top 5 list of keywords. Now look at each of your webpages and first pick the most applicable keywords from your Top 5 list\, then pick keywords from your Top 20. If you still have space\, fill it with applicable keywords from your large list.,http://www.frontlinesoft.nl,,, Keyword,Relevance,Popularity,Competition,KEI score,,,,, beer,1,87986,182000000,42.54,,,,, coke,2,35125,51700000,23.86,,,,, root beer,3,4650,2270000,9.53,,,,, pepsi,3,89370,38700000,206.38,,,,, milk,2,54859,140000000,21.50,,,,, water,3,159438,1230000000,20.67,,,,, A&W root beer,2,2400,129000,44.65,,,,, diet pepsi,1,3476,1240000,9.74,,,,, fanta,2,4978,6180000,4.01,,,,, sisi,3,3989,2400000,6.63,,,,, lemon soda,3,58,65500,0.05,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,, empty,0,0,0,0.00,,,,,

You can also export the spreadsheet's formulas instead of its calculated data.

Go back to spreadsheet: SEO - Keyword Analysis.