How do I import fitness assessment scores from Excel?

How do I import fitness assessment scores from Excel?

How do I import fitness assessment scores from Excel?

If you have already recorded student fitness testing scores in a spreadsheet, IHT Spirit provides an assessment template that can be used to prepare those scores for import.

The video demonstrates how to generate an IHT assessment template, enter previously recorded scores, and upload the completed file.

Important: Use the template generated by IHT Spirit. The video explains that other spreadsheet formats cannot be imported directly through this workflow.

Step 1: Open a New Assessment

  1. Log in to IHTSpirit.com.

  2. Click Assessments.

  3. Select New Assessment.

  4. Select the assessment type demonstrated in the video, FGPYFP.

  5. Choose the fitness testing measures that match the scores you have already recorded.

Examples shown include height, weight, 20-meter PACER, sit-and-reach, push-ups, curl-ups, and trunk lift.

Step 2: Select Your Class

  1. Choose the class or group associated with your existing scores.

  2. Review the selected measures and class.

Make sure you have selected the correct students and assessment measures before downloading the template.

Step 3: Download the IHT Assessment Template

Instead of clicking Create Assessment, select Download Template.

IHT Spirit will download an Excel template based on the selected class and measures.

Open the downloaded file in Excel.

Step 4: Enter Your Existing Scores

The downloaded template contains prefilled student information, including identifiers, along with columns for the selected fitness measures.

  1. Open your original spreadsheet containing the recorded fitness scores.

  2. Open the IHT assessment template.

  3. Match each student's scores to the correct student in the IHT template.

  4. Copy the scores into the corresponding measure columns.

Important:

  • Do not change the template's column headers.

  • Do not alter the prefilled student identifiers.

  • Make sure each score is entered for the correct student and measure.

  • Do not assume the row order in your original spreadsheet matches the IHT template.

Step 5: Save the Completed Template

After entering your assessment scores, save the completed file.

Keep the template structure unchanged.

Step 6: Import the Assessment Scores

  1. Return to IHT Spirit.

  2. Click Imports.

  3. Select Choose File.

  4. Locate the completed IHT assessment template.

  5. Upload the file.

The video ends after demonstrating the file selection and upload process. It does not show the resulting import confirmation or any error messages.

Step 7: Verify Your Imported Scores

After the upload, confirm that the expected student scores appear in the correct assessment.

If the upload fails or the scores do not appear as expected, contact IHT Customer Success before attempting repeated imports.

Can I Upload My Existing Excel Spreadsheet Directly?

The demonstrated workflow requires the IHT-generated assessment template.

If your existing spreadsheet uses different columns or formatting, transfer the scores into the IHT template before uploading.

Is This the Same as Importing Student Rosters?

No.

Student roster import adds or updates student and class information.

Assessment score import uploads recorded fitness testing results for students already associated with the selected class.

Watch the Video Tutorial

How to Import Fitness Assessment Scores Using an Excel Template

Need Additional Help?

If you couldn't find the answers you're looking for, please submit a support request here.

Select your state and the type of assistance you need so we can direct your request to the appropriate support specialist.