A little-known feature of Excel is the ability to import web pages. If you have access to data on a website, you can easily convert it to an Excel spreadsheet if the page is set up correctly. This import capability helps you analyze web data using familiar Excel formulas and interfaces.

Excel is a spreadsheet application optimized for evaluating information in a two-dimensional grid. If you want to import data from a web page into Excel, the best format is a table. Excel imports any table on a web page, only specific tables, or even all the text on the page.

Once you have found the website that contains the information you want, you can import the data directly into Excel with just a few clicks using the From Web tool. You can then customize the import options to your liking.

Here's how to import a data table from the web to a PC: