Copying a Web Table to a Worksheet
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 browser. If you need to make changes to the table, you can use normal editing techniques in Excel.
Copy a Web Table to a Worksheet
Open your web browser.
In the Address bar, type the location of the web page with the table data you want to copy, and then ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.