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
-
Please... Help me convince my boss that Keyword Density is not-important / damaging.
If you can, please provide any and all talking points that I can use in this argument. It seems that no matter what I show him, including Matt Cutts' video debunking Keyword Density back in 2011, it doesn't seem to stick. He is fully, 100% convinced that keyword density is hugely important and we need to focus our time and energy on it. Any sources you might have to help me show him that this is a myth would be hugely appreciated. Thank you.
Intermediate & Advanced SEO | | TaylorRHawkins2 -
Difference keyword and co-occurence
Could someone explain me what the difference between a keyword and a co-occurence is ? Thank you,
Intermediate & Advanced SEO | | seoanalytics0 -
How to make the most of our data, charts and graphs online?
Hi, Our business has an enormous amount of data at our disposal, which we have traditionally only ever printed in our offline publications. I am aware however that much of this information would be of great use to people searching for the topics we cover online, so it strikes me that there must be a way to represent our data, tables and graphs online to maximise the visibility of the information. For example rather than simply including an image of a graph on a web page and editing the alt text to something like "Saudi Arabia economic growth 1995-2016", is there a way to publish this data online that will give search engines and users some good contextual information about what we are trying to show? Would certain rich snippets for example do the trick? Any help or pointers that could be provided would be greatly appreciated. Thanks Lou
Intermediate & Advanced SEO | | OBG0 -
What's with the Keyword Apocalypse?
Hi, 9 of my tracked keywords have dropped by over 20 ranks since last week. The nastiest drops in ranking are by 36, 38, and 46 places. For the last month I have been chipping away at the duplicate content with 301 redirects and was expecting my keyword rankings to improve slightly as a result of this; not the opposite. I don't have any manual actions logged against my site and am at a bit of a loss to explain this sudden drop. Any suggestions would be most welcome.
Intermediate & Advanced SEO | | McCaldin1 -
Possible for SERP appearance to change on a keyword?
Hi, We're currently working with a brand name which happens to be the name of a small town in the US (126 population). When Googling the brand / town name, there's a map on the right-hand side of the SERP. (Google Maps, with the town highlighted) We're based in Sweden, and this is even showing up on a search on the Swedish Google. I'm wondering; Is it possible for the map to "be removed" as our brand becomes more known? Does anyone have any similar experiences? Is it a better idea to just switch brand name?
Intermediate & Advanced SEO | | JSTRANDELL0 -
Should I use selected Keywords in Meta Title of non important pages
Hi All, I have identified 2 main keywords that I want a website to be found for 1: Alarm Systems 2: Security Systems I have two relevant landing pages set up and optimised for these terms and I have also optimised the home page for these terms I have countless other pages on the website that I don't really need to optimise such as Distributor Benefits or Supplier Benefits, About Us etc My question is should I use my selected keywords (alarm systems, security systems) in the Meta Title on these non important pages or should I just use them on the selected landing pages and home page? Historically I have used my primary keywords on all non important pages but not sure if Google looks down on this now. Thanks Robbie
Intermediate & Advanced SEO | | daracreative0 -
No longer to be found for "certain" keywords.
I'd like to see if anyone could potentially shade a light on this rather strange scenario: Basically yesterday I noticed that we are no longer to be found for 'certain' keywords that we had page 2-3 ranking. Yet, for other keywords we still appear on page 2-3. These keywords are very competitive and our rankings has constantly improved in the course of 5-6 months. Now my question is that what could or may have contributed to the fact that for only some keywords we are no longer to be found? Another question is, can Google remove you from their SERPs for certain keywords 'only'? Thank you,
Intermediate & Advanced SEO | | micfo
Maximilian.0 -
With Panda, which is more important, traffic or quantity?
If you were to prioritize how to fix a site, would you focus on traffic or quantity of urls? So for example, if 10% of a site had thin content, but accounted for 50% of the traffic and 50% of the site had a different type of thin content but only accounted for 5% of organic traffic, which would you work on first? I realize both need to be fixed, but am unsure of which to tackle first (this is an extremely large site). Also, I am wondering if the simply the presence of thin content on a domain can affect a site even if it isn't receiving any traffic.
Intermediate & Advanced SEO | | nicole.healthline0