To Export Your Keyword Groups Into Excel
Once you have grouped your keywords with Keyword Grouper Pro, it is very easy to export all those groups into a .csv file. Once you have them exported, you can open this .csv file with Microsoft Excel, or OpenOffice, or any spreadsheet program that will open a comma separated file (.csv file)
By exporting your groups to a .csv file that you can later open up in Excel, you make it very easy to start building up an advanced keyword analysis report in Excel to become a working document in your SEO planning.
How To Get Keyword Search Volume Into Your Keyword Analysis Report
Once you have exported the keyword groups and opened them up in Excel, you can then just take each group and paste the terms directly into the Google Adwords Keyword Planner (GAKP) or use a plugin like KeywordKeg (free for Chrome browser) and you can get the specific search volume for each keyword group. This will work better than just focusing on a single keyword search volume, because in most cases, when you write rich content, your pages will rank for many of the terms in the group, and not just a single keyword.
So I have done a search in Keyword Grouper Pro and i’ve gone ahead and I’ve already sorted these into groups you want to watch the other videos if you haven’t seen how to use this tool in this video i just want to show you this feature of exporting to csv so eventually once you get the groups created in Keyword Grouper Pro the next job is going to be to save this in some type of a format that you can work with so you’ll see here there’s a link that says export to csv if you click this link you’ll be prompted to save the file to your computer somewhere and then when you open that up this is inside Excel you’ll notice how now the group’s it will show you the number of keywords in the group’s all the keywords related to cases there’s four and then here are the four key word related cases and then the keywords related to gen here’s those identification and all of your groups will be there and you could save this is a great format to save and you can give this to maybe your webmaster or if you want to create a mind map with this will do that in the next video I’ll show you how to make this into a mind map really easily with a free free tool called Xmind if you don’t already have that installed XMind 7 but we’ll do that another video but this i just wanted to show you how easy it is to create a CSV from Keyword Grouper Pro and you could say that file so you can use that for your future work to work from those groups
1 Comment
Reply