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
-
Conundrum with brand new website keywords...
I'm working with on a website for an app called BetterRX. There's a prescription card called BetterRX Card. Our domain is Better RX.com and the card is BetterRXCard.com. "Better RX" as a brand search is dominated by prescription discount cards, with Good RX being the most dominant. Any suggestions on how to go about mixing optimization for brand as well as the app?
Intermediate & Advanced SEO | | sickle3110 -
Having a Keyword in # is not that important in 2018, Do you agree?
Earlier having a Keyword in was one of the important ranking factor or at least every SEO guru use to suggest this. But, of late, we are noticing that Google is not giving much weightage to it. What are your thoughts on this?
Intermediate & Advanced SEO | | SameerBhatia3 -
Keywords Dropping Out
Hi In March I've seen a lot of keywords go from being ranked, to dropping out completely. We usually get under 1000 drop in and out each month, but 2,500 dropped out this month. Some are not focus keywords I'd be concerned about, but then some are.... I am trying to work out why and could use some help. We haven't changed anything on the pages & here are some examples: http://www.key.co.uk/en/key/dollies-load-movers-door-skates - previously ranked for 'Dollies' position 6 now unranked http://www.key.co.uk/en/key/sack-trucks - ranked position 11 for 'Folding Sack Truck' now unranked http://www.key.co.uk/en/key/portable-workbenches-trestles - ranked position 7 for portable workbenches now unranked. These pages do still rank for other keywords, so aren't out of Google completely. I'm just trying to identify if we have any other issues Thank you 🙂
Intermediate & Advanced SEO | | BeckyKey0 -
Keyword in URL - SEO impact
Hi, We don't have most important keyword of our industry in our domain or sub-domain. How important it is to have keyword in website URL? Most of our competitors pages with "keyword" urls been listing in SERP. What is back-links role in this scenarion? And which URL have more advantage? keyword in sub-domain or page with keyword. Like for "seo" keyword..... Â seo.example.com or example.com/seo
Intermediate & Advanced SEO | | vtmoz0 -
Why Keyword Ranking Fluctuate?
Hi All, I have a shoes website and I am working on it from last four months. I am targeting four main keywords but I have some issues with ranking. First one is that keywords ranking fluctuate many time a day but they remain on the same page. Second one is that these keywords remain on the same page for 2 to 3 week and than suddenly they drop down in the ranking. Please help me regarding these issue. Waiting for replies. Thanks
Intermediate & Advanced SEO | | Cuttingseo0 -
Keyword cannibalization
I ran the SEOMoz onpage diagnostic, and i got an alert for keyword cannibalization. My taxonomy is: www.mysite.com www.mysite.com/category (category page) www.mysite.com/category/category-keyword (supporting page) Links will be exact match in the primary navigation. www.mysite.com anchor text "category" => www.mysite.com/category www.mysite.com anchor text "category keyword" => www.mysite.com/category/category-keyword www.mysite.com/category anchor text "category keyword" => www.mysite.com/category/category-keyword and example would be /IT-support linking with anchor text "IT Support Servers" => /IT-Support/IT-Support-Servers I'm not going to have a cannibalization problem, am I?
Intermediate & Advanced SEO | | CsmBill0 -
Should we get a new domain that has our main keyword in it.
We have been running our site about 10 years under the domain www.islesurfboards.com and we are referred as "Isle Surfboards" when linked to in the anchor text. Our core product line and keyword focus has always been on "surfboards" and its related long tail keywords. However in the last several years we have began to sell "paddle boards" and now they have become our best selling product accouting for 80% of our business. We really want to rank well for "paddleboards" and related words but noticed we always seem to fall below people who have websites with "paddleboard" or "sup" in the domain and company name. will they always rank better unless we also inlcude it in ours? Should we move to a New Domain that focuses on the new target keyword "paddleboard" or a combo of both "surfboards" and "paddleboards"and would this make any difference or even hurt us since it would be a new domain. Then in addition rebrand our company name to include surfboards and/or paddleboards in the company name or some combo of both so the anchor text when people who refer to us relate to both paddle boards and surfboards?
Intermediate & Advanced SEO | | isle_surf0 -
HTML 5 sites, segmentation and Meta data?
Hello Mozers, I am currently building an HTML 5 site. I've run into a couple of issues. While implmenting segmentation in each of my mian menu iten, I am able to pluggin Meta data only for one segement (or the page). I am unable to inser Meta data for each of the segments. For example: I have (main menu) Services ----> Submenu (teaching, upgrading, Dancing) I can implement meta data for the Services but not for teaching, upgrading and Dancing as they are segment in the same page. Whats the best logic to get around this
Intermediate & Advanced SEO | | waspmobile0