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
-
Does Google understand misspellings in terms of what keywords I should optimize a page for
Hey there! This is sort of an oddball question. We do a lot of hospital websites. One client that we have spells "Orthopedics" as "Orthopaedics" which is another spelling. When I did initial keyword research the volume for Orthopedics as I expected is much higher. However when I do a test search for "Orthopaedics" it looks like I'm getting the same results and Google is highlighting in the content "orthopaedics" even though my search query was "orthopedics". What I'm wondering - is it the same thing to optimize for "orthopaedics" or is it a recommendation I should make to the client to change to "orthopedics" Thanks!
Intermediate & Advanced SEO | | CentreTEK0 -
High or low volume keyword
Does it take longer to rank on high volume versus a low volume keyword ? if so why Thank you,
Intermediate & Advanced SEO | | seoanalytics0 -
Keyword ranking verse all other data
Hi there I have just joined Moz so I am not sure if i am doing a good job of analysing all the data, but from what i can see i have a few questions: 1. I seem to have a fairly high visibility compared to a few other competitors 2. All the other competitors i am looking at have a much lower domain authority 3. I win the link metrics in all categories compared to my competitors 4. I have a page optimisation score of 94 5. I dont have any crawl issues (except that i just changed to https and i believe there is a synching issue with Moz and cloud flare..) YET I barely rank for any of the main keyword in my industry.... Kitchen, New Kitchen, Kitchen Renovation etc. I also have a page optimisation score of 94 for related keywords. I feel like i am really missing a big point and was hoping I could get your expert thoughts on this 🙂 Thanks so much! PS my domain is www.bluetea.com.au
Intermediate & Advanced SEO | | bluetea0 -
Is adwords data in organic ranking relevant?
we have noticed that without our adwords, our bounce rate is about half (outstanding rate) as compared to when we enable adwords (relatively bad). This of course amplifies across the board for other engagement metrics. So basically it looks like our website is not deemed too relevant and engaging when we bring in PC as compared to organic views. Does anyone have information if the search engines use this data without correcting out the PC visitors brought through adwords? this would mean to us that without having adwords we have a much better chance of ranking organically. very curious about what your experiences are as experts! Thank you in advance! Cheers, Nima
Intermediate & Advanced SEO | | TVape0 -
Do Structured Data Errors Hurt Your Rankings
Hi, I noticed we had a 161 structured data erros. Almost all of them said "Update missing." I included screenshorts. Are these hurting me? If so, what can I do to fix them? Thanks, Ruben UfzeAFi YjLhimj
Intermediate & Advanced SEO | | KempRugeLawGroup0 -
Weird Page switch for a keyword in Google Rankings
Over this past weekend Google switched the page which usually showed in search results for keyword benchmarking. It went from from http://www.apqc.org/benchmarking to http://www.apqc.org/benchmarking-portal/osb. Also on Google the Rankings for the keyword 'benchmarking' sank from 15 to 47 for http://www.apqc.org/benchmarking Just looking for some theories or ideas or anyone that has had this happen to them.
Intermediate & Advanced SEO | | inhouseninja0 -
Local ranking (keyword) strategies
Hello SEOmozers, I've been working on improving all components of my SEO skills for the past 6 months. I have definitely had some great victories and some gray defeats. My newest challenge is local ranking for a home improvement company. My target is to rank them locally with Google within the top 7 results. I have managed to do so, but only for one keyword "windows and doors CITY". My campaign, in terms of anchor text has a wide variety of long and shortail keywords, I have not concentrated on the above keyword. My question is, how do I go about to rank this website in the local results for all other keywords "windows CITY", "window replacement CITY", etc... What I don't understand is how Google picks up which keywords to rank the website locally for, and which ones to ignore. Any information will be well received. Cheers, Nikster
Intermediate & Advanced SEO | | thenikster0 -
Different TITLE for the same page appear for different keywords
Hi there Can anyone advice please on this funny/strange issue I have title on home page. When I type some of keywords the homepage appears in SERP with shortcut TITLE (just one keyword there). But when I type company name I have full TITLE. Could anybody advice please what can be a problem and how to fix it?
Intermediate & Advanced SEO | | fleetway0