Adding data to the "Student Application" import spreadsheet
Make how-to guides like this one in a snap.
CS

Christian Schlachte

Created Dec 20, 2022

Adding data to the "Student Application" import spreadsheet

All student data (both applicant and currently enrolled) should be entered into this spreadsheet. Much of it can likely be easily copy + pasted from your current tracking system. Be sure that the data for each individual student remains all on the same row!

2
    d

Google

21 Steps
1

Navigate to the Data Upload spreadsheet that your Pathway Labs onboarding contact shared with you.

Navigate to the Data Upload spreadsheet that your Pathway Labs onboarding contact shared with you.
2

The first column is your "External ID"

You can enter (or copy and paste) student ID numbers here (if your school uses them). If your school does not have an ID number schema, please assign students individual numbers (you will use these numbers on other data import spreadsheets to reference the individual to which student the information applies).

The first column is your "External ID"
3

Input email addresses

Email addresses are required

Input email addresses
4

Add the first name(s)

First name information is required

Add the first name(s)
5

Add the last name(s)

Last names are required

Add the last name(s)
6

Add the student/applicant's phone number

Add the student/applicant's phone number
7

Add the date of birth

This is format agnostic. However, we ask that you use a constant format (E.g., always use XX/YY/ZZZ or October 10, 2000 style formatting--please don't mix)

Add the date of birth
8

Add the student/applicant's address

Only input through the street suffix in this column

Add the student/applicant's address
9

Add additional address info

For example: apartment number of mailing box number

Add additional address info
10

Add state and city info

Add state and city info
11

Add post code

Zip code and zip+4 are both acceptable

Add post code
12

Input race data

All of the remaining data is optional. However, we suggest adding as much as possible because it helps improve your school's reporting experience

Input race data
13

Choose gender

Choose gender
14

Input Hispanic status

Input Hispanic status
15

Input marital status

Input marital status
16

Input veteran status

Input veteran status
17

Input financial aid status

Input financial aid status
18

Input if it is the student/applicant's first time applying for aid

Input if it is the student/applicant's first time applying for aid
19

Input highest level of education attained

Input highest level of education attained
20

Input if the student is transferring (or has transferred) credits

Input if the student is transferring (or has transferred) credits
21

Input if the student is transferring or has transferred work credit

Input if the student is transferring or has transferred work credit
Well done!
Create how-to guides like this in a snap. Get Tango now.