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
-
Homepage not showing up for Brand/Any keywords (on Google) all of a sudden
The homepage to this website is crawled and indexed, however, it's not showing up for any searches, even brand searches (eg: Klay schools). This happened overnight. Do you know what the underlying issue could be? Link to the homepage: https://www.klayschools.com/
Intermediate & Advanced SEO | | vishesh10104 -
Two sites targeting same keywords (but with different owners)
Hi Guys So we manage a client website doing their seo and ppc The site has become a success so the client has now asked if we would like to create our own site and become an affiliate of theirs The idea is target the same set of keywords etc. My question is - in the world of google is this ok? I know about google penalising same business owners for having two websites targeting the same keyword.... But in this case - the websites are owned by different owners, different hosting, different domain ownership, different analytics code, different code development, different about us Everything is different but I am just a little paranoid that google knows we SEO the clients website Does anyone have any advice? Thanks Duncan
Intermediate & Advanced SEO | | CayenneRed890 -
Mapping ALL search data for a broad topic
Hi All As our company becomes a bigger and bigger entity I'm trying to figure out how I can create more autonomy. One of the key areas that needs fixing is briefing the writers on articles based on keywords. We're not just trying to go after the low hanging fruit or the big money keywords but actually comprehensively cover every topic and provide actual good quality up to date info (surprisingly rare in a competitive niche) and eventually cover pretty much every topic there is. We generally work on a 3 tier system on a folder level, topics and then sub-topics. The challenge is getting an agency to: a) be able to pull all of the data without being knowledgeable in our specific industry. We're specialists and, thus, target people that need specialist expertise as well as more mainstream stuff (the stuff that run of the mill people wouldn't know about). b) know where it all fits topically as we kind of organise the content on a heirarchy basis. And we generally cover multiple smaller topics within articles. Am I asking for the impossible here? It's the one area of the business I feel the most nervous about creating autonomy with. Can we become be as extensive and comprehensive as a wiki-type website without having somebody within the business that knows it providing the keyword research. I did a searh for all data using the main two seed keywords for this subject on ahrefs and it came up with 168000 lines of spreadsheet data. Obviously this went way beyond the maximum I was allowed to export. Interested in feedback and, if any agencies are up for the challenge, do let me know! I've been using moz pro for a long time but have never posted and apologise if what I'm describing is being explained badly here. Requirements Keywords to cover all (broad niche) related queries in the UK, no relevant uk (broad niche) keywords will be missed Organised in a way that can be interpreted as article brief and folder structure instructions. Questions How would you ensure you cover every single keyword? Assuming no specialist X knowledge, how will you be able to map content and know which search queries belong in which topics and in what order. Also (where there is keyword leakage from other regions) how will you know which are UK terms and which aren’t? With minimal X knowledge – how will you know whether you’ve missed an opportunity or not (what you don’t know you don’t know) What specific resources will you require from us in order for this to work? What format will the data be provided to us in - how will you present the finished work so that it can be turned into article briefs?
Intermediate & Advanced SEO | | d.bird0 -
Any excellent recommendations for a sitemap.xml plugin?
Hi, I'm trying to find a sitemap generator/plugin that I can point my client to. My client is using Magento, and is one of the largest sports store i Norway (around 20 000 products). I've heard there's one that can set the <priority>according to page views, sold units, and other relevant parameters, and that also takes care of the other elements in the sitemap.xml.</priority> Any good recommendations out there? 🙂
Intermediate & Advanced SEO | | Inevo0 -
Going after multiple similar keywords, which is the better approach?
Let's say I have a page targeting a keyword, "New York Restaurants". There are also several "very close" variations of this keyword which I could also target. Here are the volume estimates: New York Restaurants - 100
Intermediate & Advanced SEO | | jcgoodrich
Restaurants New York - 40
Best Restaurants New York - 30
Best Restaurants in New York - 20
etc. Given this, which of the following is the better overall approach? A) Have one page and work all of these keywords so the page targets all of them. For example here try to weave in "Best" in different ways. B) Have multiple pages and use 301 redirects. Create one page only targeted at "New York Restaurants" and then create additional pages with the other terms in the URL and Headline, which 301 redirect to my "New York Restaurants" page. This is similar to how wikipedia does redirects, for example "Bourne 2" 301 redirects to "Bourne Supremacy". Thanks! | New York Restaurants | 12,100 | Medium | $0.93 | 0% | ACCOUNT |
| Restaurants New York | 2,900 | Medium | $1.00 | 0% | ACCOUNT |
| Best Restaurants in New York | 3,600 | Low | $0.69 | 0% | ACCOUNT |
| Best New York Restaurants | 2,400 | Low | $0.80 | 0% | ACCOUNT |
| New York's Best Restaurants | 260 | Low | $0.76 | 0% |0 -
Exact Match Keywords
Hello,
Intermediate & Advanced SEO | | Cornel_Ilea
Now that the Keywords Tool is gone, how can I see [exact match] search volumes on Google?
Thank you,
Cornel0 -
Should I redirect secondary keyword page
I have a reasonably high authority home page and have decided to optimise the home page to target a competitive keyword that previously had a specific page that was optimised on an internal page of my site that I have spent time building links to. The internal page has over 200 links to it so should I 301 redirect this internal page to the home page. Will that increase the auhority of the home page further? Or should I keep the internal page as a 'secondary' page for that keyword?. If I do have two pages don't I risk confusing google?
Intermediate & Advanced SEO | | SamCUK0 -
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