Data Import Template

The data import template has been shared directly with your school (the link is unique to your school). It's a spreadsheet on Google Sheets. It's made up of three sheets:


Companies Sheet

The Companies Sheet is all of your corporate partners. At a minimum, what is required is the name of the work-study partner. We have added optional fields for the address, city, etc.

Please only list each company once. If you have multiple sites with the same company, please use a unique name for each. If a company is entered twice, they will both turn red.

Account Owner

The account owner field is the member of your team who manages the relationship with this corporate partner. If you do not divide your accounts, please leave this field blank. It can easily be changed later as well, if you have not divided accounts among your staff.


Supervisors Sheet

The Supervisors Sheet is for supervisors (or other employees with whom you interact) at each of your companies.

Company Name

The Company Name field contains a drop-down for companies in the Companies Sheet.

 If you enter a company that is not on that sheet, it will be yellow until you add it to the Companies Sheet.

Email

Email is a required field for this sheet. If you enter an invalid email account, it will be highlighted red:

If a supervisor is entered without an email account, it will be highlighted in yellow until the email is added:


Students & Employments

Email

Email is a required field for students. If you enter an invalid email account, it will be highlighted red:

If a student is entered without an email account, it will be highlighted in yellow until the email is added:

Grade and Graduation Year

You only need to select the grade from the drop-down (or enter 9 through 12). The graduation year will be automatically filled-in:

Work Day

Select the student's work day. If you're a Monday rotation school, do not assign any students on Monday. If you're a Friday rotation school, do not assign any students on Friday.

Workplace and Supervisor

The Workplace and Supervisor fields are all drop-downs based on the companies and supervisors you've entered:

If the supervisor is associated with a different company than the selected workplace, the cell will be highlighted in red:

What do I do for students who don't have a position at a corporate partner?

If you have students who you have not placed, they should fall into one of three categories:

Working at the School

In this case, add a Company with your school's name. Assign the student to that company.

Retraining Students

Add a company with your school's name and "Retraining" in the name. Assign the student to that "company".

Students who have no position yet

Please enter "NO EMPLOYER" in the Workplace Company field.

Still need help? Contact Us Contact Us