Print sample barcodes from Excel

A lab or kitchen tagging vials from a batch sheet.

← Back to Blog

Print sample barcodes from Excel

Published: · 3 min read · How-to
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.

Open product sticker template

Sample IDs already live in a sheet. Design one small sticker in the free label maker. Barcode {{sample}}. Add {{lot}} and {{date}}. Upload. Print the tray.

Good to know: This is a design-and-print sticker. It is not a LIMS, chain-of-custody system, or certified lab label.

How to print sample stickers from a batch sheet

  1. Headers: sample, lot, date.
  2. Open the free label maker. Set a small vial or bag size you measured.
  3. CODE128 with {{sample}}. {{lot}} and {{date}} under it.
  4. Upload the Excel file. Stick one vial. Scan. Print the tray.

Sample spreadsheet

A Friday kitchen or lab batch.

samplelotdate
S-0828-01L-0828A2026-08-28
S-0828-02L-0828A2026-08-28
S-0828-03L-0828B2026-08-28

First row is the header. Those header words go inside the curly braces on the label, like {{sample}}.

Lot stickers for finished goods: lot number labels from Excel.

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.

Tag this tray

The IDs on the sheet. Stickers on the vials.

Open free label maker