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
-
Should we go after this main keyword?
Hello, We run an online store. The main content keyword for our niche is very competitive, but if I was going to go look up information and I was one of our customers, that is exactly what I would type in - this main general keyword. We have an expert in the field to write it and plenty of time. Although the main keyword is competitive, there are many many subkeywords that are a lot less competitive that would be answered in the article. It's tough to find good topics in this niche. We're thinking about doing a "Complete Guide to X". We would have far less backlinks and authority for about half of the 30 keywords it will cover than our main competitors. Should we do this and spend the next couple of years working on it, or should we perhaps target a smaller topic? Any advice is appreciated.
Intermediate & Advanced SEO | | BobGW0 -
Open Data and SEO - Government sources
Hi Everyone, Does anyone know of a connection between open data and SEO? I think this is a very interesting topic to explore. Lots of governments are jumping on this trend and it seems like Google and other search engines would be interested in this kind of authoritative source. Here are some examples - USA OPEN Data examples Palo Alto, California USA: paloalto.opendata.junar.com Cupertino, California USA: cupertino.opendata.junar.com San Jose California USA: data.sanjoseca.gov Other international Open Data examples Chile: recursos.datos.gob.cl Bahía Blanca, Argentina: http://bahiablanca.opendata.junar.com/dashboards/7844/medio-ambiente/ Lima, Perú lima.datosabiertos.pe
Intermediate & Advanced SEO | | Carla_Dawson0 -
Keyword Self Cannibalization and E-Commerce
I run a Magento shop - let's imagine a situation where the category landing page, is about "Joe Bloggs Kettles" Then on that page, we have the products listed ; so we would have links to products pages - these links will be called something like:
Intermediate & Advanced SEO | | bjs2010
Joe Bloggs Red Kettle
Joe Bloggs Yellow Kettle
Joe Bloggs Purple Kettle Can someone please tell me if this is ok or should we rework our strategy? Thanks0 -
How important are sitemap errors?
If there aren't any crawling / indexing issues with your site, how important do thing sitemap errors are? Do you work to always fix all errors? I know here: http://www.seomoz.org/blog/bings-duane-forrester-on-webmaster-tools-metrics-and-sitemap-quality-thresholds Duane Forrester mentions that sites with many 302's 301's will be punished--does any one know Googe's take on this?
Intermediate & Advanced SEO | | nicole.healthline0 -
Keyword search in Google Adwords
Hello all, I would like to use the Google Adwords Keywords search tool, in order to start working in the structure of my website and targeting the right keywords. I am targeting all the world, all languages, global monthly searaches but: I have the doubt which filte I should use: broad?, exact? or phrase?I am using "braod" but I do not know if I should use exact instead for keyword selection. Would you recommend me any other tool instead of Google Adwords Keywords Search for keyword analysis? Thank you very much Antonio
Intermediate & Advanced SEO | | aalcocer20030 -
URL - Keywords
My domain name contains my top two keywords. Am I penalized if I create another page where I add my domain key words a 2nd time after the domain name along with a subcategory and the name of a state. I don't know what white hat and black hat is so I want to make sure I stay white hat. Also I didn't know it but is it true that your title shows up in your domain name?
Intermediate & Advanced SEO | | Boodreaux0 -
How to Target Keyword Permutations
I have a client that wants to rank for a keyword phrase that has many permutations.. ex. "Alaska Hill Country Resort", "Hill Country Resort Alaska", "Hill Country Alaska Resort" But I'm wondering if I should target these all on the same page or not. I'm assuming all of these permutations are actually valid searches because I did my keyword research for 'exact match' keywords and got results like this.. (let me know if I'm missing something here, or if this sounds right) [Alaska Hill Country Resort] - 230 Local Searches [Hill Country Resort Alaska] - 140 Local Searches [Hill Country Alaska Resort] - 30 Local Searches The phrase we're targeting is their main keyword phrase, so I've chosen their home-page as the page to rank for this phrase. My thought is to optimize for the most popular phrase (ex. "Alaska Hill Country Resort"), and sprinkle in the other phrases throughout the copy. Next I would run a link-building campaign targeting the main phrase first.. then the next phrase, and so on, so that my anchor text is more heavily focused on the more popular terms, but I would also make sure to include the less popular terms. Do you think this is the best way to go about this? Do I really need to make individual pages for each of the permutations, or is it okay to target them all on one page since they are essentially the same keyword?
Intermediate & Advanced SEO | | ATMOSMarketing560 -
How important is adding Google Analytics for SEO?
Ann Smarty mentions in a post (http://www.searchenginejournal.com/200-parameters-in-google-algorithm/15457/) the addition of Google Analytics adds SEO value. We have a different analytics tool, do you think it is necessary to add Analytics? How important do you think it is?
Intermediate & Advanced SEO | | nicole.healthline0