Eastern Michigan University

Exporting to Excel

You can export a VOD report as an Excel file for further sorting. To export as an Excel file, follow these steps:

  1. Click the View link below the report title.
  2. For the Output Format parameter, select Excel - Excel Exportable Format from the drop-down list
  3. Choose a Term Code from the drop-down list (except on current Majors/Minors reports).
  4. Select at least one parameter from College, Department, Major, etc.
  5. Click the OK button to perform your query.

Once the data is returned, you will notice fields overlapping each other. This file is formatted for Excel; you need to export the data in order to view it:

    1. Click the Export this report button in the BOE toolbar.
      The Export Report window will be opened. BOE Export to Excel
    2. At the top of the window next to File Format, select Microsoft Excel 97-2000 Data Only (XLS) from the pull-down list.
      The page range will default to All.
      BOE Export to Excel
    3. Click the OK button.
      An Opening ePortfolio.xls window will appear.
    4. Click the Open With radio button and select Microsoft Office Excel from the pull-down list.
      Click the Do this automatically for files like this from now on checkbox to save time in the future.
      BOE Export to Excel
    5. Click the OK button to open your Excel file.