How MarkTrack built its AI import with Claude

Every school that joins MarkTrack shows up with the same thing: a spreadsheet. Hundreds of rows of parents, kids, emails and phone numbers, collected over years by different people in different ways. And every one of those spreadsheets looks different.

One school writes "Father" and "Mother". Another writes "Parent 1" and "Parent 2". A third writes "Primary Guardian". Some rows are blank. Some literally say the word "EMPTY". Two kids from the same family might sit forty rows apart. Typing all of that into a new system by hand takes days, and it is exactly the kind of work where tired eyes make mistakes.

So we rebuilt our import around Claude, the AI made by Anthropic. Here is what that looks like, and how it works under the hood, in plain words.

What it feels like to use

You upload your spreadsheet, exactly as it is. No cleanup, no renaming columns, no special format. A few minutes later MarkTrack shows you every family it found. You look it over, click approve, and every account is created for you: parents, kids, and logins.

While Claude works, you watch it work. The screen shows what it is doing in the moment: reading the file, figuring out the layout, counting families as it finds them. It feels less like a loading spinner and more like watching a very fast colleague go through the pile.

The hard part is not reading rows. It is understanding them.

A normal computer program can read a spreadsheet only if you tell it exactly where everything is. Column C is the email, column F is the phone, and so on. The moment a school names a column differently, the program is lost.

Claude does not need that. It reads the sheet the way a person would. It notices that "Guardian Contact" is probably an email column because the cells contain emails. It notices that three kids share a last name, an address and the same two adults, and puts them together as one family. It converts dates written five different ways. It skips blank rows without being told what blank looks like.

And when something genuinely does not add up, Claude does not guess. It flags the row with a note and moves on, so a person makes the call. We would rather show you three honest questions than quietly get three families wrong.

How it works behind the scenes

This part is what we are most proud of, and it is the reason we trust the feature with real school data.

When you upload a file, MarkTrack does not read it with AI on our own servers. Instead, it hands the file to a service from Anthropic called managed agents. Think of it as a sealed room. Your file goes in, Claude works inside the room alone, and the only thing that comes out is a tidy list of families. The room has no connection to the internet and no connection to your school records. When the job is done, the room is thrown away.

The list that comes out is just facts. This person is a parent, this is their email, these two kids belong to them. Claude does not decide who gets a login or how accounts are set up. MarkTrack takes the list and applies its own rules to every single line: does this student have their own email, does this parent already exist in your school, is this email used by two different people. The AI reads. The rules decide. You approve.

The guardrails

We tested this with deliberately nasty files. Duplicate kids. Dates written as numbers. A grandmother listed in a parent column. Along the way, the testing caught real traps, and each one became a rule. A few of our favorites:

• The shared email trap. Some schools put the office email on every row. Early on, that could have merged two unrelated fathers into one account. Now, if one email shows up under two different people, the system treats it as belonging to neither of them and says so in the review.
• No guessing on families. Two kids are only grouped as siblings when the evidence agrees: same parents, same address, same contact details. A surname alone is never enough.
• Flag, do not fake. A parent with no email and no phone cannot receive a login. Instead of inventing something, the import creates what it safely can and shows you exactly what needs a human.
• Nothing without approval. Not one account is created until you have seen the full list and clicked approve. If you close the page, walk away, or lose your internet, nothing half happens. The import picks up cleanly where it left off.

A real test

The first real file we ran through it was a school sheet with almost 300 rows, collected over years, with all the mess you would expect. Claude found 146 families and over 270 students, including a handful of adult students who needed their own logins rather than a parent link. It flagged exactly three rows for a person to look at, and it was right to flag every one of them. What used to be days of typing became a few minutes of reading and one click.

Prefer to do it yourself?

Some admins would rather work from a fixed template, and that is fine. Next to the AI option there is a simple template import: download our spreadsheet, fill in the columns, upload it back. No AI involved at all, same review screen, same approval step.

Either way, the goal is the same. Your first day on MarkTrack should be spent looking at your school in the app, not typing it in.

Want to see it with your own spreadsheet? Get in touch and we will run your real file with you on a call.

Related reading

• Enrollments, the fast way
• Setting up Fall 2026 enrollment
• MarkTrack is the simplest school software