Learn how to a build a cloud-first strategyRegister Now


How to easily run WebQueries in Mac Excel like i could in Win Excel

Posted on 2004-12-01
Medium Priority
Last Modified: 2010-04-25
I am working in Excel X for mac Service Release 1 and trying to do web queries like i can in Excel on my
PC.  I can't get to my pc to find the correct procedure, but i dont remember it being this hard to find.  Help files are of no use.

I want that "web query" wizard like on my pc where i can navigate to the correct page, select the table to import and everything. I just cant find it in mac excel.

Could you please tell me how to do it, step by step without having to make my own queries in a text file like microsoft says?

If this is not possible in mac Excel, is there a free third party software or add-on that can do the same job, that can be run by an excel macro?

Please help
Question by:mxgrogg
1 Comment
LVL 81

Accepted Solution

byundt earned 2000 total points
ID: 12723299
I don't see a web query wizard in my copy of Excel X either.

Apparently, Microsoft expects us to edit a query file. You access those from the Data...Get External Data menu item. Choose the Run Saved Query, then double-click one of the four sample queries and modify it. But I couldn't modify the web query very much.

I next created a web query file *.iqy in Excel 2000 and imported that into Excel X. Still a pain in the butt, but at least I was using a real wizard to build the web query. FWIW, Excel 2003 does it much nicer than Excel 2000.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Package creation on OS X uses the PackageMaker utility installed as part of the XCode development suite ( on the OSX Client CD).  Packages can be installed as part of the machine build process, or later using Apple Remote Desktop. They are generally…
There is a security feature on iOS devices that is nearly impenetrable when it has been activated.  This article will provide some possible solutions as well as necessary steps to take to ensure you do not end up with a locked device.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question