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 press Enter.

Select the table data in the Web page you want to copy.

Open the Excel worksheet where you want to paste the table data.

Right-click the taskbar, and then click Tile Windows Vertically.

Drag the table data from the Web browser window to the location on the worksheet where you want the table data, and then release the mouse button.

Did You Know?

You can use copy and paste to transfer table data to Excel . In your browser, select the table data you want, click the Edit menu, click Copy, switch to Excel, click the cell where you want to place the table data, and then click the Paste button on the Standard toolbar.