Step 2: Add Students by Spreadsheet

In Step 1 of Merit's achievement workflow, you configured your achievement landing page.

In Step 2, you will add students to your achievement. This guide will walk you through adding students to an achievement through a spreadsheet upload.

Upload Your Spreadsheet

Spreadsheets are the best way to add large lists of students to an achievement. To add a spreadsheet of students, click the Use a Spreadsheet button:

Screen_Shot_2023-01-24_at_2.13.35_PM.png

Please note your spreadsheet must be saved as either an .xls, .xlsx, or .csv file.

You will then be able to choose the spreadsheet you'd like to import. Click Browse to locate the file on your computer:

Screen_Shot_2023-01-24_at_2.14.08_PM.png

Note: The values in your spreadsheet cannot be edited after uploading your document. If you need to make changes to your data, you will need to upload a new version of your spreadsheet.

This will immediately upload and process your spreadsheet. Your list of students will then appear in the workflow:

Screen_Shot_2023-01-24_at_2.14.42_PM.png

Pro Tip: You can click on the silhouette to the left of any student to upload a headshot or individual photo for that person. Learn more about adding student headshots.

Map Your Student Data

Below your list of students, you will see a section for mapping student data. You do NOT need to map a field from your spreadsheet in order to use it in your story. These mappings will only be used for student profiles.

Most of these fields here will be auto-mapped for you, but you can use the dropdown boxes to map or un-map columns, as necessary:

Screen_Shot_2023-01-24_at_2.15.18_PM.png

Note: If your spreadsheet is missing a required field or you discover that you are missing information needed to tell your story, try using a mix of spreadsheet and previously uploaded student data.