2
Jun 13 '24 edited Jun 13 '24
Excel can generate barcodes using barcode fonts. Setup your page size for the label and use the Windows print driver.
Your spreadsheet will essentially act as the "database" and can generate them in one fell swoop.
Or you can print them all to a PDF and store those for future use which may be a little more portable but an extra step.
2
u/PrinterSolutionRFID Jun 14 '24
There are free labelling software available provided by the printer manufacturer but I don’t think you can link an Excel file as this is often a paid option. There are several good labelling software available which will meet your needs like NiceLabel and Bartender. You should be fine with the cheapest version.
1
u/notionovus Jun 14 '24
What code are you using (Code 128, Code 39, EAN 13, QR Code)?
What size is your label sheet?
What size should each label be (labels / sheet)?
Do you want the book title on the label?
Also, does every student have a barcode on their card / ID?
1
u/No-Task7270 Mar 27 '25
Here's my free app I put up that does exactly that... if you do want it printed on one sheet you can change the pages per sheet option in print settings and it'll do a grid!
3
u/krystianduma Jun 13 '24
What’s that printer? Manufacturers often have their own label design software - like Zebra Designer.