*NOTE: You cannot upload student GPAs unless a student's Student ID has been entered into Overgrad. If you loaded your students, their Student ID is already set. If your students signed up on their own, click here for instructions on how to manually edit a student if you would like to manually enter your students' Student IDs.
First, you need to generate a CSV text file by exporting data from your school or district’s Student Information System (PowerSchool, Tyler SIS, Infinite Campus, etc.). After creating your spreadsheet, follow these steps to upload weighted and unweighted GPAs.
1. Click on your profile dropdown menu and select School Account
2. Select Import GPAs under the Data Imports section
3. Select Choose File and locate the CSV on your computer.
4. You should now be on 2. Set Headers page. You will see a list of field names that you can map your data to in Overgrad. Below is an explanation of each column:
Field name in Overgrad: This is the descriptive name of the field in Overgrad’s system. Any field marked with an asterisk (*) must be mapped to a column within the CSV you have loaded.
Example of data in Overgrad: This column contains examples of the format of the field within Overgrad’s system.
Select the matching column in your CSV: Here you are required to select the column header that contains the data that maps to the designated Overgrad field. You will not be able to progress if a row with an asterisk (*) does not have a selected value in this column. Leave a selection box blank if your CSV does not contain data on an optional field.
In the example below, the CSV contained a header named “school” that corresponds to Overgrad’s “High School” field
5. Select Submit. If the page does not advance to 3. Map Values, you failed to set the header for a required row. Please double check your selections and select Submit again.
6. The Map Values step is where you can map the specific values in a field to Overgrad’s accepted values. In order for Overgrad to correctly process the information in your CSV, you will need to map your values to Overgrad’s values on this page. Leave a selection box blank if your CSV value does not map to an accepted Overgrad value. Select Submit after mapping your CSV values to Overgrad’s accepted values.
In the example below, the CSV had a value of “Comer College Prep” under the school header, and was mapped to Overgrad’s accepted value “Gary Comer College Prep”.
7. If you are ready to load and process your file, select Process File. Navigate to previous sections of the upload process by selecting the step in the header. Please note, you will not be able to process a file if you have another file that is currently being processed.
You can monitor the status of any files you have uploaded into Overgrad by revisiting the School Account section and selecting Upload History. You can download and analyze any errors that Overgrad encountered in processing your file on this page.