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
-
Homepage Ranking For Service Keyword (KW Cannibalisation)
Hi All! I will try and keep my question brief, any advice is greatly appreciated. I have a client that is a well establish coach hire company, naturally their main priority is to be ranking for 'coach hire' in their surrounding area. The homepage and /coach-hire/ page - both appear to compete against each other in the search results. The homepage is positioned higher up the rankings, it also has historical backlinks with anchor text relating to coach hire, whereas the /coach-hire/ page doesn't have all that many backlinks. The company has a few services that it offers through it's website - Coach Hire, Coach Day Trips & School Bus Services. The Day Trips and Bus Services pages rank well for their respective keyword. My question therefore, is - should I focus on making the homepage the best page for the 'coach hire' term and forget about trying to get the /coach-hire/ page to outrank the homepage? If so, what's the best way of doing this in terms of what happens to the /coach-hire/ page? Any advice is greatly appreciate and if you need any other info, just let me know. Many thanks, Gareth
Intermediate & Advanced SEO | | meowth240 -
Keyword Cannibalization on Professional Service Firm
Hi all: We do ongoing SEO for a tax law firm. Their home page, which contains very little text is marked up in the title tag with the phrase 'tax attorneys and preparers.' We are getting warnings from our SEO software that individual bio pages for practitioners are cannibalizing the homepage for the keyword 'tax attorney.' Should I be concerned? The head of this firm is a very well known 'tax attorney.' Its kind of hard to describe him differently but we keep getting told his page competes with the firm's homepage for this search string. Thanks in advance.
Intermediate & Advanced SEO | | Daaveey1 -
Multiple keyword optimisation
What is the best way to optimise for multiple keywords for the same product? The situation basically is I have several products which I need to optimise currently only one page, the search terms that relate to the product are in some cases very different.
Intermediate & Advanced SEO | | seoman100 -
Why Is Google Webmaster Tools Pulling Zero Keyword Data?
I just linked a Google Webmaster Tools account to Google Analytics for a client, and Search Engine Optimization reports are showing up in Google Analytics as enabled, but there is zero keyword data, landing page data, etc., in the reports themselves. Has anyone encountered this?
Intermediate & Advanced SEO | | yoursearchteam0 -
Importance of Unique Content Location in Source Code
How much does Google value placement of unique content in the source code vs where it is visually displayed? I have a case where my unqiue content visually displays high on page for the user, but in the source code the unique quality content is below duplicate type content that appear across many other domains (think e-commerce category thumbs on left side of screen and 80% right side of screen unique stuff). I have the impression I am at a disadvantage because these pages have the unique / quality content lower in source code. Any thoughts on this?
Intermediate & Advanced SEO | | khi50 -
Two Webstites Targeting the Same Keywords
If I aquire a website in the same industry targeting the same keywords. Should I merge them into one? I understand it's a bad idea to have multiple websites promoting the same thing, but i'd like to capture the customer base of a competing website. What's everyone's thoughts? A- Merge new to main website with 301's? will google like that? B- Keep them separate? Will google like that? C- Don't bother. D- Toss the computer and get into Horticulture
Intermediate & Advanced SEO | | residualboulders0 -
Best way to get the keyword ranking at the top
I am working on site for around six months now.
Intermediate & Advanced SEO | | ray2810
I have done social bookmarking submission, directory submission, blog comments, forum submissions etc. Is there anything else i can do to make the rank go higher. nothing is working correctly.0 -
Strange Linking Data in Webmaster Tools
I run a site that was a Wordpress blog with Edirectory software for a directory on the back end. I've scrapped the Edirectory and built the entire site on Wordpress. After the site change I'm seeing about 700 404 Not Found crawling errors, which appear to be old Edirectory pages that no longer exist. My understanding is that they'll cycle out eventually. What troubles me is the linking data I'm seeing. In the "Links to My Site" area of Webmaster tools, I'm seeing 4,430 links to the "About" page, another 2,900 to an obscure deleted directory listing page and only 2,050 to the home page. I show 1,700 links to a terms and conditions pdf and other strange data. To summarize, I'm showing huge numbers of links to obscure pages. Any help would be greatly appreciated.
Intermediate & Advanced SEO | | JSOC0