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