How to scrape Google Autocomplete with Excel

If you have read something on this blog in the past, you should already know I like scraping with Excel (here I managed to scrape Twitter followers); if not, well, I guess you’ll learn it now.
Without wasting time on what web scraping is, and supposing you already know why scraping Google Autocomplete would be useful for SEO and not only, I’m going straight to show you how to scrape it without coding just using Excel combined with:

Step 3 – Getting rid of XML syntax

We want to extract the text from that XML, so we start deleting the code we don’t need:=RegexpReplace(
RegexpReplace(
DownloadString('http://suggestqueries.google.com/complete/search?output=toolbar&hl='&B2&'&q='&A2),
'((.*)toplevel>)??()?',
''
),
'/>',
';')