Converting OMR data to Excel Format (OMR2XL)
Description and Directions


OMR2XL is an HTA (Microsoft HTML Application) utility to convert the output from URI Optical Mark Reader Services to Excel spreadsheet format. The purpose is to facilitate user-written OMR data analysis (as described in ITS Handout # 32, page 3) without the need to use SAS or similar programs. The utility was developed independently by Stu Westin of the URI College of Business Administration and is offered for use by the University community. The application is provided as a free service without any warranties, guarantees, or promises. The author accepts no responsibility for any consequences of its use or misuse. Furthermore, the author makes no promises regarding future support or maintenance of the application.

Platform Requirements

The Microsoft implementation of HTA is limited to Windows-based computers running Internet Explorer 5 and later (IE). This application should be invoked through this current webpage from IE. Microsoft Excel should be installed on your local machine since Automation techniques are used to manipulate the Excel Object Model.

Obtaining and Preparing OMR Data File

Complete and submit ITS Handout # 37 according to the directions in ITS Handout # 32. It is strongly recommended that you request automatic exam grading even if you intend to perform your own analysis. Specify that the resulting data set should be sent to you by email, but ask that the data be sent as an attached file (the data files are pasted into the body of an email by default - this can corrupt the data format and make the data unsuitable for further machine processing). Save the data file (named omr???.data) to a convenient location on your Windows machine (Desktop, My Documents, etc.). Important: do not edit or alter the data file in any way. If you wish, you can use Notepad to view the file, but you should use a fixed-width font such as Courier. A sample data file is provided here to illustrate the layout.

Note: This application does not check the integrity of your input file. The program will generate output from erroneous data, and will indicate normal termination in all cases unless a fatal error occurs (e.g., improper number of data records). You should always check your results for validity, consistency, etc. Consult the sample data file for an understanding of the structure and the meaning of the data.

Running the OMR2XL Utility

Use the button below to start the utility. Nothing will be installed on your machine. If the button does not respond then you are not using the proper browser or platform (IE 5+ on Windows with VBScript enabled). Select Run (not Save) at the prompt (you may receive some additional security prompts since this is an executable application). You will need to specify the following information to proceed: 1) the location of the data file, 2) the number of exam questions, and 3) the number of exam keys (versions). A new Excel workbook will be created on your local machine and populated with your exam data. You can save this workbook to any location.


Add to Favorites List

Email Author

Last Update: March 20, 2008