Skip to main content

Understanding the output files from the Transcript Reader

Updated over 2 months ago

Once your transcript files have been successfully uploaded and processed through the Transcript Reader, you will receive three output files via SFTP. These files contain critical results, diagnostic information, and additional metadata about the transcripts.

Output files overview

After processing, you will receive the following three files:


1. GPA results file (.csv)

This file provides GPA information for each transcript. It includes multiple types of GPA calculations, allowing for different interpretations based on school or program-specific methodologies.

What’s inside:

  • Extracted student name or ID

  • Multiple GPA calculations (e.g., weighted, unweighted, core GPA)

  • Calculation breakdown per semester or year, depending on transcript format

For more details:
Refer to the article on GPA Calculation Methodologies to understand how each GPA value is derived.


2. Error File (.csv)

This file includes transcripts that could not be fully processed and require human review.

Reasons a transcript might appear here:

  • Blank GPA: Indicates the reader was unable to extract necessary data from the transcript.

  • Calculation Errors: Data was extracted but failed validation or produced an error during GPA calculation (e.g., missing credits or invalid grade formats).

Action Required:
Review the flagged transcripts manually to diagnose and correct issues, then re-upload if necessary.


3. Additional Transcript Information File (.json)

This file provides enriched data extracted from the transcripts for deeper analysis or integration into downstream systems.

Current contents include:

  • Course level metadata:

    • Difficulty (e.g., Honors, AP, IB)

    • Credits per course

    • Grade earned

    • Academic year (e.g., 10th grade, 11th grade)

    • Term details (e.g., Semester 1, Fall 2023)

    • High school name

This structured data is useful for custom analytics or to power advanced AI processing pipelines.


For any questions and concerns, please reach out to the CollegeVine partnerships team!

Did this answer your question?