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
-
Keyword difficulty and time to rank
Hello, Is there a correlation between the keyword difficult and the time it takes to rank ? In other words let's say I try to rank for the keyword "seo" and it is going to take 2 years to rank 1 st whereas if I go for "best seo tools in 2018" and it takes just 2 weeks ? Thank you,
Intermediate & Advanced SEO | | seoanalytics0 -
Site ranks good for all keywords except the important ones
Hey guys I am the marketing manager for https://www.tadibrothers.com/, i started a year ago when the website was ranked very poorly on most keywords, I got most of our nitch keywords rank well to fist page except the most important ones. backup camera
Intermediate & Advanced SEO | | TadiBrothers
backup camera system
wireless backup camera system
rear view camera Our backlinks campaign is doing well 15 backlinks on average every month.
on-site optimization is also good.
Our Domain authority is better than all our competitors. Can anyone Please help me to understand why they do not rank well? Hope to hear from someone soon1 -
Importance of minimal markup on a page
Moz.com's 2013 SEO study gave some value to "Total # of Characters in the HTML Code" (https://mza.seotoolninja.com/search-ranking-factors/2013). Is having minimal HTML on a page still a ranking factor, even if not a huge one?
Intermediate & Advanced SEO | | A2890 -
How important is my code to text ratio on web pages?
I've been getting mixed reviews on this and I'm trying to figure out whether this is something I should be concerned with. We have a higher than recommended amount of code, relative to "content" but not by a crazy amount. Thanks!
Intermediate & Advanced SEO | | absoauto0 -
My websites Keyword Ranking are going down dont know why ....
Hi my website's Keywords Ranking are going down, i am very new to SEO, i dont know whats a reason please help me out....my website is www.livetecs.com. Thanks
Intermediate & Advanced SEO | | unibiz0 -
SEO Ecommerce Keywords
Hi guys got a question regarding ecommerce seo do you think its a better idea to target more long tail terms and try get links directly to product pages, brand pages and categories. Rather than focus on short keywords that do bring in good traffic but are very broad, i will prob do both, but i would like a second opinion please about other users strategies thanks
Intermediate & Advanced SEO | | Will_Craig0 -
ECommerce Products substantially similar but with important differences?
Hi eCommerce gurus, We sell a number of products, electrical in nature where the unit is from a group (sub-model is probably a good description) but each has important different physical properties. An example description is: #1 Clipsal C-Bus Wireless Plug Adapter 1 Channel Leading Edge Dimmer, 3A C-Bus Wireless Plug Adaptors allow mains GPO operated equipment to be controlled as part of a C-Bus Wireless network. The buttons on a C-Bus Wireless Plug Adaptor are able to control a load connected directly to the unit and control loads connected to other C-Bus Wireless units. Also, buttons on C-Bus Wireless Wall Switches can control a load connected to a Plug Adaptor.Each button can be programmed to function as an on/off, dimmer or scene control, as well as a number of other options. The other 2 in this group are: #2 Clipsal C-Bus Wireless Plug Adapter 1 Channel Trailing Edge Dimmer, 2A #3 Clipsal C-Bus Wireless Plug Adapter 1 Channel Relay, 10A but the item description details are really the same as #1. This trips Roger's duplicate content error and so probably Google's as well. I can consolidate into one product with 'options' but then can't list the three products discretely on Google shopping etc, and currently the 'Category' is a much wider 'Wireless Automation Products' which I don't really want to sub-categorise into 'C-Bus Wireless Plug Adapters' with three items in it making it harder for people to find. I can 'Spin' the description but this seem stupid and even more so for other items I have that have 12 different derivations of the same basic product Any Suggestions?
Intermediate & Advanced SEO | | BM70 -
Keyword as domain- worth buying it?
Hi, I just noticed that a top keyword for our industry is available as a domain, but for around $2,500.00 USD. For example, www.chicagoplumber.com. If we already have a pretty well established online identity as, let's say, www.chicagopipes.com, would it be worth buying the new domain and making it our primary? Thanks for your feedback! -Will
Intermediate & Advanced SEO | | WillWatrous0