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
-
Google Adwords - Keyword Avg Cost Per Click
Hi Is there away to get the history of the Avg cost per click for a keyword?
Intermediate & Advanced SEO | | Cocoonfxmedia0 -
How to get more keyword ideas
I am trying to get more keyword ideas for one of my project. For example the seed keyword is computer virus and the results which i get is keywords related to the phrase computer virus such as virus in computer , virus threats but actually i am trying to get search details on actual threat names or types of viruses and i expect output such as malware, trojan etc.. ( Currently using ad words keyword planner to fetch keyword data ) Is there any way to achieve this ? Even if i use "types of computer viruses" as seed keyword i am not getting the types of viruses people searching for instead i get keywords ideas such as computer viruses, computer threats etc... ? Can somebody suggest a solution ?
Intermediate & Advanced SEO | | NortonSupportSEO0 -
Mega Good Bulk Keyword Tool
I have over 1000 keywords to sort out , I need a tool that picks up on variations and symmons. Does anyone know of a very good tool that is available? If not I'll do it the long way round with Excel 😞
Intermediate & Advanced SEO | | seoman100 -
Confused with rankings for keywords that are not on the actual page?
Hey Guys, So I went to search a keyword, my competitor came up, when I looked for that keyword on their page i didn't see it at all, and the page is content thin, how is it they are ranking for the keyword at all? Bit confused at how this works. So having the keyword in your content is not necessary a ranking factor? Please advise and sorry if this question is really amateur, I'm sure based on this search there is more to it then that.... could you other ranking factors as to why they rank for a keyword that is not in their content? Does the whole exact keyword have to be in the content to rank? Thanks all
Intermediate & Advanced SEO | | edward-may0 -
Google places keyword variations
Hi all, I have a site that is ranking #1 in Google Places for its main <city><keyword>search... but it does not rank for any of its basic keyword variations, which I find very confusing.</keyword></city> ie (just an example) Chicago Caterer (ranked #1 in google places)
Intermediate & Advanced SEO | | x2264983x
Chicago Caterers (not ranked in google places)
Chicago Catering (not ranked in google places)
Chicago Catering Company (not ranked in google places)
Chicago Catering Companies (etc..) How can I secure a google places ranking for these simple keyword variations? Do I build links to the google plus page using that anchor text? Do I get citations that contain that keyword somewhere on the page? Do I optimize for these keyword variations on the actual website itself? (not the places listing). Obviously I don't stuff these keywords into the google places listing. Any help would be much appreciated!0 -
Where is the point of diminishing returns for silos and keyword subdirectories?
And as a follow-up, is that point far enough out to justify making a site's folder structure different from its navigation structure? I'll give an example. Say I was to do SEO for a hypothetical (I hope) someconstructioncompany.com, and the the menus/submenus were laid out as About Us ---- Our company ---- Our staff ---- Locations -------- Albany (default path would be .com/about-us/locations/albany-ny.html) -------- Miami -------- Liverpool Services ---- Kitchen remodeling (default path would be .com/services/kitchen-remodeling.html) ---- Above ground pools ---- Green building Photo galleries ---- Kitchen photos (default path would be .com/photo-gallery/kitchen-photos.html) ---- Pool photos ---- Green building photos Would there be any benefit (and if so, enough of a benefit to outweigh the additional overhead of keeping track of a separate structure) to having the menus set that way, but the actual files siloed as stuff like someconstructioncompany.com/kitchen-remodeling/kitchen-renovation-services.html someconstructioncompany.com/kitchen-remodeling/custom-kitchen-photo-gallery.html someconstructioncompany.com/above-ground-pools/above-ground-pool-photos.html someconstructioncompany.com/albany-ny/green-building-custom-home-remodeling-contractor-albany.html Would that separation of navigation structure and file structure be beneficial or would that time/effort setting it up be better spent elsewhere? Thanks!
Intermediate & Advanced SEO | | BrianAlpert780 -
Avoiding keyword cannibalisation in Wordpress Structure
Hi all, I've been planning the WordPress structure for a client for a long time, and soon need to get started. I keep coming back to this problem / question, whereby there will be a static Page with a name like "Christmas Collection", but there also has to be a Category called "Christmas" to accomodate new content. Is this likely to cause serious keyword cannabalisation? It's a non-ecommerce site To elaborate we need to have the following static Pages: christmas collection easter collection halloween Collection and each of these Page's will be populated with related Posts (based on category ID) after the Page's content. And these corresponding Categories need to be similarly named. As there's no apparent relation between Pages and Categories, I keep coming back to the concern that having a Page named "Christmas Collection" and a Category called "Christmas" is a big SEO NO NO. Any thoughts, opinions, workarounds much appreciated! Regards, c
Intermediate & Advanced SEO | | councilflat0 -
Should I remove Meta Keywords tags?
Hi, Do you recommend removing Meta Keywords or is there "nothing to lose" with having them? Thanks
Intermediate & Advanced SEO | | BeytzNet0