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 -
Tips for optimizing website for one long term keyword
Hello, I have quite specific long term keyword (4 part keyword) for which I would like to rank as high as possible and other keywords would come automatically, I know there's lot to it how to do it properly, but is there any good tips you could help me out with? I have 4-5 different pages with the keyword related product, would it be smart to optimize them all for the one keyword or optimize just one of those pages and leave others with other information, this I believe would be important subject to decide? I know I could add the exact long term keyword since it's related to content to titles, h1 headers, alt tags , file names and url, but would it be smart to use the optimization for that exact long term keyword on all those pages or just one? This is very important subject for my business and any advice will be most highly valued. Many thanks
Intermediate & Advanced SEO | | bidilover0 -
How many keywords should each of my pages realistically be targeting?
Hi All, I run a small bank's website and we're currently in the process of organising a site rebuild. Whilst this will be extensive and have many SEO factors to tick off, my concern now is to get a "realistic" number of keywords each of my pages should be targeting. For instance for my car loan page i've done a review on moz's keyword tool and have picked 3 or 4 good keywords - but the problem is there are realistically 7-8 that would suit. Also this is based on Bing's info only. Can anybody point me in the right direction (or have some google confirmed resource they can quote me) Cheers as always 🙂 Dave
Intermediate & Advanced SEO | | CFCU0 -
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 -
One word Keywords
Hey as you know that as a seo we are, we always optimize keywords which are at least 2 words, and lets say I'm trying to optimize a page for terms like "man clothing, man london clothing, man great collection, man stylus collection" and as you can guess I optimize this pages for this keywords by inputting them into title heading tags and body.
Intermediate & Advanced SEO | | atakala
So my question is , what if google takes "man" phrase from my 2 words keywords, and pretend as a my keyword. (I mean what if google thinks my keywords is man because as you can see in all of the keywords "man" is in all of them.)
And what if Google thinks the density of "man" probably would be %20 which is astronomic number.? Sorry for my bad english.0 -
Are footer links important?
We currently display a list of links in the footer of our site to help boost SEO. They were put in place years ago and in a recent discuss with our UX team they requested we remove them from the site. Do footer links have any value? Or is this an old dated practice that no longer works? If we remove the footer links should we expect to see if have an impact on our SEO traffic?
Intermediate & Advanced SEO | | Mivito0 -
Importance of text above the fold
I am being advised by an SEO that each page of my ecommerce site must have a significant block of unique text "above the fold" to do well in Google post-Panda. This recommendation is at odds with what my design/usability/conversion people want to see. The current site design features eye-catching graphics just below the header and goes right into product listings, with SEO text near the bottom of the page. How important is it to have SEO text near the top of a page?
Intermediate & Advanced SEO | | mhkatz0 -
Targeting combination of keywords
Hi, On our website Vliegtickets.nl we are now targeting one combination of keywords " flights + destination". We are working on a new website and we are rewriting texts for the launch. Our idea is to target again on the combination " flights + destination", but also target other combinations. Our intention is to have a first introduction text targeted on " flights + destination" and have lower parts of texts (descriptions) targeted on the long tail, with use of keywords like flight / fly to / cheap tickets to etc. Our page will be divided like this: 1. introduction text max 150 words (h1 + h2) targeted on " flights + destination"
Intermediate & Advanced SEO | | vliegticketsnl
2. box 2 Cityguide snippets / content in context of destination - targeted on city name
3. box 3. Question: target on new generic keywords + combination of destination What is your point of view on box 3? Is it the right way to target a broader range of keywords? Should we use these long tail keywords (fly to / flights / cheap flights...) also in meta title / meta description / strong kwds, etc? Or will it be sufficient if we target on one combination and use those synonyms in a lower density? Or is it best to keep the focus on one main combination and other pages on other keyword combinations? Best regards, Vliegtickets.nl0