How to Export Quiz Results to a Gradebook: Step by Step

The full export process takes under a minute once your students have submitted.

Step 1: Open Smart Sharing

Sign in to QuizMagic and click Smart Sharing in the top navigation panel. You will see a list of all your sharing sessions, each representing a quiz you have shared with students.

Step 2: Select the Session

Click Results in the session that contains the quiz attempts you want to export. The session detail view opens, showing a table with one row per student attempt.

Step 3: Choose Your Export Format

At the top right of the results table, click the Export button. A dropdown appears with three options.

Select Save as CSV to download a spreadsheet-ready file for gradebook import. Choose PDF or DOCX instead if you need a formatted report for records or sharing with colleagues.

Step 4: Export Selected Attempts (Optional)

If you only want to export results from a specific student, click the eye icon (View answers) in the individual rows. It will open the Student Answer Review screen. From there, click on Export.

Step 5: Open and Review the Downloaded File

Open the downloaded CSV in Excel, Google Sheets, or Numbers. The file contains a small metadata header at the top (session name, quiz title, export date, total attempts), followed by a clean row for each student with these columns:

• Student Name – the name the student entered when they opened the session link
• Score – the raw point score
• Percentage – the score expressed as a percentage of the total points
• Time – how long the student spent on the quiz
• Submitted – the exact submission timestamp

How to Prepare the CSV for Your Gradebook

Most gradebooks expect a specific column structure, so a quick clean-up before importing prevents errors during the upload step.

Remove the metadata header

Delete the four rows at the top of the CSV that contain the session name, quiz title, exported date, and total attempt count. Keep the row that starts with Student Name; that is your column header row. The import will fail or produce misaligned columns if the metadata rows remain in the file.

Rename the columns

Rename the columns to match what your gradebook expects. The naming conventions vary by platform.

• Google Classroom: expects columns named Student and Grade
• Canvas: expects columns named Student, SIS User ID, and the assignment column header
• Schoology and PowerSchool: check your roster export for the exact column names your system uses

Choose raw scores or percentages

Decide whether you want to import raw scores (for example, 18 out of 20) or percentages (for example, 90%). Percentages work in more gradebook systems because they are not tied to a specific point scale. However, if your gradebook assignment has a fixed point value, raw scores may be the cleaner choice.

Save as CSV (UTF-8)

Before uploading, save the file in CSV (UTF-8) format. UTF-8 encoding ensures that accented characters in student names, for example, names with é, ñ, or ü, transfer correctly. Saving as plain CSV without UTF-8 encoding strips accents and replaces them with question marks or garbled characters, which causes name-matching failures during import.

In Google Sheets, select File, then Download, then CSV (UTF-8). In Excel, select Save As, then choose CSV UTF-8 (Comma delimited) from the format dropdown.

How to Import Quiz Grades Into Google Classroom

Google Classroom does not have a one-click CSV importer built into the gradebook view. However, you can transfer grades efficiently using one of two methods.

Manual paste method

Open the assignment in Google Classroom that corresponds to your QuizMagic quiz. Click Student work, then place your QuizMagic CSV side by side with the Classroom view. Match each student’s score to their name and type or paste the grade into the Grade field. Click Return when you are finished to publish grades to students and their guardians.

Add-on method for large classes

For classes with many students, several free add-ons in the Google Workspace Marketplace support bulk grade import from a spreadsheet. After installing an add-on, point it at your cleaned CSV file, and it matches student names to the roster automatically. This approach is significantly faster for classes with more than 20 or 30 students.

How to Import Quiz Grades Into Canvas

Canvas has a built-in CSV importer inside the Gradebook view, which makes the import process faster and more direct than Google Classroom.

Steps for Canvas

1. Open your course in Canvas and click Grades.
2. Click Actions, then select Import.
3. Upload your cleaned QuizMagic CSV. Canvas prompts you to map columns, match Student Name to your roster column, and Percentage or Score to the correct assignment column.
4. Review the preview screen. Canvas highlights any rows it cannot match to a student in your roster, so you can correct name discrepancies before confirming.
5. Click Save Changes. Grades are posted to students immediately.

How to Import Quiz Grades Into Schoology, PowerSchool, and Other Gradebooks

The menu names differ across platforms, but the import pattern is consistent across virtually every LMS and gradebook system.

General import steps

1. Create the assignment first in your gradebook and set the maximum point value.
2. Find the Import grades or Upload scores option. This is usually inside the gradebook view or the assignment detail page.
3. Upload your cleaned CSV, map the student-name column and the score column, and confirm the mapping.
4. Review the preview for unmatched students, then save.

When your gradebook uses student IDs

Some gradebook systems match students by a student ID number rather than by name. If yours does, add a Student ID column to your CSV before uploading. Copy the IDs from your official roster export and paste them next to the corresponding student name in the QuizMagic CSV. Furthermore, make sure the ID format matches exactly — leading zeros and formatting differences cause import failures in ID-based matching systems.

Troubleshooting Common Import Errors

Student names do not match the roster

The most common cause is students typing a nickname, a preferred name, or an abbreviated version of their name when they opened the session link. Two fixes work well: ask students at the start of every session to type their full name exactly as it appears on your class roster, or edit the name directly in the CSV before uploading. Both take less than a minute per affected student.

Accented characters appear broken

Re-save the CSV as CSV (UTF-8) before uploading. The plain CSV format strips accents and Unicode characters. UTF-8 encoding preserves them. This issue appears most often when opening and re-saving a CSV in older versions of Excel, which default to a non-UTF-8 format.

Scores with decimal places get rejected

Check whether your gradebook accepts decimal scores. If it does not, round the percentages in your spreadsheet before exporting the final CSV. In Google Sheets, use =ROUND(D2, 0) on the percentage column to convert every value to a whole number.

The importer rejects the file entirely

Two causes cover most file rejection errors. First, check that the first row of your CSV contains column headers and not the QuizMagic export metadata. Remove the four metadata rows at the top if they are still present. Second, confirm there are no blank rows at the top or bottom of the file. Some gradebook importers stop reading at the first blank row and report the file as empty or invalid.

Frequently Asked Questions

Can I export quiz results to a gradebook without a paid plan?

Yes. CSV, PDF, and Word exports are available on every QuizMagic plan, including the Free plan. Smart Sharing, which is where your results are stored, is also available on the Free plan. You do not need a Premium subscription to export your data.

Does the CSV include each student’s individual question answers?

The summary CSV includes one row per student with the final score and percentage. To see per-question answers for an individual student, open that student’s attempt in the Smart Sharing dashboard or download the PDF export, which includes a full question-by-question breakdown alongside the student’s responses.

Can I re-export after releasing essay grades?

Yes. As soon as you finalize and release an essay or short-answer grade, the score updates in the Smart Sharing dashboard. Run the export again, and the downloaded file reflects the updated totals. The new export replaces any previous version you downloaded.

What if a student took the quiz more than once?

Each attempt appears as its own row in the CSV, including its submission timestamp. Open the file, sort the rows by student name and then by the Submitted column, identify the attempt you want to keep for each student, and delete the other rows before importing. This gives you full control over which attempt score goes into your gradebook.

Can I export results from multiple quiz sessions at once?

Currently, the export covers one session at a time. To combine results from multiple sessions into a single gradebook import, download a CSV for each session and merge the relevant columns in a spreadsheet before uploading to your gradebook.