Getting Data from Web Queries
You can import data into Excel through database and web queries and analyze data with formulas and formatting. You can insert columns within query tables and apply formulas and formatting. When data is refreshed, the formatting and analysis are retained. Excel helps you through the process of bringing data from a web page to your worksheet. You can create a new web query as you choose the URL and parameters for how you want to import the web data. Once you save the query, you can run it again at any time.
Get Data from a New Web Query
Click the Data tab.
Click the From Web button.
Type the address for the web ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
