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
-
Hyphens in Keyword
Hi everyone, I was wondering if anyone had any experience of whether Google treats keywords with hyphens differently. One of my websites main keywords is 'buy to let', however all across our website it is referred to as 'buy-to-let'. People always search without the hyphens. I recently heard that Google may only treat us as a highly relevant match and not an exact match for this keyword. I was wondering if anyone had any experience of this, and what is the best course of action to take. Thanks
Intermediate & Advanced SEO | | brian-madden0 -
Blog page and homepage ranking next to each other for same keyword
Hello, I have my homepage that has been existing for 10 years that is ranked in 18 th position on google for the keyword luxury bike tours. This homepage doesn't have any external link or internal links saying luxury bike tours and nowhere in the title or on the page do I have the word luxury. I only have the words bike and tours. I created a blog page 24 hours ago that has the word luxury, bike and tours in the title and it is ranked in 19 th position just behind my homepage. I am wondering how it can be there and my homepage just be one spot above with all the history and linking it has ? Is it due to the fact that I have the word luxury in the title ? Is it just because my internal linking structure is correct and this blog page is brand new and will my homepage rank higher in the near future but see that I just redid the structure I need to wait a few months ?
Intermediate & Advanced SEO | | seoanalytics0 -
Home page ranks for most keywords with no SEO
Hi Guys, The keyword I am trying to rank is on seperate page with its own Optimization in place. However the HOME page of website starts ranking for that keywords . The keyword is mentioned on Home page Just once in content description, that's all. What should be my ideal strategy. Deleting the Sub Page, will that improve the SEO of my home page and improve the Rank for that keyword ? Also I can see my Own YELP pages rank better than the actual website for few terms . Any way around this ? A Part from building links to page ?
Intermediate & Advanced SEO | | aus00071 -
Google Trends - API? Anyone Using This Data?
I'm looking for a way to track change in search volume for dozens or hundreds of keywords but Google Trends doesn't have an API as far as I can tell. Does anyone know of a good tool or method of extracting large amounts of data from Google Trends?
Intermediate & Advanced SEO | | wattssw1 -
Should I remove Meta Keywords tags?
Hi, Do you recommend removing Meta Keywords or is there "nothing to lose" with having them? Thanks
Intermediate & Advanced SEO | | BeytzNet0 -
Adding another keyword phrase to home page.
I finally reached the #1 ranking for my websites main keyword phrase. There are two more equally good keyword phrases that have my main two keywords plus one additional page. Can I shoot for both of those or should I limit it to just adding one more keyword phrase for a max of two? For Example. I rank #1 for Horse Buggies (our domain is the main two keywords) (Example) The other two equally good phrases with a little more traffic are Horse Large Buggies (I rank #29)and Horse Giant Buggies. (#46) What is the best way to start ranking for those terms....without saturating or cannabolizing my current terms? We are about to change the URL's on some of our pages...so maybe I could add Large and Giant to the URL. Any suggestions? I sure would like to capture the other two keyword phrases. #1 URL additions? ( I think this would just rank me higher for the new pages) #2 Would getting new links with those two new keyword phrases in the alt text help or is that black hat? #3 Adding more of those keyword phrases to my home page? Thank you, Boo
Intermediate & Advanced SEO | | Boodreaux0 -
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 -
Is DOCTYPE important for SEO?
Hello fellow Mozzers. I am just having a brief look at a potential clients website before speaking to them tomorrow and whilst looking at the source I noticed that they don't appear to have a clear definition for their Doctype. All the have at the top of each page is I have to admit that Doctypes aren't my strong point but I know that they are normally slightly more descriptive than this. Can this have any effect on rankings? or is this just an issue for W3C validation? Thanks 🙂
Intermediate & Advanced SEO | | AdeLewis0