If a web page contains data in tabular form, then Excel is able to import these tables automatically. As an example, we will import a table from the Wikipedia page about Excel. Here's how we will go about it:
- Click on Data and then navigate to Get Data | From Other Sources | From Web, as shown in the following screenshot:
- In the dialog that pops up, we type in the URL of the mentioned web page and click OK, as shown in the following screenshot:
- Now, we will be able to see a list of available tables. Pick the one showing Excel's release history. A table preview is shown to the right, as shown in the following screenshot:
- As we did before, we can just load the data or edit it, transforming the values according to our needs. The final result is an Excel table.