Save both time and effort with this ever-so-easy way to copy web data into 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.

Email: hello@gmal.co.uk

Visit our contact us page

Or call 020 8778 7759

Back to Tech News