Save time effort with this easy way to copy web data to excel. Instead of copying and pasting chunks of data at a time e.g., from a table on web page, simply copy the URL of the page you’d like to get the data from. Here’s how: 

- Open Excel. 

- Click on ‘Data’ (top menu) and click on ‘From Web.’ 

- Paste the URL of the web page containing the table of data into the field that loads and click on ‘OK.’ 

- Select the table you’d like to copy the data from and click on ‘Load.’ 

- The table of data will now load into Excel.