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.
As key project members in many of our IT projects whether, actively assisted or simply advised what they do not know about IT, in our opinion isn’t worth knowing!
- Nadia Mullins-Hills -