Skip to main content

HESA Student record 2010/11

Back to C10051

HESA Student record 2010/11

return to index

Version 1.0 Produced 2010-03-15

Manipulating data

Transferring information for valid entries and validation rules into spreadsheets

This can be done by creating a web query to retrieve data from web pages that contain tables or lists of valid entries. There is further information in Microsoft Excel Help, and has been tested in MS Office 2003, and briefly:

  1. In a browser, open the web page which contains the information you would like to import into Excel
  2. Copy the web page URL from the address bar
  3. Open Microsoft Excel
  4. Go to:

    Data Menu -Import External Data - New Web Query

  5. In the Address dialogue box paste the web page URL
  6. Click the Go button to the right of the box. This will display the page in the New Web Query window (it may take a minute or so to load large pages)
  7. Select the data you would like to import by clicking the yellow arrow icon
  8. Click the Import button at the bottom right of the New Web Query Window and import data into Excel as directed.
  9. Save the file

Contact Liaison by email or on +44 (0)1242 388 531.