• C11041 Campus Information System return date is 1 June 2012. View details
  • C12025 Staff collection coding manual version 1.3 is now live
  • C12061 KIS record coding manual v1.3 available at C12061
  • C11051 Student xml validation kit rules now available. Download kit
  • HE Business and Community Interaction Survey Publication 2010/11 to be released 24 May. Pre-order your copy now.
  • Did you know you can follow HESA on twitter? @UkHESA

Student record 2011/12

Back to C11051

Version 1.0 Produced 2011-11-14

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 Institutional Liaison: liaison@hesa.ac.uk, tel 01242 211144