Web queries are especially useful for retrieving data that is in tables or preformatted areas.
(Tables are defined with the HTML tag.) The retrieved data does not include pictures, such as images, and does not include the contents of scripts.
To create a Web query, you need access to the World Wide Web (WWW) through your company's intranet or through a modem on your computer or network.
If you are using Excel, you can import data that originates from a Web page by using the New Web Query dialog box.
(On the Data tab, in the Get External Data group, click From Web.) If you are using Internet Explorer, there are two ways to get external data into Office Excel: Note: You can also open any HTML file, MHTML file, or well-formed XML file in Excel.
When you open an HTML or MHTML file, you get the entire Web page, but you might lose some formatting, scripts, image files (HTML only), or lists of data in a single cell.
When you open an XML file, you have the option of applying one or more referenced stylesheets. A parameter query is a query that prompts for input every time that you run it.
You can create or run a Web query to retrieve text or data from a Web page.
Web pages often contain information that is perfect for analysis in Excel.Depending on your needs, you can retrieve data that is refreshable.That is, you can update the data in Excel with the latest data on the Web page.Or you can retrieve data from a Web page and keep it static on the worksheet.You can use a Web query to retrieve refreshable data that is stored on your intranet or the Internet, such as a single table, multiple tables, or all of the text on a Web page.Then you can analyze the data by using the tools and features in Excel.