Support Center

Adding students by spreadsheet

Last Updated: Jul 26, 2018 10:45AM EDT

Go Back: Adding Students

Spreadsheets are the best way to add large lists of students to an achievement. Simply choose the Upload Spreadsheet button to get started.

You will then be able to choose the spreadsheet you'd like to import:

After importing your spreadsheet, you will see the list of students inside the workflow:

You will then need to map your students' attributes. Fields like first name, last name, hometown, zip code and email address are all required but all other fields are optional.

Adding Student Data From Merit

NOTE: If you don't have all the required fields for your students, but you have imported them in the past, you can import data from Merit. 

To enable this feature, first map the field Student Email Address field. A window will appear asking "Would you like to add data from Merit for the uploaded spreadsheet?"

Click the "Add" button to add data, and Merit will add additional columns to your spreadsheet with the prefix merit_first name, merit_last name, etc... 

Data imported from Merit will be automatically assigned to the values in the "Tell us about your spreadsheet" section of the publishing workflow, but you can change any of these mappings if you wish. Data imported from Merit will have a merit_ prefix added to the column header of your spreadsheet. 

You will see two sample students beneath the dropdown boxes:

Lastly, you may choose to notify parents by email:

Clicking Save & Continue will prompt you to begin writing your Merit story. If there were any problems validating your students, you will be alerted to them at this time. Go here for help or more information about spreadsheet validation.

Next Step: Writing your Merit story


Contact Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found