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
-
How does Yoast SEO premium determine prominent keywords?
We are perplexed how Yoast determines which keywords to select on the page when ranking the top 5 prominent words in Insights. For example, we have a page where birthday parties is clearly the primary keyword. It is used an an H2, in body copy and tagged on images. Yet it does not show up at all. The term 20 Fiesta game points ranks #1. It is mentioned one time on the page in a bullet within one of 5-6 blocks. 40 Fiesta game points ranks 3rd and same situation. Waterpark ranks 4th and is mentioned twice on the page as a bullet of featured activities. But there ar 4-5 other attractions listed in the bullets higher? We have looked as tutorial videos and no one mentions how Yoast determines prominent keywords. Thanks in advance for steering us in the right direction.
Intermediate & Advanced SEO | | Teamzig0 -
Linking to own homepage with keywords as link text
I recently discovered, that previous SEO work on a client's website apparently included setting links from subpages to the homepage using keywords as link text that the whole website should rank for. i.e. (fictional example) a subpage about chocolate would link to the homepage via "Visit the best sweet shop in Dallas and get a free sample." I am dubious about the influence this might have - anybody with any tests? I also think that it is quite weird when considering user friendliness - at least I would not expect such a link to take me to the homepage of the very site I was just on, probably browsing in a relevant page. So, what about such links: actually helpful, mostly don't matter or even potentially harmful? Looking forward to your opinions! Nico
Intermediate & Advanced SEO | | netzkern_AG0 -
Excellent performance in BING, terrible performance in GOOGLE
Dear all, We're struggling with the SEO of our platform www.taobao.nl for 6 months now. I posted some matters before on the MOZ forum and followed up the ideas that i received (tnx again 🙂 But so far there really isn't much result. Recently i found out that my platform is doing excellent in search engine Bing.com (ranking top 3/4 on my main keyword 'taobao') while my platform's homepage is still ranking dramatically in Google on the same keyword (ranking between position 180-280) Does anybody have some insight for me what could be the reason for this or how/where i can fund it out? Many thanks in advance! Sander
Intermediate & Advanced SEO | | benhond0 -
Why Keyword is not ranking
I have blog website - http://uncutweb.com/ My website ranked for keywords - What Color Shoes To Wear With Gold Dress, Keywords is having Moz Difficulty Score: 35% with A grade moz On page Score. But why my website is not ranked for What Color Shoes To Wear With Purple Bridesmaid Dress or **What Color Shoes To Wear With Coral Dress???**They have less difficulty score and having A grade.
Intermediate & Advanced SEO | | ross254sidney0 -
Impact of Domain Authority on Keyword ranking
Experts Please advise if there is any impact on Keyword rankings due to high or low Domain authority?
Intermediate & Advanced SEO | | INN0 -
SEOMoz Keyword Ranking Accuracy
Getting some mixed message on this. Is the keyword ranking informational available in SEOMoz based on the data in Mozscape or based on live Google data? Reason I ask is that my ranking for "crown moulding" for www.worldofmoulding differs: Based on the today's scan my www.worldofmoulding.com ranks in position 40 in Google. Based on a manual check with cleared out cache no local setting ... the site is 4th spot Running a third party check using "Advanced Web Ranking" tool it comes up in 9th spot, but they count the local business SERPs in which case it matches my manual search. It seems that SEOMoz is not in line with actual ranking. Any suggestion for what can be used to accurately asses SERP placement for terms?
Intermediate & Advanced SEO | | VanadiumInteractive0 -
Main Keyword penalized. And now?
Hello SEO comunity. In one of the sites that I work, our team won numerous keywords in the first searching results. Unfortunately, on june we lost the most important site keyword. It was a general Word, very disputed, that generated a lot of traffic to us. The problem: it droped from third to fifty position. I’d like your help to identify the possible punishments and than find the solutions. What could happened? Where do we start?  Is there any checklist to verify the punishments? What do you suggest to me? PS: We always do a clean job, getting away form the blackhat techniques; We didn’t received any notification from Google; During two year, the keyword was in the first ten positions. Actually, I'm looking for an explanation for what happened to me, to get my top10 again. Thanks
Intermediate & Advanced SEO | | webg0 -
Price Range: Top Notch Keyword Research
How many years would someone need to have to be experienced enough to provide a thorough job of providing me with keyword research?  I am willing to pay for the best job but I don't want to be taken to the cleaners...especially by someone that may not be giving me the best effort or that is not qualified. ( I was just quoted $200 an hour from an 18 yr old today) We are getting ready to change our URL's and add keywords but I am not sure which terms to add and in what order.  I have heard  put the most important words first but I am not sure which are the most important. 🙂 By my research we only have about 5 keywords but I am not sure. (Excluding long tail)
Intermediate & Advanced SEO | | Boodreaux0
