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
-
Are keywords in the title tag becoming redundant?
I've noticed that lot's of the world's leading digital agencies are not using keywords in their titles. Eg AKQA, DigitasLBi, POKE, SYZYGY etc. Why is that? Are keywords no longer that important? This can't be accidental seeing as it's the case for so many leading agencies.
Intermediate & Advanced SEO | | RRoginator0 -
Can I know which keywords lost their top rankings on google a year ago if the client didn't checked the keyword rankings in his website?
Hi, Can I know which keywords lost their top rankings on google a year ago if the client didn't checked the keyword rankings in his website? Thanks Roy
Intermediate & Advanced SEO | | kadut1 -
Traffic and keyword drop
Hello, On one of the sites that I manage - http://www.zalikihotel.gr/ , there was a significant decrease in keyword positions over the last 10-15 days. Sample screenshot is attached. Some of the keywords even dropped for 17-18 positions. From the end of April, organic traffic dropped by 30 percent. Website is mobile optimized, so that shouldn't be a problem. In the last 3-4 months, we had traffic increase. Domain authority went up by 3 points after the last index. On-site SEO was completed, and currently I'm focusing on link-building and working on bringing back to life forgotten social media. Does anybody knows what might be the case for this negative affects on our site? Do you think it's a temporary fluctuation or not? Thanks in advance. 8dSBELm.png?1
Intermediate & Advanced SEO | | socrateskirtsios0 -
Owning all of the top 10 positions for one keyword
Hello, I would like to know if it is considered bad by Google to rank every single spot in the top 10 with the same keyword? All websites conver the same topic which this keyword, but have unique content. Those websites dont link to one another. To be clear, I am not asking if it is a good idea because it will be harder to rank, find links etc. or because the last positions don't bring enough traffic. I really just would like to know if it against Google guidelines? Any thoughts or sources are greatly appreciated.
Intermediate & Advanced SEO | | EndeR-0 -
Is this misuse of scheme data?
A directory list page that uses the individual business page review data. Instead of the scheme markup indicating the a particular business page has a review, the page that lists all of the businesses gets the review instead. This means the list page can get hundreds of reviews which could potentially affect its SERPs. A competitor is doing this now. Is this an abuse of the system? Should it be reported? How does on report this kind of this?
Intermediate & Advanced SEO | | designquotes0 -
Is it better to use geo-targeted keywords or add the locations as separate keywords?
For example... state keyword (nyc real estate) or keyword, state (nyc, real estate) = 2 keywords Thanks in advance!
Intermediate & Advanced SEO | | Cyclone0 -
Keywords in domains losing power
One of my clients received a letter from another seo company touting for business. I would be interested in hearing what your opinion is on this fellow SEO providers. Letter attached - > letter.jpg
Intermediate & Advanced SEO | | onlinemediadirect0 -
Microdata and dinamic data.
Hi, everybody! We're starting up a local services website in Brazil. Something like redbeacon.com or thumbtack.com, but obviously different. So we are developing our 2.0 version of the site, and I want do put microdata in every provider's pages, to rank people's evaluation about this particular provider, and geographic information about him. Ok, we want to use microdata in several pages, but those are more important: the providers. These data (geo and rank) will be dynamically generated from our database. In Schema.org, I only found information about using static data to build microdata for my intentions. My doubt is: does google and bing and yahoo and etc index dynamic generated data? Is there something about sitemaps.xml or robots.txt that I can do to have my data indexed on search engines? Our front-end is the guy who deal with html and our codemaster uses pure php for coding. Thanks!
Intermediate & Advanced SEO | | ivan.precisodisso0