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.
The service that we receive is of the highest standard and we are completely happy that we have made the right decision to move our business to SMT IT Services.
- Chris Addis -