EN
Open the tool

Make barcode labels from Excel

Got an Excel or CSV sheet of product codes, serial numbers or links? Trimto turns each row into a label with its own barcode (UPC-A, EAN-13, EAN-8, Code 128, Code 39, ITF-14, GS1-128), QR, Data Matrix or PDF417 code, then nests the whole run on a print sheet ready for straight cutting or die cutting. Codes are drawn as vector so print is sharp and scanners read it well. Free, and your spreadsheet never leaves your computer.

Open the barcode label tool →Free · runs in browser · files never leave your device

Features

  • Each Excel or CSV row becomes one label; label count equals the number of data rows
  • UPC-A, UPC-E, EAN-13, EAN-8, Code 128, Code 39, ITF-14, GS1-128, PDF417, QR and Data Matrix codes that change per row
  • Insert {{column name}} into text and codes; combine columns in one code, such as https://example.com/p/{{Code}}
  • Vector codes stay sharp at any size; invalid codes are flagged before printing
  • Nest the run on a print sheet, straight cut or die cut, export PDF
  • Paste straight from Excel with Ctrl + C, no need to save a file

How it works

  1. Open your label design and add a barcode or QR code to the template.
  2. Upload an .xlsx, .csv or .tsv file, or paste the selected range from Excel; the first row holds the column names.
  3. Click the code frame, then click a column name to insert {{column name}} into the code content; add it to text too if needed.
  4. Preview each label, click Continue to nest on a print sheet and export the PDF.

From an Excel sheet to a run of labels with their own codes

Product labels, warehouse tags, serial stickers and shipping labels often need hundreds of different codes. Typing each one into design software is slow and error-prone. With Trimto you build one template, leave a spot for the code, and let your spreadsheet fill in each label.

The first row of the sheet holds the column names (for example Code, Name, Price) and each following row is one label. If a column name is mistyped, the preview tells you right away, before you export.

Labels with sequential numbers and QR codes that change per label
Labels with sequential numbers and QR codes that change per label

Choosing a barcode type

Use a dark code color, ideally K100 black on a light background, so scanners read it easily. Avoid placing codes over busy artwork. Trimto only draws the code from the digits in your sheet; it does not issue GS1 numbers, so get your company prefix from GS1 if you sell in shops.

Code typeUse it forContent notes
Code 128Internal codes, lot numbers, serial numbers, warehouse codesAccepts letters and digits
UPC-ARetail products in the US and Canada11 digits (check digit added automatically) or 12 digits with a correct check digit
UPC-ESmall retail packs7 or 8 digits, starting with 0 or 1
EAN-13Retail products with a GS1 numberExactly 12 or 13 digits; letters are flagged as errors
EAN-8Very small retail packs7 or 8 digits
Code 39Asset tags, ID badgesCapital letters, digits, space and - . $ / + %; lowercase is converted
ITF-14Shipping cartons and cases13 or 14 digits
GS1-128Logistics labelsApplication identifiers in brackets, e.g. (01)09521234543213(10)ABC123
PDF417Tickets, ID cards, documentsAny text; holds more data than a QR of the same width
QRWebsite links, product info, warranty pagesCombine a fixed link with {{Code}}
Data MatrixVery small codes on component labelsUse when the label is too small for QR
Code content panel: code type, content with {{column name}} and color
Code content panel: code type, content with {{column name}} and color

Combine several columns in one QR code

Code content can contain several {{column name}} fields at once. For example https://example.com/p/{{Code}}?lot={{Lot}} gives each label its own link by product code and lot number. A label can also show {{Name}} as text and the barcode of {{Code}} together.

Check before you print

Trimto reports invalid content, such as an EAN-13 with letters or the wrong number of digits, in the Check tab. Preview each label to make sure the code sits in the right place and is large enough. For small labels, print one test sheet and scan it with a phone or real scanner before printing the whole run.

Nest on a sheet, then cut

Click Continue and the whole run moves to the layout step with "Print by quantity", which works out the fewest sheets, always enough or more, never short. Rectangular labels can use straight cutting; round, rounded or contour-cut labels can use die cutting before you export the PDF.

Step-by-step guides

Further reading

FAQ

Is making barcode labels from Excel free on Trimto?
Yes. Excel data merge, barcodes, QR codes and PDF export are free with no watermark. Your sheet and design files are processed in the browser and never uploaded to a server.
Which spreadsheet files can I use?
You can upload .xlsx, .csv and .tsv files; the first row holds the column names and each following row is one label. You can also select a range in Excel, press Ctrl + C and paste it into the data box.
Which barcode types are supported?
UPC-A, UPC-E, EAN-13, EAN-8, Code 128, Code 39, ITF-14, GS1-128, PDF417, QR codes and Data Matrix. Codes are drawn as vector.
Can I make UPC-A barcodes from an Excel sheet?
Yes. Put 11 digits in a column (Trimto adds the check digit) or 12 digits with the correct check digit, then insert that column into a UPC-A code. A wrong row is reported by its record number before the PDF is exported. Trimto draws the code only; it does not issue GS1 numbers.
Can one code combine several columns?
Yes. Code content can hold several {{column name}} fields, for example https://example.com/p/{{Code}}?lot={{Lot}}.
Are invalid codes caught before printing?
Yes. Content that breaks the standard, such as an EAN-13 with letters or the wrong digit count, is flagged in the Check tab and in the preview.

Open the barcode label tool →