Importing Keyword Planner Data into Excel?
-
What is the most efficient way to import search volume information into excel? We have 130K keywords that we need search volume information for.
-
So, there isn't any way to directly pull search volume directly into excel? I'm looking at a data set of 400K keywords
-
Great question! Google Adwords Keyword Planner doesn't make the place where you can do this very obvious or easy to find. Here's where you can do what you need to do:
1. Log in to Keyword Planner
2. Click "Get Search Volume for a List of Keywords"
3. Upload your keyword list via the resulting popout screen
4. Run the report
5. In the subsequent screen, upper right, just below the chart is a link that says "Download Ideas" - Click that
Then you will have all the data in Excel, provided you are running something newer than Excel 2003 which I believe had limited capabilities (45,000 rows maybe?)
Does that answer your question or was I way off
 Let me know. Hope it helps!
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Keyword Cannabalisation & Ecommerce
Hi I have an Ecommerce site, with a lot of similar products - for example leather office chairs - 80 products all very similar.. We worked to optimise product pages for longer tail phrases such as black executive leather office chair, but we now have different product pages trying to rank for these longer tail phrases as well. Now I'm trying to decide whether to focus on some priority product pages - adding lots of useful content/videos etc to try & boost the ones we want to rank for the long tail. OR whether to focus on the category page, and getting this to rank for all keyword variations... I'm a it stuck - any advice is welcome!
Intermediate & Advanced SEO | | BeckyKey0 -
Example of secondary related keyword
Hello, Can someone give me an example of primary and secondary related keyword for the keyword "Provence bike tour " ?
Intermediate & Advanced SEO | | seoanalytics0 -
Use of ajax to fetch data of a section
Hi, Is it ok to fetch a section on a page using ajax. Will it be crawlable by Google. I have already seen google's directions to get a complete ajax fetched page crawled by Google. Is there a way to get a particular section on a page fetched through ajax & indexed by Google. Regards
Intermediate & Advanced SEO | | vivekrathore0 -
Discrepancy in keyword ranking from webmasters and actual ranking.
I have been tracking ranks of some keywords important to my business since the last 2 months. Recently I have observed that, for one of my keywords, google webmasters is giving the avg position as 8 but when i search in google it comes in the 6th page. I know that webmasters tools gives the average position but i do not think there will be such big difference in the ranks. Please help.Thanks.
Intermediate & Advanced SEO | | seomoz12320 -
What to do with my keyword rich domainnames?
Hi, We have a holiday home rental business in Italy (Umbria). At this moment the language of the site is dutch and we targeting at the dutch and belgium market. Â We now in the fase of developing/adding 2 more languages, german and english. The url structure is going to is/be. dutch version (live)
Intermediate & Advanced SEO | | remcozwaan
domainname.com/nl
domeinname.com/nl/vakantiehuizen English (en) version (dev)
domainname.com/en
domeinname.com/en/villas
domeinname.com/en/villas/name-of-the-villa
domeinname.com/en/apartments
ect German (de) version (dev)
domainname.com/de
domeinname.com/de/ferienwohnung
domeinname.com/de/erienwohnung/name-of-the-ferienwohnung
domeinname.com/de/ferienhauser
domeinname.com/de/ferienhauser/name-of-the-ferienhauser
ect I have some registred some keyword rich domainnames like vakantiehuizeninumbrie.com (nl)
ferienwohnungumbrien.de (de)
ect question: Is it a good approach (seo wise) to point the keyword rich domainname to the specified landingpage. By example: point ferienwohnungumbrien.de to the page domeinname.com/de/ferienwohnung ? mille grazie! remco0 -
How Important is Domain Authority in Back-Link Audit
First off I just want to say thanks Penguin! Now I get to start the joyous experience doing a back-link audit, and removing all the negative links. Also I now have to be on constant alert for Black SEO tactics targeted at my domain due to the cut throat business I am in. I think it can only be a matter of time before Google says all backlinks do not matter. Unfortunately, I need rank now!! So I have a couple of questions: First how important is domain rank in a back-link audit? Should I remove myself from indexes with low domain rank, and leave ones with high? Should I remove myself from as many indexes as possible? What about obvious paid blog posts that have high domain rank? Do you leave those? What is considered a low Domain Rank for back-links, under 35 - 40? Second, what is a good success rate for a back link audit. How can you measure improvement, other than waiting for your PR or SERP to go up? Third, in some situations it looks like back-links are legitimate, but they all point to my home page. Is it worth pursuing for example asking these people to link to the specific product they are referring to for example children picnic tables instead of just our home page? And, lastly what legal rights do I have to get back-links removed? Is it only on sites that copy my content that I have copy written? Is it possible to prevent Google from counting these back-links through an .htaccess file? Thanks in advance for all of the help. I hope to take what I learn and put it into a guide of some capacity as I am sure many people are going through this same situation at the moment.
Intermediate & Advanced SEO | | fifthroommarkets0 -
Wordtracker vs Google Keyword Tool
When I find keyword opportunities in Wordtracker, I'll sometimes run them through Adwords Keyword tool only to find that Google says these keywords have 0 search volume. Would you use these keywords even though Google says users aren't searching for them?
Intermediate & Advanced SEO | | nicole.healthline0 -
Multiple Keyword Research Questions, Help
Hello , I've been trying for several days to understand how keyword research works for a multi purpose website,I've read guides, articles even some chapters from the book" The Art of Seo" by O'Reilly and still no luck. It seems i can't wrap my head around keyword research,lets say I have a social gaming community website and I'm trying to rank it first on some low competition keywords + some long tail keywords.The website has functions like leaderboards, profiles,events, competitions,etc so it's not actually a news related website but it will have a blog. My website being on the games niche It would imply that I should target words that contain the word "Games" but this word generates millions of searches globally so ranking first its nearly impossible if the website is brand new. This made me pursue generic keywords formed with 2 / 3 words like fresh games, new games, mmorpg games, fps games,etc which still generate lets say 30.000 searches globally each. Due to the different areas of the website like latest game events,latest games competitions,etc I'm confused If i should pursue website specific keywords like latest games events, fresh games events, latest games competitions, upcoming games competitions but these too generate 30.000 global searches each,so... 0.should i use generic keywords or keywords that include site features? So let's say I decide to pursue generic "games" keywords,due to a high competition based on the keyword I decide to go a layer deeper and for the keyword "fresh games" I obtain keywords like**Â "fresh games 2011,top fresh games 2011, upcoming fresh games**Â " and thus building a list of 30 keywords that contain " fresh games".If i do this for the rest of the keywords:Â **Â new games, mmorpg games, fps games,etc**Â I end up with a list of 10.000 keywords or more since each keyword generates other keywords. Is this the correct approach ? since generating 10.000 keywords sounds a lot and I'm getting the feeling that It's not how it supposed to be done,like were would I insert 10.000 keywords? So how do I know which keywords to pick and aim in order to try to get no.1 ranking? and why those? How many keywords should I use? and where should i put them? since it's not a news website so writing a lot of articles isn't an option. Should I focus on 2 words keywords with around 10.000-30.000 seaches or 2 words keywords + long tail keywords with less traffic like 100 - 5000? Is there a guide for the Keyword Analysis Tool since if i enter "fresh new games" i get a 39% keyword difficulty,is that hard to rank? and I don't know what all those color mean since some of them have higher numbers then others that are found at the top and how can i get beat a website that has has rank 10. So hopefully with your help & by some miracle I will finally be able to build a keyword list. Thank you !
Intermediate & Advanced SEO | | arching0