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}}, then upload and print the box.
Good to know: Use the barcode your catalog already assigned. We do not issue library or ISBN numbers.
How to print library barcodes from a catalog
- Open https://app.mylabelmaker.com. No signup. Set 2x1 for the inside cover, or a spine size you measured.
- Put headers in row 1: barcode, title, and call if you use one.
- Add CODE128 on {{barcode}}. Keep {{title}} small. Optional {{call}}.
- Upload the Excel file. Scan two books. Then print the box.
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
Got a Zebra? Print from the browser with Browser Print, at the printer's DPI. Otherwise download PNG, JPG, SVG, PDF, or ZPL. JSON keeps the label you can open later.