Split a Multi-Class Gradebook Into Separate Files (Free)

Teachers commonly keep a master gradebook with one tab per class section: Period 1 Biology, Period 2 Biology, Period 3 Biology, etc. When a department head asks "can you send me just Period 3 grades?" or a parent requests records for their student's class, you need to split the master file into per-class deliverables. Manually copying each tab to a new workbook eats 20 minutes per split.

Our free sheet splitter does it in 30 seconds. Drop the master gradebook, get one file per class tab. Everything runs in your browser — student grades never upload anywhere.

FERPA and Why Local Processing Matters for Teachers

Student education records are covered by FERPA. Uploading a file containing student grades to a random online splitter creates issues: the district's data-processing agreements, the "directory information" rules, potential breach exposure. A browser tool that processes entirely on the teacher's laptop doesn't create any of those.

For teachers in districts with strict "no third-party cloud" policies for student data, a local-only tool is often the only sanctioned option besides manual splitting in Excel.

A Realistic Teacher Workflow

1. Master gradebook in Excel. One tab per class section, each with student names, assignments, grades.
2. Open the sheet splitter in your browser. Bookmark for future use.
3. Drop the gradebook file. Every class tab lists with row count (student count).
4. Download the tab you need — as .xlsx for formatting-preserved delivery to department head, or .csv for import into another system.
5. Deliver via your district's approved channel (secure email, LMS, district SIS).

End-to-end: under 2 minutes. Compared to Excel's "move or copy sheet > new workbook > save" manual approach, this saves 10-15 minutes per request.

Sell Custom Apparel — We Handle Printing & Free Shipping

Common Scenarios Where This Helps

• End-of-quarter grade reporting. Split master file into per-class files for department submission.
• Individual parent record requests. Deliver just the relevant class's data.
• Substitute teacher prep. Send the sub only the class section they're covering.
• Co-teacher or team sharing. Share specific class data with co-teachers without exposing other sections.
• Student teacher observations. Give your student teacher just the class they observe.
• Special-education IEP teams. Pull just the relevant student's class for IEP meetings.
• End-of-year cumulative reports. Split year-long gradebook into period-by-period files for records.

When You Need CSV for SIS Imports

Many student information systems (PowerSchool, Infinite Campus, Skyward, Schoology) import grades via CSV. If your master gradebook is in Excel and the SIS needs CSV:

1. Drop the gradebook into the splitter.
2. Click "Download All as CSVs."
3. Each class tab becomes a separate CSV ready for SIS import.

Before SIS import, verify column headers match what the SIS expects. Some systems want StudentID, others want StateID, others want LastName/FirstName combinations. Adjust in Excel before splitting if needed.

What to Tell Your District IT

• Tool type: Client-side web utility. Not a SaaS vendor — no account, no backend, no data transmission.
• Data flow: File bytes read locally by browser JavaScript, processed in-browser, delivered back as downloads. Zero upload.
• FERPA posture: No disclosure to a "school official" outside your district occurs because no vendor receives the data. The browser is tooling on the teacher's own device.
• Logging: None. No backend to log on.

Most district IT approves this faster than a traditional SaaS vendor review because there's no vendor contract involved.

Frequently Asked Questions

Is this FERPA-compliant?

FERPA compliance depends on workflow, not tools alone. Because no student data leaves your device, the tool doesn't create FERPA disclosure concerns. Confirm with your district compliance officer for your specific use.

Can I use this on a district-issued laptop?

Usually yes — it's a web page. Some districts block non-approved domains or JavaScript; check with IT. Bookmark once approved.

Will grade formulas survive the split?

Formulas that reference only cells within the same tab survive. Cross-tab formulas (e.g., weighted averages pulling from multiple class tabs) break — the other tabs are now separate files.

What about grade calculations in the LMS itself?

Canvas, Google Classroom, and Schoology have their own gradebooks. This splitter is for when you maintain an Excel master alongside or instead of LMS grades.

Can I split by student rather than by class?

This tool splits by tab. If each student has their own tab (unusual but possible), yes. If you need to split a single class tab into per-student files, that's a different operation needing Python or a row-filter tool.