Print library barcodes from a catalog spreadsheet
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.
A catalog export is a list of titles and barcode numbers. Design one book sticker in the free label maker. Barcode {{barcode}}. Add {{title}}. Upload. Print the box.
Good to know: Use the barcode your catalog already assigned. We do not issue library or ISBN numbers.
How to print book barcodes from a catalog
- Headers: barcode, title, call (optional).
- Open the free label maker. Set 2x1 for the inside cover, or a spine size you measured.
- CODE128 with {{barcode}}. {{title}} small. Optional {{call}}.
- Upload the Excel file. Scan two books. Print.
Sample spreadsheet
A donated-book intake for a classroom library.
| barcode | title | call |
|---|---|---|
| LIB-2201 | Charlotte's Web | F WHI |
| LIB-2202 | The Giver | F LOW |
| LIB-2203 | Holes | F SAC |
First row is the header. Those header words go inside the curly braces on the label, like {{barcode}}.
Spine labels from a list: book spine labels from a catalog.
Print or save
Zebra thermal: print from the browser with Browser Print at the printer’s DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.