Ability to Export Master Schedule to Excel

Currently, the only option available to export the Master Schedule is to use the print option, or export to iCal or vCal and then convert that to excel. The process for converting an iCal to excel is very roundabout and difficult to accomplish well. 

We'd like to be able to export the Master Schedule with just the information that appears on that calendar (date, block, times) so that we can more easily manipulate the information in a spreadsheet to get the exact information we're looking for from the schedule.

  • Mike Lyons
  • May 20 2016
  • Attach files
  • Cristina Conciatori commented
    August 03, 2023 20:13

    This would be great. I tried the new print option for the master schedule, but it doesn't print nicely because we have so many blocks. Plus we really just want to easily share it with others so having it as an Excel file would be an excellent idea.

    I can't believe that this idea has been around for 7 years and has not been planned yet.

  • Jen Brakeman commented
    July 27, 2023 21:55

    This would be phenomenal! Especially when exporting for "By room", and especially if it'd be possible to exclude unused rooms.

    I know there's a "room utilization matrix" in the Reports section, but that one exports to a PDF in a way that our last period of the day always ends up on the next page (without the intro info copied over, so it's nearly impossible to use). AND when I export it to excel, it gives each course in a room its own row, necessitating the need for someone to manually clean it up.