Spreadsheet Templates

The Michigan MEIS Financial File Upload option allows you to upload MI MEIS reference tables from Microsoft Excel spreadsheets. The spreadsheet templates correlate the spreadsheet columns and the appropriate database fields.  

Before generating reports, ensure that you enter valid information on the Spreadsheet Templates page.

1. On the start page, choose System Administration.

2. Click Administration, then choose Spreadsheet Templates (under Reference Tables).

3. Specify the search criteria, then click Search.

4. To add a record, click Add new. 

5. Specify valid information in the required fields. Click Accept. 

6. To edit a record, double-click the relevant record. Update the information. Click Accept. 

7. To delete, click a record, then click Delete. Click Yes.

8. To create a copy, click a record, and then click Copy. 

9. Enter the New Template Name. Click OK.