Importing Keyword Planner Data into Excel?

[nicole.healthline]

What is the most efficient way to import search volume information into excel? We have 130K keywords that we need search volume information for.

[danatanseo]

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!

[nicole.healthline]

So, there isn't any way to directly pull search volume directly into excel? I'm looking at a data set of 400K keywords