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
-
Blog page and homepage ranking next to each other for same keyword
Hello, I have my homepage that has been existing for 10 years that is ranked in 18 th position on google for the keyword luxury bike tours. This homepage doesn't have any external link or internal links saying luxury bike tours and nowhere in the title or on the page do I have the word luxury. I only have the words bike and tours. I created a blog page 24 hours ago that has the word luxury, bike and tours in the title and it is ranked in 19 th position just behind my homepage. I am wondering how it can be there and my homepage just be one spot above with all the history and linking it has ? Is it due to the fact that I have the word luxury in the title ? Is it just because my internal linking structure is correct and this blog page is brand new and will my homepage rank higher in the near future but see that I just redid the structure I need to wait a few months ?
Intermediate & Advanced SEO | | seoanalytics0 -
What would cause my structured data items to drop off?
I have about 20,000 items on my Magento Site. I used a plugin to add structured data. If I use the Webmaster Tools Structured Data Tester everything shows up perfect. There are no errors on any page that I have spot checked. My total items increased to about 2500, but has now started dropping. The numbers have dropped to about 725 over the last few weeks. What can I check?
Intermediate & Advanced SEO | | Tylerj0 -
How important is it to rank for a product category?
We make a product in a category of products -- let's say "donuts". There are really only 4 major donut companies (lots of artisanal donuts out there, but they're not really competitive yet). One of our competitors has systematically achieved top rank for "donut" and lots of adjacent keywords like "donuts" and "buy donuts". My question is, does their success ranking for the product category keyword "donut" influence their success ranking for long-tail keywords like "powdered donuts" and "tastiest donuts"? Or, to flip that question, should we try to compete for "donut" before worrying about "decadent delicious donuts"? Other factors: In terms of search volume, as you would expect, "donut" sees 10 to 1000 times as many searches as most of the other keywords adjacent to it. We can definitely compete for "donut" -- just trying to figure out if doing so should be our top priority.
Intermediate & Advanced SEO | | hoosteeno0 -
How important is my code to text ratio on web pages?
I've been getting mixed reviews on this and I'm trying to figure out whether this is something I should be concerned with. We have a higher than recommended amount of code, relative to "content" but not by a crazy amount. Thanks!
Intermediate & Advanced SEO | | absoauto0 -
Keyword Question: How to Target my Niche
Hello, I'm a health coach helping people with multiple sclerosis. Here's my website: bobweikel(dot)com What do you think the top 4 local keywords would be for my niche? I'm in Boise ID. I'm thinking MS Boise MS Boise Idaho Multiple Sclerosis Boise Multiple Sclerosis Boise Idaho With your intuition, do you think these are valuable keywords for a coaching site? Also, can you think of any other keywords? I want this 100% white hat.
Intermediate & Advanced SEO | | BobGW0 -
Why my own page is not indexed for that keyword?
hi, I recently recreated the page www.zenucchi.it /ITA/poltrona-frau-brescia.html on the third level domain poltronafraubrescia.zenucchi.it by putting it on the home page. The first page is still indexed for the keyword poltrona frau brescia . But the new page is no indexed for that keyword and i don't know why ( even if the page is indexed in google ) .. I state that the new domain has the same autorithy and that i put a 301 redirect to pass his authority to the new one that has many more incoming links that did not have previous .. i hope you'll help me thanks a lot
Intermediate & Advanced SEO | | guidoboem0 -
How important is it to clarify URL parameters?
We have a long list of URL parameters in our Google Webmasters account. Currently, the majority are set to 'let googlebot decide.' How important is it to specify exactly what googlebot should do? Would you leave these to 'let googlebot decide' or would you specify how googlebot should treat each parameter?
Intermediate & Advanced SEO | | nicole.healthline0
