Instant WebQuery
A free Excel add-in by Jim Gordon, co-author of
Office 2011 for Mac All-in-One For Dummies
Instant WebQuery imports
HTML row and column tables from web pages into Excel worksheets.
System Requirements
Requires Microsoft Excel:
For Mac 2011 or 2014
For Windows 2007, 2010, or 2013
If you
did a custom install of Office and omitted Visual Basic for
Applications (VBA), you must run the Office installer and
install the missing VBA components.VBA is required to run
Instant_WebQuery add-in.
Download instructions
- Click here to download
Instant_WebQuery.zip
- Choose your
browser's "Save" option.
- You may need to
check your browser's preferences to learn where your
browser saves downloaded files.
- Do not choose
"Open" or "Run this file in its current location."
- Double-click the downloaded
.zip file to decompress it.
- The decompressed
file is named Instant_Webquery.xlam
- Put Instant_Webquery.xlam
into your add-ins folder.
- On a Mac, the default
folder for add-ins is Applications:Microsoft Office
2011:Office:Add-Ins
- On a PC, set the
add-in location using File > Options > Add-In
- Activate Instant_Webquery.
- On a Mac, in Excel, go
to Tools menu and choose Add-Ins. Click the Select button,
and then navigate to and select Instant_WebQuery.xlam,
then click the Open button. If prompted, choose Enable
Macros.
- On a PC, use File
> Options > Add-ins > Manage Add-ins > Browse
to locate and open Instant_WebQuery.xlam. You then go to
File > Options > Customize Ribbon and make sure that
the Add-Ins tab is activated. Quit Excel. When you re-open
Excel you will see an Add-ins Tab in the Ribbon and that's
where you'll find the Add-in.
Easy to use
Mac Excel:
Instant_WebQuery adds a new command called WebQuery from URL
to the bottom of the Data menu. Choose Web Query from
URL to display the Instant_Webquery input form. Paste the
URL of the web page from which you wish to extract HTML tables,
and then choose either to import just the tables, or choose to
import everything that Excel can render (which ususally isn't much
more than just the tables). Allow a minute or so for the import to
complete.
Excel 2007 through 2013 for Windows:
Instat_WebQuery adds a new command called WebQuery from URL to the
Add-Ins tab of the Ribbon. Choose Web Query
from URL to display the Instant_Webquery input form. Paste
the URL of the web page from which you wish to extract HTML
tables, and then choose either to import just the tables, or
choose to import everything that Excel can render (which
ususally isn't much more than just the tables). Allow a minute
or so for the import to complete.
Excel 2000 through 2003 for
Windows:
Instant_WebQuery adds a new command called WebQuery
from URL to the bottom of the Data menu. Choose
Web Query from URL to display the Instant_Webquery
input form. Paste the URL of the web page from which you wish
to extract HTML tables, and then choose either to import just
the tables, or choose to import everything that Excel can
render (which ususally isn't much more than just the tables).
Allow a minute or so for the import to complete.
The resulting table is called a
QueryTable in Excel. You can adjust settings for each QueryTable
by rightclicking anywhere in the QueryTable and choosing "Data
Range Properties" from the pop-up menu. These settings affect only
the current QueryTable's data range.
Instant_WebQuery works only with properly made
HTML tables. Unfortunately, many data providers are clueless about
how to properly arrange data in rows and columns on web page HTML
table. Instant_WebQuery
will do the best it can with what it's given from the web site.
You may have to manually adjust row and column heights. Not all
web pages will look right once imported into Excel.
Support Information
Disclaimer:
Instant_WebQuery comes as-is. There is no warranty.
There is no support.
Share freely
- You are free to use Instant_WebQuery
as much as you like without any time limit.
- You are free to distribute Instant_WebQuery
to anyone and everyone.
Updated May 18, 2014