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
-
Ideal Frequency of my related keywords
Let's say on my keyword If I take the 1 st 20 results of google they have an average number of words per page of 3000 words. On my page I only have 1500 words. Does it mean that the frequency of my related keywords should be half of what the others have ? What about if I am over their frequency is it a problem also ? Thank you,
Intermediate & Advanced SEO | | seoanalytics0 -
Data Vocab or Schema?
Hi I've always used schema mark up in previous companies, however product pages on the site I'm currently working on are in data vocab. I cant find much about data vocab, so is it best to move away from this? I need to update the mark up on our product pages - so want the best mark up for this Thank you
Intermediate & Advanced SEO | | BeckyKey0 -
Mega Good Bulk Keyword Tool
I have over 1000 keywords to sort out , I need a tool that picks up on variations and symmons. Does anyone know of a very good tool that is available? If not I'll do it the long way round with Excel 😞
Intermediate & Advanced SEO | | seoman100 -
Use a language extension or a keyword as an extension?
If it's technically necessary to add an extension to a domain URL... Should I use brand.nl/nl or should I use brand.nl/keyword as the homepage? In my opinion it's better to use the language extension as it is much easier for other websites to link to. The client could make a separate page with content about the keyword. I also think it's much more difficult for direct traffic to access the website with this long URL. Any other thoughts?
Intermediate & Advanced SEO | | WeAreDigital_BE0 -
Generating Rich Snippets without Structured Data
I noticed something in Google search results today that I can't explain. Any help would be appreciated. I performed a real estate based search and the top result featured a rich snippet showcasing the following... Address Price Bd/Ba
Intermediate & Advanced SEO | | RyanOD
912 Garden District Dr #17. Charlotte, NC 28202 $179,990 3 / 2
222 S Caldwell St #1602. Charlotte, NC 28202 $389,238 2 / 2&1/2 However, when I visit the page associated with this information, there is no Schema to be found. In fact, the page is, for the most part, just a large table listing homes on the market. The table headings are Address, Price, and Bd/Ba. Is it common for Google to use table based data to generate rich snippets? What is the best way to influence this? In the absence of Schema (as the page we are talking about has no Schema implementation), does Google default to table data? Has anyone seen this behavior before and, if so, can you point me to it? EDIT: I've now come across a few other examples where the information is not in a table, but rather in divs. Why are such sites (you can find some by searching for "[ZIPCODE] real estate") getting this treatment?0 -
Best Keywords for my local niche
Hello, I'm a health coach helping people with multiple sclerosis. Here's my website: bobweikel(dot)com What do you think the top 4 local keywords would be for my niche? I'm in Boise ID. I'm thinking MS Boise MS Boise Idaho Multiple Sclerosis Boise Multiple Sclerosis Boise Idaho With your intuition, do you think these are valuable keywords for a coaching site? Also, can you think of any other keywords? I want this 100% white hat (no cloaking, for instance)
Intermediate & Advanced SEO | | BobGW0 -
Why google does not show my site on my branding keyword?
Hi, I am the site owner of http://www.lankahq.net. It is a youtube video hosted website. 95% of the video contents are daily telecasting TV shows and categorized to make easy to find the specific video of the day of preferred program of the viewer. About 1 year ago suddenly disappeared my site from the google. Before happened that it was performing very well in search. Google showed my site contents within few minutes after I update in their search results when someone search for that. At the moment it does not show even some one search for "lankahq". It showing only if search for "lankahq.net", "lankahq.com" or "www.lankahq.net" something like a search keyword related to my domain name. Some other websites have added my branding keyword LankaHQ as a user of their site and they showing on top of Google. But not mine. It is much appreciated if someone can have a look on this matter. I can not find where is the problem.
Intermediate & Advanced SEO | | cprasad0 -
No longer to be found for "certain" keywords.
I'd like to see if anyone could potentially shade a light on this rather strange scenario: Basically yesterday I noticed that we are no longer to be found for 'certain' keywords that we had page 2-3 ranking. Yet, for other keywords we still appear on page 2-3. These keywords are very competitive and our rankings has constantly improved in the course of 5-6 months. Now my question is that what could or may have contributed to the fact that for only some keywords we are no longer to be found? Another question is, can Google remove you from their SERPs for certain keywords 'only'? Thank you,
Intermediate & Advanced SEO | | micfo
Maximilian.0