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.
It is costly for us to have our systems down and really appreciate the speed that your team respond to any issue we have. I don’t believe we have had any problems which you have not been resolved.
- Warren Patmore -