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

    1. At the top of the window next to File Format, select Microsoft Excel 97-2000 Data Only (XLS) from the pull-down list.

BOE Export to Excel

    1. The page range will default to All.
    2. Click the OK button. An Opening ePortfolio.xls window will appear.
    3. Click the radio button next to Open With and select Microsoft Office Excel from the pull-down list.
      (You can click the checkbox next to Do this automatically for files like this from now on to save time in the future)

BOE Export to Excel

  1. Click the OK button to open your Excel file.
Division of Information Technology

118 Pray Harrold

Ypsilanti, MI 48197

Phone: 734.487.3141