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!
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 -
Title tag: Long tail words or keyword dilution?
Hi all, I am a newbie to SEO. Lately, I have been struggling to optimize my title tag. Ones say that we should have long tail words in title tags because long tail words improve click through rate and generate quality leads. On the other hand, ones say that putting other words in the title tag will dilute the main keyword that my page ranks for. Do keywords really dilute each other in the title tags? I am really confused. Let me give this an example: Web Design Services | Company Name Web Design Services with Conversion Focused | Company Name Which one would you prefer and why? Thank you. 😄 Best, Raymond
Intermediate & Advanced SEO | | Raymondlee0 -
How to measure traffic for a keyword
Sitting in Country A I want to see how much traffic a particular keyword receives in Country B. Whats the best way to do it? Also, will the search results differ if I am analyzing the above sitting in Country A viz-a-viz Country B. In other words, will the IP of the country I am making the search from play a role in the results?
Intermediate & Advanced SEO | | KS__0 -
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 -
My website is not ranking for primary keywords in Google
I need help regarding some SEO strategy that need to be implemented to my website http://goo.gl/AiOgu1 . My website is a leading live chat product, daily it receives around 2000 unique visitors. Initially the website was impacted by manual link penalty, I cleaned up lot of backlinks, the website revoked from the penalty some where around June'14. Most of the secondary and longtail Keywords started ranking in Google, but unfortunately, it do not rank well for the primary keywords like (live chat, live chat software, helpdesk etc). Since I have done lot of onsite changes and even revamped the content but till now I dont find any improvement. I am unable to understand where I have got structed.
Intermediate & Advanced SEO | | sandeep.clickdesk
can anyone help me out?0 -
Will multiple domains from the same company rank for the same keyword search?
I'm trying to convince people that we need good marketing reasons for starting multiple domains, as it will be more difficult to rank multiple sites. Does anyone know if Google actively discourages multiple domains from the same company appearing in the search results for the same keyword? We are creating a separate content website which is related to an existing company website. Would you agree that is best to have these sites on one domain with the content site on a sub-domain perhaps? I'm worried about duplication of effort and cross-keyword targeting in particular. These sites would not have duplicate content.
Intermediate & Advanced SEO | | RG_SEO0 -
Google places keyword variations
Hi all, I have a site that is ranking #1 in Google Places for its main <city><keyword>search... but it does not rank for any of its basic keyword variations, which I find very confusing.</keyword></city> ie (just an example) Chicago Caterer (ranked #1 in google places)
Intermediate & Advanced SEO | | x2264983x
Chicago Caterers (not ranked in google places)
Chicago Catering (not ranked in google places)
Chicago Catering Company (not ranked in google places)
Chicago Catering Companies (etc..) How can I secure a google places ranking for these simple keyword variations? Do I build links to the google plus page using that anchor text? Do I get citations that contain that keyword somewhere on the page? Do I optimize for these keyword variations on the actual website itself? (not the places listing). Obviously I don't stuff these keywords into the google places listing. Any help would be much appreciated!0
