Print sample barcodes from Excel

Yes. You can print sample barcodes from Excel. Barcode the sample ID, add lot and date, then print the tray. This is a sticker, not a LIMS.

← 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}}, then 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 https://app.mylabelmaker.com. No signup. 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

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.

Tag this tray

The IDs on the sheet. Stickers on the vials.

Open free label maker