I rebuild the class roster every time classes change

Built!

Paste your class list, tidy it, and download a CSV ready for name tags, cubby labels and artwork labels.

Current workflow

Every time classes are reassigned — at the start of a term or after a reshuffle — the class roster has to be rebuilt from scratch. The rosters teachers receive come in inconsistent formats: class names written short or with stray symbols attached, and numbers written in mixed styles, sometimes before the name, sometimes after it, sometimes in parentheses. Turning that into a table means splitting each line into name, number, and class by eye and retyping it, and the table has to be adjusted again to match the count every time name tags or cubby labels are made. When two children share the same name, it is easy to mix up which class each belongs to — and a name tag without the class on it cannot tell them apart on field trips or in combined-class activities.

Solution

Make Name Tags & Cubby Labels

How to use

1. Paste the roster or load it from a CSV or Excel file. 2. Check that names, numbers, and classes were split correctly, and fill in class names in bulk if needed. 3. Remove children who have left, and choose the sort order. 4. Pick the output you need — name tags, cubby labels, or artwork labels — and download the CSV. 5. Connect the file to Canva's bulk create or a MiriCanvas table.

Example

- Input: a pasted roster of 12 children (3 classes, 4 per class) with inconsistent class-name and number formats - Result: a tidy table of 12 children split into name / number / class columns, class names normalized, sorted by name in Korean alphabetical order - Same-name handling: if two children share a name — one in Class 1, one in Class 2, both number 1 — the two rows are not merged or deleted but marked as a duplicate name. Add the class or number to tell them apart before downloading.

Open tool
View details
Limits
- Phone numbers, addresses, and guardian details are not handled by this tool. - Files and entered content are never sent to a server; everything is processed in the browser and disappears when the tab is closed.
Cost type
Free

Even with this tool, children who share a name cannot be told apart by name alone. The cleaned table keeps both rows separated by class, but on printed items used one per child — like name tags — a name by itself does not say which class the child is in. Whenever classes with same-named children mix, such as field trips or combined classes, the class name must be printed on the tag as well. It is safest to include class and number for every child so the format stays consistent.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in