Paste the class list. Copy rows from Excel or Google Sheets, with the heading row, or upload the file. Include a First name column, a Last name column and a Class column if you have one. Each row becomes one label.
Pick the sheet. Choose Avery® 5160 for books and folders, or a smaller sheet for pencil boxes. If your pack uses a size that is not on the list, use the Custom size option.
Set the wording and print. Put the first name in big letters and the last name under it. Print a test on plain paper, then print at 100%.
A class list is the fastest way to make labels for a whole group. Each child gets one row, and each row becomes one label. Sort the list by name or by class before you paste it, so the sheets are easy to hand out. If you need a whole sheet with one name, put that name in every row.
Common problems
The name runs off the label. Use a shorter name size, or move the last name to the next line. Keep the same size for every child where you can.
The labels do not line up. Check the paper size, turn off Fit to page and print at 100%. Then hold a test page over a sheet.
A child appears twice. Sort the list by name and look for repeated rows before you print the full class.
Ideas you can type
The AI helper changes every label at once. Try asking for:
"Put the first name in big letters and the class in small type under it"
"Make the labels where Class is Room 3 blue"
"Make the labels where Bus is Yes green"
"Sort the labels by last name"
"Add the school logo at the top of every label" (after you add your logo in the Design step)
Before you print
Check the spelling. Compare the labels with the class list before you print the full sheet.
Print at 100%. Turn off Fit to page, or the names may shrink.
Keep one test sheet. Hold a printed test over a blank sheet to check the lines.
Tips
Use separate First name and Last name columns, so you can size each one.
Keep the same font and size for every child, so the sheet looks even.
If a name is long, shorten the text for that label only.
Print a few spare labels for mistakes or new children.
Not for washing. Ordinary paper sticker labels can peel off in the wash. For clothes, use printable fabric or iron-on label sheets made for that job, and follow the instructions on the pack.
Can I make one label per child from a class list?
Yes. Each row in your list becomes one label, so a class list makes one label for each child.
Can I print one name on a whole sheet?
Yes. Use the same name in every row, and each label on the sheet will show that name.
Which sheet is best for school books?
Avery® 5160 has 30 labels per sheet, each 1 inch by 2⅝ inches. That gives room for a name and a class. For pencil boxes and small items, Avery® 5167 is a smaller choice.
Do I need to pay to try it?
LabelPeel is free while in beta, and you do not need a card. You can try it on the home page without an account.
Skip the mail merge — paste your list and print
Every row becomes one label, lined up on the sheet. Free while LabelPeel is in beta.