Export marks and grades to CSV in Classic marking

  • Updated

Available for Planners.

This feature allows a you to export the marks for each candidate on every question in a test. The export link is available from the candidate list in the Classic marking tool.

Note: This option is only available for single assessments, tests that do not have associated assessments under them.

How to export the CSV file

  1. In Classic marking, under Details click on Open next to Submissions.
  2. Once you are in the candidate list, click the Download dropdown menu. 

  3. Select Marks and Grades as CSV.

    Skjermbilde 2025-10-31 094256.png

  4. A new window will appear. Click Generate exports.
  5. When the file is ready, the button will update to Download .csv-file. Click the button to save the file to your computer.

Important:

  • The grades will only be included in the file once the grading is completed.
  • To download a newer version of the file with updated data, click Regenerate exports.
  • You can open the file in Excel or Google Sheets by importing data through the File menu. You must select the Comma as the field delimiter to make sure the data is sorted into the correct columns.

Example CSV file

Below is an example test with two candidates and four questions, one manually marked and one automatically marked. Final grade is not included because grading was not finished at the time the export was generated. 

image-3.png

The CSV columns

CandidateExternalId Candidate ID for the candidate.
UserID Internal Inspera database user ID of the candidate.
QuestionNo The questions will be numbered as they are in the test, for example, alphanumeric. Question types Document and Form are excluded.
QuestionId Internal Inspera database ID of the question.
EvaluatorUserId/Username

If the question is manually marked the user ID and username of the evaluator will be shown in these columns, otherwise it will be empty/null.

  • Tests with individual marks workflow: If more than one Grader has marked the question each Grader will be shown in a separate column.
  • Tests with shared marks workflow: The user ID will be replaced with a workgroup ID and ID of individual Graders is not included.
ManuallyGradedScore  Manually graded scores are listed here, and the value will be empty/null for automatically marked questions. If a Grader has overridden an automatically marked question, this column will contain the value of the overridden mark. 
AutoGradedScore For automatically marked questions this column will show the calculated score.
FinalGrade The column will be empty until the test is evaluated with a final grade.

Was this article helpful?

0 out of 1 found this helpful