You can copy tabular information on a Web page and paste or drag the information into an Excel worksheet. It's an easy way to transfer and manipulate Web-based table data using Excel. Excel simplifies access to table data by making it available to anyone with a Web browser. After you paste the Web table into a worksheet, you can edit and format the table data like any other Excel information.
Copy a Web Table to an Excel Worksheet