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
-
Homepage keeps disappearing and reappearing for important keywords every few days
My homepage keeps disappearing from the SERPS for my most important keywords. My home page has been in number 2 position for years. When the home page disappears it will not even show in a Google search for my business name although it is still indexed. When the home page is not showing an internal page shows instead but in position 6. When the home page is back the internal page does not show. There are no issues being reported in Google Webmaster. When I realise that it's down I do a fetch as Google and request reindexing. No idea if this is bringing it back or not? We are so worried about this and totally at a loss. As are the three SEO companies I've called. Would really appreciate it if someone could give some advice. NSFW https://goo.gl/dwA8YB
Intermediate & Advanced SEO | | GemmaApril1 -
Would a mass data update have a negative effect on SEO?
We have a large eCommerce site with the ability to do an export, change data, and import new data in mass. Over the 15 years that this site has been growing, it has accumulated several inconsistencies in product titles, descriptions, title tags, etc. The question is: If we were to update thousands of product titles ( 's on those pages) and some of the descriptions, would it have a negative SEO impact because of the groundbreaking number of products effected? Or would it only be for the better if they were all technically improvements (both in SEO and UX)? Thanks!
Intermediate & Advanced SEO | | frankandmaven0 -
Replicating keywords in the URL - bad?
Our site URL structure used to be (example site) frogsforsale.com/cute-frogs-for-sale/blue-frogs wherefrogsforsale.com/cute-frogs-for-sale/ was in front of every URL on the site. We changed it by removing the for-sale part of the URL to be frogsforsale.com/cute-frogs/blue-frogs. Would that have hurt our rankings and traffic by removing the for-sale? Or was having for-sale in the URL twice (once in domain, again in URL) hurting our site? The business wants to change the URLs again to put for-sale back in, but in a new spot such as frogsforsale.com/cute-frogs/blue-frogs-for-sale as they are convinced that is the cause of the rankings and traffic drop. However the entire site was redesigned at the same time, the site architecture is very different, so it is very hard to say whether the traffic drop is due to this or not.
Intermediate & Advanced SEO | | CFSSEO0 -
Proper way to include Location & Zipcode Keywords
I have a client that is insisting that I add a list of approximately 50 cities and 80 zipcodes that their business serves within the keyword meta tag. Based on what I have been reading this will do absolutely nothing to help improve their search ranking. What would be the proper way today to let inform search engines of the geolocations a business serves?
Intermediate & Advanced SEO | | mmurphy0 -
Best Keywords for my local niche
Hello, I'm a health coach helping people with multiple sclerosis. Here's my website: bobweikel(dot)com What do you think the top 4 local keywords would be for my niche? I'm in Boise ID. I'm thinking MS Boise MS Boise Idaho Multiple Sclerosis Boise Multiple Sclerosis Boise Idaho With your intuition, do you think these are valuable keywords for a coaching site? Also, can you think of any other keywords? I want this 100% white hat (no cloaking, for instance)
Intermediate & Advanced SEO | | BobGW0 -
Keyword Selection - Long Tail or not long tail keyword
Hi Friends, We have a keyword "plus size clothing" but we used this as "plus size clothing 2012" to Cover the both keywords "Plus size clothing" and "Plus size clothing 2012" My question is, are we still focusing on "plus size clothing" when use "plus size clothing 2012" instead of the main keyword.? What strategy do yo suggest that when to use long tail and when to not. (when I talk to use a long tail than it means use it prominently on the page as main keyword should be used.)
Intermediate & Advanced SEO | | alexgray0 -
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