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 -
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 -
Keyword difficulty and time to rank
Hello, Is there a correlation between the keyword difficult and the time it takes to rank ? In other words let's say I try to rank for the keyword "seo" and it is going to take 2 years to rank 1 st whereas if I go for "best seo tools in 2018" and it takes just 2 weeks ? Thank you,
Intermediate & Advanced SEO | | seoanalytics0 -
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 -
Replacing keywords by synonyms. Will it increase risk of google keyword stuffing penalization?
I have a page which is ranking already pretty well for a relative competitive keyword.
Intermediate & Advanced SEO | | lcourse
Google also ranks us on first page for synonym of keyword we optimize the page for (even though synonym does not appear on our page). I am now considering to replace some occurences of the keyword in the page by different synonyms, in the hope that our ranking may further improve for these synonyms.
However I am concerned that google may penalize me for keyword stuffing if I am using a wide range of synonyms of one keyword on our page. My plan is only to replace some occurences of keyword with synonyms. I am a bit nerveous here since page is already ranking quite well in a competitive niche. Any thoughts?0 -
Advanced SEO - What would you do after you run out of keywords?
Hello! Our company has been growing in terms of traffic and ranking well for a couple of years but we are now kind of stagnating because we just don't know what to do next. We have a good blog - and with our blogs, we have been targeting all major keywords with their related keywords as a bucket. - "keyword theme / page" for a long time. But it seems we now don't have any major keyword theme to write about. What is worse is that we don't see any traffic growth since 2014 September. (although we added many good blogs) So what would do you when you run out of keywords? or keyword themes? Would you just keep pumping in more blogs and hope that you get more clicks? or at some point, you just don't care about keywords and write whatever relevant to your site? Wouldn't it hurt our site if we create similar keyword themed pages? (like regurgitating our keywords?) or even same keyword targeting pages? You must have similar experience if you are an owner of a niche site. Can you please share your experience with this kind of headaches? Thank you and look forward to your comments.
Intermediate & Advanced SEO | | joony3 -
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 -
How many time should a keyword be used in the body of text?
We employee an outside agency to write content for our website as we do not have the ability in house to write unique and good quality content. They have just sent an article which is around 300 words. I told them the keyword phrases to use. When I got the document there is only 1 instance of the keyword phrase(s) in it. Now there seems to be a conflict here amongst posts I have read and general SEO advise as to how many times it should be present (SEOmoz indicates 4 times for instance), our outside agency says it doesn't matter. Now if I have a page optimised for 2 keywords this starts making things tricky and probably looks keyword stuffed to the reader. Assuming the keywords are present once in meta tags, H1, meta descriptions and alt text, what do people think is best practice taking into account recent panda updates? Thoughts appreciated. Thanks Craig
Intermediate & Advanced SEO | | Towelsrus0