Tech Tip – An Easy Way To Copy Web Data To Excel

27th July 2022

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.