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!
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
-
Keywords and relevancy
Should you always go by the highest relevancy when your choose your keywords sor can you take some keywords with the lowest relevancy possible and will it still help your webpage ? Thank you,
Intermediate & Advanced SEO | | seoanalytics0 -
Example of secondary related keyword
Hello, Can someone give me an example of primary and secondary related keyword for the keyword "Provence bike tour " ?
Intermediate & Advanced SEO | | seoanalytics0 -
Software assisted meta data
I was recently contacted by an SEO firm that did a search on my site and said it had a low index. Out of 5,000+ pages only 800 keywords was ranking. They said there is much improvement for adjusting my meta data for indexing. They said there is a software that does this for you. Does anyone have any experience with this? Does this sound true what they are explaining? What is this software and how much does it cost? Any help would be greatly appreciated.
Intermediate & Advanced SEO | | nchachula0 -
Is it alright to repeat a keyword in the title tag?
I know at first glance, the answer to this is a resounding NO, that it can be construed as keyword stuffing,
Intermediate & Advanced SEO | | MIGandCo
but please hear me out. I am working on optimizing a client's website and although MOST of the title tags
can be optimized without repeating a keyword, occasionally I run into one where it doesn't read right if I
don't repeat the keyword. Here's an example: Current title:
Photoshop on the Cloud | Adobe Photoshop Webinars | Company Name What I am considering using as the optimized title:
Adobe Photoshop on the Cloud | Adobe Photoshop Webinars | Company Name Yes, I know both titles are longer than recommended. In both instances, only the company name gets
truncated so I am not too worried about that. So I guess what I want to know is this: Am I right in my original assumption that it is NEVER okay to
repeat keywords in a title tag or is it alright when it makes sense to do so?0 -
Image Alt tags--always include the targeted keyword?
Question for all the SEO's out there. Do you always include your target keyword in the image alt tag? For example, if you had an article on osteoarthritis, and you included a photo of an old man, would you put "old man on a bench" or "old man suffering from osteoarthritis" -- even though you have no idea if the old man suffers from osteoarthritis?
Intermediate & Advanced SEO | | nicole.healthline0 -
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 -
New domain, and Local Service, Moderate Keyword
Hi all i have a new client, who has bought a shiny new domain name for his business, it has one keyword in it related to his business. He is a local plastering looking to get his site ranked, but my worry is the domain age, its very new less than 2 months, i know google sandboxes new domains, The term he is targeting is Mod Completive (26%) is getting his domain ranked page one within 6 months a possibility, or will it just seem utterly spammy in googles eyes. Any tips please thanks will
Intermediate & Advanced SEO | | Will_Craig0 -
How important is sticking to an exact keyword?
The latest article I'm writing for my site is "Friends With Benefits Rules"... So the first part of my question is, what does SEOMoz advocate as being the ideal # of times to include the entire key phrase in the article? I know nobody but Google knows for certain, but is 4 (including in H1's etc.) generally considered enough, other than in the page title? Second part is, what is the consensus about how important is it to stick to the exact keyword? For the example I gave, is it just as good to include a comma, E.g. "...friends with benefits, rules..." or a hyphen "Friends with Benefits - Rules for..."? One thing I'm unclear about on this topic is stop words and plurals. I've been told before that Google ignores stop words, but results for searches with or without the word "how," for example produce very different results... Same thing with plurals. In any case, all of the above is assuming that the quality of the content would not be affected in either case...
Intermediate & Advanced SEO | | corp08030