Hello one and all,
I have a column of 300 keywords. I would like to run a Google search on each keyword and then populate the adjacent column with the HEADLINE TEXT from the first google result.
e.g.
keyword = cookies
Headline text from 1st search result = how to delete and control cookies
I have tried and failed to use a Web Query in Excel. I managed to get it to search a single keyword and import results, but not a list of keywords. I suspect I should be using a Macro.
I found the following macro on Stackoverflow, but don't quite know how to get it to work/run on my data. Using VBA in Excel to Google Search in IE and return the hyperlink of the first result - Stack Overflow
Any help gratefully received.
Thank you
Charlie
I can do it on my Mac with Excel 2011 or PC with Excel 2010
I have a column of 300 keywords. I would like to run a Google search on each keyword and then populate the adjacent column with the HEADLINE TEXT from the first google result.
e.g.
keyword = cookies
Headline text from 1st search result = how to delete and control cookies
I have tried and failed to use a Web Query in Excel. I managed to get it to search a single keyword and import results, but not a list of keywords. I suspect I should be using a Macro.
I found the following macro on Stackoverflow, but don't quite know how to get it to work/run on my data. Using VBA in Excel to Google Search in IE and return the hyperlink of the first result - Stack Overflow
Any help gratefully received.
Thank you
Charlie
I can do it on my Mac with Excel 2011 or PC with Excel 2010