eLearning

Download student bookings

  1. Home
  2. Staff Guides (Ultra)
  3. Microsoft Bookings for Courses (Ultra)

You can download student bookings to have an overview of how many bookings students have made.

  1. Access your course's Microsoft Bookings page from the UQ Bookings app.
  2. Click on the Export button. 
    Make sure you are on the Calendar tab on the service menu.

  1. Select a relevant date range.
  2. Click on the Export button.

  1. Click on the Save button to save the file to your designated folder. The default file name is BookingsReportingData; however, you may rename it to your course code if that is more appropriate.

The file type is TSV (tab-separated values). If your device does not have a relevant app to open the file, you will see:

You can convert the file to an Excel spreadsheet for easier access, following the steps below.

Convert TSV to Excel spreadsheet

  1. Open the Excel app on your device. 

  1. Open a blank Excel file.

  1. Click on the Data tab.
  2. Click on the From Text/CSV tab.

  1. Change the option Text Files to All Files.

  1. Select the file you downloaded from the Booking page. Click on the Import button.

  1. Click on the Load button.

  1. The Excel file with all data is available for you. You can Save as the file in your relevant location.