Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Friday, March 13, 2009 – Permalink –

Web Queries

Do You Question the Web?


This feature can make data acquisition a lot easier than Copy-Paste-Reformat-Try again.

"Generally, though, people tend to overlook the option of using the Web as a data source for Excel, be that source the Internet, an intranet, an extranet, or a Web Service. But they shouldn't. Web queries are an easy, yet remarkably flexible and predictable way of bringing data into Microsoft Excel from anywhere on the Web. You can point a Web query at any HTML document that resides on any Web server - or even on a file server, for that matter - and pull part or all of the contents back into your spreadsheet...When you start using Excel's Web queries, you will realize they are almost as limitless as the Web is.

Well Kept Secret

On the menu bar, go to Data>Import External Data. (In 2007, Data>Get Extrnal Data>From Web). Then, select Import Data to use an existing Web query or select New Web Query to build a new one.

Web Query

Also see:
Vertex42.com:
Excel Web Query Secrets Revealed


MSDN.Microsoft.com/library
Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services

Updating Excel From the Web

And:
Web Queries and Dynamic Chart Data in Excel 2002

[Edited entry from 1/15/2004]




See all Topics

Labels: ,


<Doug Klippert@ 3:43 AM

Comments: Post a Comment

Links to this post:

Create a Link