Support Center

Using a spreadsheet

Last Updated: Aug 09, 2017 02:49PM EDT
Achievements are about people. Each time you publish one, you will need a list of the students who you plan to recognize. This list of students can come in a variety of forms: a spreadsheet, a list of names, or a list of email addresses.

The first time you add students to Merit, you will want your d
ata in an Excel (.xls or .xlsx) or Comma Separated Values (.csv) spreadsheet. You can include a variety of data in your spreadsheet, but a few sets of information are required/recommended:

Required Data:
  • First Names
  • Last Names
  • Hometowns
  • Zip Codes
  • Students' Emails

Here's an example of a spreadsheet that meets the minimum requirements:

Recommended Data: 

Here's an example of a spreadsheet with the recommended data included:

Once students have Merit pages created (either through a student import or an achievement) you may not need a spreadsheet at all. You will be able to search for students by name or add them using just their email addresses. The information stored in their profiles will become a list for you. You'll just want to choose the "Add Student Manually" option in the achievement workflow.

Requesting Student Data: 

Your student data may come from a variety of places (most likely your Registrar or Student Affairs Office). When requesting the information, 

Please see the attached student import request template:

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