Exporting Assessment Data
PaperScorer can export your assessment results to a CSV file for use in spreadsheets, your school’s gradebook, or any external reporting tool. This article walks through the export workflow and the available filter options.
When to Use Export
Exports are useful when you need to:
- Pull grades into a spreadsheet for ad-hoc analysis or charts.
- Import results into a gradebook that doesn’t sync automatically with PaperScorer.
- Share results with a colleague who doesn’t have a PaperScorer account.
- Archive results at the end of a grading period.
- Run pivot tables or comparisons that aren’t available in the built-in reports.
If your school uses an LMS connected to PaperScorer, you may not need to export at all — PaperScorer can sync grades directly. See Google Classroom sync, or for enterprise customers, Canvas or Brightspace.
Starting an Export
- Open the assessment you want to export.
- Click Export Data (usually in the top action area).
- The export configuration page opens with several filter options.
Export Options
The export form includes several filters so you can tailor the output:
Date Range
Limit the export to scans received between a specific start date and end date. Useful for exporting only a specific grading window.
Class Filter
Choose one or more classes to include. Leave blank to export all students across every class attached to the assessment.
Student Filter
Narrow the export to specific students. Leave blank for all students.
Zero-Fill Missing Students
When enabled, students with no scanned sheet appear in the export with a score of zero. Ideal for reporting where “no submission” should count as a missing assignment in the gradebook. When disabled, only students who have actually scanned a sheet are included.
Include Standards
When enabled, each question in the export includes the educational standards it’s aligned to. Useful for standards-based reporting. Requires standards alignment to be configured on the assessment — a Teacher Pro feature.
Include Tags
When enabled, custom tags attached to students or questions are included as columns — useful if you tag for grouping or reporting.
Include Student Review Links
When enabled, each row includes a unique student review link. Useful for mail-merging individual results to parents. The review-link toggle must also be enabled on the assessment itself.
Running the Export
- Configure your filters.
- Click Export.
- PaperScorer queues a background job to build the CSV file. For large assessments, this may take a minute or two.
- When the job finishes, you’ll see a Download CSV button on the completion screen.
- Click to download the file to your computer.
TIP: you can navigate away while the export is running — the job continues in the background. If you re-open the same export configuration later, your filters are remembered.
What’s in the CSV?
The exported CSV includes these columns for every student row:
| Column | Description |
|---|---|
| First Name | Student’s first name |
| Last Name | Student’s last name |
| Student’s email, if on file | |
| Identifier | Your student ID |
| Assessment | The assessment’s name |
| Version | Assessment version (if multiple versions exist) |
| Completed | When the student’s assessment was completed (scan date) |
| Score | Points the student earned |
| Max Score | Total points possible |
| Percent | Score as a percentage |
| Performance Band Level | The student’s performance band label |
| Mastery | Whether the student met the mastery threshold |
Plus columns for each question (showing the student’s answer or score) and any optional columns you enabled (standards, tags, review link).
Opening the CSV
Most spreadsheet apps can open CSV files directly:
Google Sheets
- Go to Google Drive → New → File Upload.
- Upload the CSV.
- Right-click the file → Open with → Google Sheets.
Microsoft Excel
- Open Excel.
- File → Open → browse to the CSV.
- If everything ends up in one column, use Data → Text to Columns with comma as the delimiter.
TIP: if your student names contain non-English characters (accents, etc.) and they look garbled, open the file with UTF-8 encoding. Excel may prompt for the encoding when opening; Google Sheets handles UTF-8 automatically.
Export Limits and Lifecycle
- Very large exports (thousands of students) may take several minutes to generate.
- Multiple exports run sequentially — if you queue another while one is still running, it’ll start when the first finishes.
- Generated files are available for download for a limited time. If a download link has expired, re-run the export with the same filters.