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
-
How to rank for a keyword
Hi guys, I'm looking to rank a new blog for a search term which we currently already rank #1 for. I want to create a blog which provides a better solution to a searchers query and knock our current #1 page for this new one. Is there a way to do this simply without losing the real-estate the currently ranked #1 page has already accumulated? Or is just a matter of working on this new blog to find it's own way to the top? Thanks in advance, James
Intermediate & Advanced SEO | | jameseacott0 -
Meta Keywords: Do They Hurt Rankings
I know that Google doesn't use meta keywords, but does it hurt to have anything in there? Just wondering if I need to remove all the meta keywords that are on my site, or are they harmless to have. Also, would meta keywords ever be used by an internal search plug-in if we were to install one in the future, or do they generally look at the product title and description for that info?
Intermediate & Advanced SEO | | b4cab0 -
Keyword Spy Source?
We've got a few backlinks from Keyword Spy and Keyword Spy Pro. I'm pretty sure of the answer but I'll ask it anyway. Is there any way to determine who's doing the snooping? Are there any signals to look for while clicking back through the link "crumbs" that might tell me something of interest or value?
Intermediate & Advanced SEO | | AWCthreads0 -
Exact Match Keywords
Hello,
Intermediate & Advanced SEO | | Cornel_Ilea
Now that the Keywords Tool is gone, how can I see [exact match] search volumes on Google?
Thank you,
Cornel0 -
Changing a subdomain to a full domain to rank for a keyword
We have been attempting to get our blogsite to rank for our business name(Instabill). We are now considering changing the url from blog.instabill.com to something like instabillblog.com. I have following concerns about the change; Will changing the domain really be that helpful (i.e. will the change get our blog on page one for the term instabill) We have over 350 pages of content on our blog. Will changing the domain have possible negative effects ( I was thinking of using url updater in webmaster tools and creating a permanent 301 redirect from the older url to the new) Having never changed a url for a site with this much content and seo value for my company I would like to know the following from someone who has made mistakes here before; what not to do what steps you would take to make the transition easier Any help here will be greatly appreciated. cheers, Instabill
Intermediate & Advanced SEO | | Instabill0 -
Owning all of the top 10 positions for one keyword
Hello, I would like to know if it is considered bad by Google to rank every single spot in the top 10 with the same keyword? All websites conver the same topic which this keyword, but have unique content. Those websites dont link to one another. To be clear, I am not asking if it is a good idea because it will be harder to rank, find links etc. or because the last positions don't bring enough traffic. I really just would like to know if it against Google guidelines? Any thoughts or sources are greatly appreciated.
Intermediate & Advanced SEO | | EndeR-0 -
How important is it to fix Server Errors?
I know it is important to fix server errors. Â We are trying to figure out how important because after our last build we have over 19,646 of them and since google only gives us a 1000 at a time the fastest way to tell them we have fixed them all is to use the api etc which will take time. Â WE are trying to decide is it more important to fix all these errors right now or focus on other issues and fix these errors when we have time, they are mostly ajax errors. Â Could this hurt our rankings? Â Any thoughts would be great!
Intermediate & Advanced SEO | | DoRM0 -
Different TITLE for the same page appear for different keywords
Hi there Can anyone advice please on this funny/strange issue I have title on home page. When I type some of keywords the homepage appears in SERP with shortcut TITLE (just one keyword there). But when I type company name I have full TITLE. Could anybody advice please what can be a problem and how to fix it?
Intermediate & Advanced SEO | | fleetway0