How to create web query on Mac Excel 2011?

Question

I am trying to import data from a website on my worksheet, but when I click on import data from a new database query, it shows an error of saying:

" Microsoft Query is not installed"

I have searched every where but could not find the solution. Please help me out..

Answer 1

The process is a bit different on the mac.

1. In the Finder, go to /Applications/Microsoft Office 2011/Office/Queries
2. Open any file you see there in a text editor
3. Replace the URL with your query URL
4. Save as a new file back in that same Queries folder
5. In Excel, go to Data > Get External Data > Run Saved Query
6. Pick the file you just created from the list

So, for example, to pull the results of a Google search for "tacos", you could create a text file that looks like this and save in your Queries folder:

WEB
1
https://www.google.com/search?q=tacos

Selection=EntirePage
Formatting=RTF
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False