Did you ever need to put a table from a web site into an Excel file? If so, you probably used copy & paste and then fixed all the formatting errors and wasted a lot of time.
There is another way you may not be aware of: Excel has an import feature to load data from web sites (and many more formats like PDF files).
Go to Data > Get Data > From Other Sources > From Web to open the import feature:
Excel opens a dialog where you can enter the URL of the web site with the data you need to import:
As the next step you can choose the authentication method. If you do not need authentication, you can select Anonymous:
Excel will now fetch the web site and shows you a list of all tables it could find. You can go through the list and check in the preview pane if this is the table you need:
Click on Load and Excel will put the data from the web into your Excel sheet:
The next time you need to import data, try the options Excel offers under Data > Get Data. It can save you a lot of time.