Clean Excel Exports
When you export a file from UMS it should not be merged or make it such a hassle to make it a usable spreadsheet. It gets tedious cleaning up every single export that is created. You should not have to unmerge and delete a million rows/columns.
CUSI recommends utilizing the "Export" button on the report screen vs. saving the report to Excel.
-
Brad Dial commented
When a user is attempting to export data from UMS reports, it is highly suggested to use the Export button from the Report Menu, and then selecting the output format of CSV. When using CSV, and not Excel, the data that is export will be formatted into its appropriate columns with headers.
Brad Dial
CUSI Product Team - QA Manager