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
-
Spammy keywords in our sub-domain but no penalty?
Hi, We have cigarettes and viagra as keywords in our sub-domain where our clients can post their business content. We have decent number of impressions and clicks for these related keywords. I have seen that these two words, especially "viagra" is most spammed. So are these hurting us? We dropped post Penguin update. Any correlation? Do you think that these keywords penalise us? We don't have messages or suggestion from Google Thanks, Satish
Intermediate & Advanced SEO | | vtmoz0 -
Keyword Stuffing because of the product names
Hi Moz community, Since I have many products in most of my pages which have the targeted keyword in the product name I get the "Keyword Stuffing" error. Is it really considered as "Keyword Stuffing" by Google? In addition to the products, I have some texts containing the targeted keyword for the page and this makes the number of keywords used in a page even higher. Thank you for your answers.
Intermediate & Advanced SEO | | onurcan-ikiz0 -
Would it work to place H1 (or important page keywords) at the top of your page in HTML and move lower on page with CSS?
I understand that the H1 tag is no longer heavily correlated with stronger ranking signals but it is more important that Keywords or keyphrases are at the top of a page. My question is, if I just put my important keyword (or H1) toward the top of my page in the HTML and move it towards the middle/lower portion with css position elements, will this still be viewed by Googlebot as important keywords toward the top of my page? QCaxMHL
Intermediate & Advanced SEO | | Jonathan.Smith0 -
Keyword Strategy for outside of the US
I posted a similar question a while go, so I will attempt to articulate my question a little better.... I am the owner of an E-Commerce site that operates in Canada. I have been brainstorming ways to find opportunities and niches for Canadian online shoppers in an industry that is dominated by corporate American E-commerce sites. I saw another Canadian e-commerce site try to combat this issue, and I wanted to get some advice on whether this strategy is sound. Here is an example. Well.ca is a large e-commerce site in Canada. They take a competitive product like a "Tide Lundry Detergent" and include local and intent terms in their page titles. For example "Buy TideLaundry Detergent from Canada at Well.ca - Free Shipping". If a Canadian shopper searches for "Tide Laundry Detergent", they are going to find results for amazon.com, ebay.com, Tide's website, etc.. I would imagine that Canadian shoppers would start to add terms such as Canada, Buy, or online to try to find Canadian sellers. If that is the case, then Well.ca ranks and arguably serves the customer with those intentions much better. I guess my question is, if the dominant search terms in my industry are polluted with irrelevant or American companies (even in Canada), is this form of localization a good idea? The terms don't seem to be searched much according to any keyword research tool I've used, but I know that I add "canada" to my search terms in order to find Canadian results? Thoughts?
Intermediate & Advanced SEO | | evan890 -
Bolding Keywords
A client has just switched from us to another provider and I have been checking up on the work done and the only change they have made is to bold lots of keywords on each page - I thought this was a practice that did not work - is there any evidence of this working or not working? Any articles/proof that we are not using out dated practices as we stopped doing this ages ago and yet the new provider is doing this. Who is right or wrong?
Intermediate & Advanced SEO | | JohnW-UK0 -
Why Keyword is not ranking
I have blog website - http://uncutweb.com/ My website ranked for keywords - What Color Shoes To Wear With Gold Dress, Keywords is having Moz Difficulty Score: 35% with A grade moz On page Score. But why my website is not ranked for What Color Shoes To Wear With Purple Bridesmaid Dress or **What Color Shoes To Wear With Coral Dress???**They have less difficulty score and having A grade.
Intermediate & Advanced SEO | | ross254sidney0 -
Plural versions of keywords
I am a Magician and optimising my site for local seo mainly. I would imagine this will affect any local business but I woule like some input from the community on how to handle variations of the same keyword. e.g I am a Magician and I am based in Hampshire So I have created a page for Hampshire and from previous keyword research optimised it of Magician Hampshire. However there are many more variations of the keyword. e.g Magicians Hampshire, Magicians in Hampshire, Hampshire Magician, Magician in Hampshire, Close up Magicians in Hampshire, Hampshire Magicians, Magicians near Hampshire, Local Hampshire Magicians. The list goes on but I can not find an answer on wether I should have a separate page/blog post for each of these keywords or include them in the same page. If I include them in the same page how to not make it spammy I am sure this is the same for electricians, dentists, hairdressers etc so am hoping there is a common answer to a problem that has been puzzling me for a long time Many Thanks Roger
Intermediate & Advanced SEO | | rnperki
http://www.rogerlapin.co.uk/0