If a user has "Include Header Row in Data Extract" checked in their user preferences(GUAUPRF), then they can experience an issue opening exported CSVs with Excel.

Workaround:

  • Uncheck GUAUPRF : "Include Header Row in Data Extract"
  • Change the extract option on GUAOBJS to extract data block only instead of Key and Data Block.
  • Edit the csv file in notepad and put quotes around the ID header, e.g. “ID”

This should be resolved with an update to Banner Admin Common 9.3.14

https://ellucian.force.com/clients/a0x1M000005kyHrQAI