Prepare Your Roster

Walk Through the Preparation Steps:

Note: This video includes screens that show the former MAP homepage (also known as MARC). The new landing page is the start page. Learn more: Start Page Overview and Transition Guide: MARC to Start Page.

About the Roster Templates

You create your roster file using NWEA templates, which can be downloaded from the start page. Choose Rostering from the start page main menu and download the roster file templates (requires MAP role of Data Administrator or System Administrator).

• MAP Roster File Template—Primary template with two spreadsheet tabs:
  • StandardRoster tab—Main template for inputting teachers, students, and classes.
  • Additional Users tab—Optional template to input additional staff or to add other roles to teachers (teachers only receive the Instructor role by default). For details, see Add Staff and Roles in Roster Import.
• MAP Programs File Template—Optional template to set up and report on students participating in programs. See Setting Up Student Programs in Reports.

Saving Roster as CSV Format

After preparing the roster file, you need to save it as the comma-separated (CSV) format before you continue with the roster import.

Note: If you are using Excel^®, avoid saving your CSV file(s) as a format variation like CSV UTF-8; however, if you are using a program other than Excel (such as Numbers^® or Google Sheets™), you may need to save your CSV file(s) using a CSV format variation.

Alternative: Saving CSV outside United States

If you operate in a region outside the United States, you might need to adjust settings so your CSV file uses commas to separate information, instead of semicolons. First check whether this situation applies to you:

• For Excel or Numbers—Check the format of decimal numbers. Does it use a comma, such as “0,5” to represent the number one‑half? If so, then follow these instructions.
• For Google sheets—You do not need to follow these instructions.

Depending on your situation, follow instructions for option A, B, or C. Later, after importing the roster and fixing any errors, you can restore the original settings.

Option A: Using Excel on Windows

1. As a precaution, close Excel if it is open.
2. Open the Control Panel:
   • On Windows 7: Choose Start > Control Panel.
   • On Windows 10: Type “control panel” in the search box of the Windows Task bar.
3. Open the region settings:
   • On Windows 7: Choose Clock, Language, and Region > Change keyboard or other input methods (or click the Region and Language icon).
   • On Windows 10: Under Clock and Region, click Change date, time, or number formats.
4. Under the Formats tab, click Additional Settings.
5. Make the following changes and click OK:
   • Decimal symbol—Change to “.” (period).

   • List separator—Change to “,” (comma).

     

6. Restart Excel.

7. Open your roster spreadsheet and save as the comma-separated (CSV) format, avoiding format variations like CSV UTF-8.

Option B: Using Excel on a Mac

1. As a precaution, close Excel if it is open.
2. Open the System Preferences, available from the Apple icon.
3. Choose Language & Region.
4. Click Advanced.
5. Make the following changes for the Number separators:
   • Grouping—Change to “,” (comma).

   • Decimal—Change to “.” (period).

     

6. Restart Excel.
7. Open your roster spreadsheet and save as the comma-separated (CSV) format, avoiding format variations like CSV UTF-8.

Option C: Using Numbers on a Mac

1. In Numbers, close the roster template if it is open.
2. Choose File > Advanced > Language & Region.
3. Change Region to United States.
4. Open your roster spreadsheet
5. Choose File > Export To > CSV.