Import assignments and ratings from CSV
Overview
Teaching-team members can import assignments and ratings from CSV files to speed up course setup and assessment data entry. Both flows use a preview step with row-level warnings before you confirm the import.
Import assignments from CSV
- Open your course Assignments area.
- Open the Import assignments entry point (toolbar or sidebar, depending on layout).
- Download the CSV template if you need the current column layout.
- Edit relationship columns such as section, type, and objective columns using values that exist in your course.
- Upload the file and review the preview table.
- Fix rows with warnings or errors. Unknown dynamic relationship columns (for example unrecognized
Section_*,Type_*, orObjective_*headers) block import until corrected. - Confirm import when the preview looks correct.
Required columns and row data must be present and valid. Extra unrecognized non-dynamic columns may be ignored only when the preview clearly says so.
Advanced topics
- Objective ordering: list objectives in the CSV in the order you want them to appear on the assignment. Reordering after import may require editing the assignment in the UI.
- Group assignment imports: include valid group-set and section column values that already exist on your roster. The preview blocks rows with unknown group or section references before you confirm import.
Import ratings from CSV
- Open the Import ratings route for the course or assignment (entry point varies by layout).
- Download the rating CSV template.
- Upload your file and review the preview.
- Confirm import or save as draft import when offered.
Paid courses only: bulk rating import supports paid-course workflows including group assignments. Invalid rows may be dropped only when the preview summary lists what was removed.
Map objective scales and proficiency levels to values your course already uses. If the preview shows mapping errors, fix the CSV before confirming.
Related
Troubleshooting
| Situation | What to try |
|---|---|
| Import blocked on unknown column | Rename or remove unrecognized dynamic relationship columns. |
| Rows dropped in rating import | Read the preview summary; fix proficiency or objective references. |
| Import unavailable | Rating import requires a paid course; assignment import requires teaching-team access. |