Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
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
-
Why does the order of the keywords affect my SERP? And what can I do to improve?
Hi all, So, if you google "london life coach" my site appears #2 (www.nickhatter.com) But if you google "life coach London" my SERP seems to fluctuate between #3 up to #6. If you google "life coach in London" my SERP is a solid #2/3. I don't get it all. Would someone care to explain? Also, if you have any tips on how I might improve the EAT of my website please do feel free to weigh in! Many thanks,
Intermediate & Advanced SEO | | NickHatster
Nick0 -
Suddenly keywords Disappeared from Google Search Results
Hello Guys Please help me, suddenly all of my site's keywords are disappeared from google search result, most of keywords are no.1 on google but today after 6pm i see the traffic decreasing and when i search my keywords there is no any keywords in search result. Only homepage keyword is showing. Please Help what is Happening with me.
Intermediate & Advanced SEO | | mianazeem4180 -
How old is 404 data from Google Search Console?
I was wondering how old the 404 data from Google Search Console actually is? Does anyone know over what kind of timespan their site 404s data is compiled over? How long do the 404s tend to take to disappear from the Google Search Console, once they are fixed?
Intermediate & Advanced SEO | | McTaggart0 -
Keyword Ranking Fluctuations
Hi Guys I am currently working on a website where one of the keyword targets is fluctuating. The keyword is fluctuating between page 2 and page 5. What makes this strange is that we are not experiencing the issue with any other keyword targets. They are all ranking fine. It is only 1 keyword. The keyword target happens to be the main homepage keyword target - not sure if this makes a difference? The homepage targets 2 keyword e.g. Business Offices & Accessories. The homepage ranks perfectly fine for e.g. Business Accessories but is fluctuating for e.g. Business Offices! Very strange. What makes it even stranger - the keyword variations of the fluctuating keyword e.g. office for business - these variations are all fine and not fluctuating. Its only 1 keyword. If anyone has any ideas or feedback that would be great! Thanks, Duncan
Intermediate & Advanced SEO | | CayenneRed890 -
No matter what the keyword, only the homepage shows in the SERP
Hi, wondered if someone could help. My clients website shows up well for terms but its always the homepage rather than the targeted landing page. For example, if you search for "teeth whitening anglesey" they appear http://goo.gl/ohJdua however, its the homepage rather than the tooth whitening page http://goo.gl/uVI8gK Thanks Ade
Intermediate & Advanced SEO | | popcreativeltd0 -
Good or bad adding keywords in Pinterest description?
I added all keywords in description. Will this affect my website, Google takes this as negative way? I am not adding keywords on my own website, but adding keywords to third party website? https://www.pinterest.com/pin/304555993526970292/
Intermediate & Advanced SEO | | bondhoward0 -
Is it better to use geo-targeted keywords or add the locations as separate keywords?
For example... state keyword (nyc real estate) or keyword, state (nyc, real estate) = 2 keywords Thanks in advance!
Intermediate & Advanced SEO | | Cyclone0 -
How to Target Keyword Permutations
I have a client that wants to rank for a keyword phrase that has many permutations.. ex. "Alaska Hill Country Resort", "Hill Country Resort Alaska", "Hill Country Alaska Resort" But I'm wondering if I should target these all on the same page or not. I'm assuming all of these permutations are actually valid searches because I did my keyword research for 'exact match' keywords and got results like this.. (let me know if I'm missing something here, or if this sounds right) [Alaska Hill Country Resort] - 230 Local Searches [Hill Country Resort Alaska] - 140 Local Searches [Hill Country Alaska Resort] - 30 Local Searches The phrase we're targeting is their main keyword phrase, so I've chosen their home-page as the page to rank for this phrase. My thought is to optimize for the most popular phrase (ex. "Alaska Hill Country Resort"), and sprinkle in the other phrases throughout the copy. Next I would run a link-building campaign targeting the main phrase first.. then the next phrase, and so on, so that my anchor text is more heavily focused on the more popular terms, but I would also make sure to include the less popular terms. Do you think this is the best way to go about this? Do I really need to make individual pages for each of the permutations, or is it okay to target them all on one page since they are essentially the same keyword?
Intermediate & Advanced SEO | | ATMOSMarketing560