—

No course selected

0s Idle

Step 1 of 6

Import marks

Upload a workbook. Its structure and every row are validated before any grade exists.

  1. Upload

    An Excel or CSV sheet, one row per student.

  2. Validate

    Structure and every row checked; problems listed by row number.

  3. Grade

    Pick a course, set the boundaries, review and export.

BITS ID
Unique within a course
Course
Code as on the transcript
Total Marks
Whole number, 0–100
Template Sample data

Drop a marks workbook

Read inside this browser tab. Nothing is uploaded.

.xlsx .xls .xlsm .csv Leave out students who were absent and will be awarded NC.

File format and validation rules

The file must look like this

Column Rule
BITS ID Required. Must be unique within a course.
Course Required. The course code as it should appear on the transcript.
Total Marks Required. Whole number from 0 to 100.

Capitalisation, surrounding spaces, underscores and hyphens are ignored. These spellings are also accepted:

What this workspace checks

Required columns are mapped, and the sheet that actually holds the marks is found even if it is not the first one.
Every mark is a whole number from 0 to 100. Anything else is listed with its row number and never guessed at.
Duplicate and blank BITS IDs are caught per course, so one student cannot be graded twice.
Every mark from 0 to 100 is guaranteed exactly one grade, so no student can silently vanish from the export.