Home / Barcode Labels from Excel

Excel workbook → printed product labels

Create barcode labels from Excel

Use your existing workbook to create labels that carry a barcode, a product name and an optional price. Map the columns once, select a paper layout, and export a PDF for printing.

Upload your fileSee export pricing

No account · Files stay on your device · Free 20-row barcode preview

Free layout planner

Check your sheet layout

Generic A4 and US Letter layouts. Check measurements against your stock; these are not manufacturer-certified templates.

Selected: Letter · 30 compact labels

Use with your spreadsheet

The free PDF contains two demonstration labels. Your uploaded full-batch PDF requires a paid unlock. Layout changes apply to the export controls below.

Geometry preview: label positions and gaps, not the final barcode artwork.

Not sure what we expect? Download a sample:Excel

How to use this workflow

  1. Put headers in row 1 of the first worksheet. Use one product per row and keep SKU or GTIN cells formatted as text.
  2. Upload XLSX or XLS. Map the identifier to Barcode value, Product to Caption column, and the numeric price to Price column.
  3. Preview the first 20 rows to check encoded values. Choose a generic sheet layout below or enter measurements from your label stock.
  4. Generate the batch and unlock PDF export. Print at Actual size / 100%, then test alignment on plain paper before using label stock.

Arrange the first worksheet like this

SKU       | Product       | Price
SKU-1001  | Cotton shirt  | 29.99
SKU-1002  | Ceramic mug   | 9.00

Try a sample:Excel workbook

Use identifiers you already own or have permission to encode. BarcodeDesk does not issue or register UPC, EAN or GS1 numbers.

The first worksheet is the one that gets imported

The importer reads the first worksheet in the workbook. Move the product table to that sheet before uploading, or save it as a separate workbook. Avoid introductory titles above the headers, merged header cells and multiple product tables on the same sheet.

No barcode font or Excel macro is required. The browser generates real barcode images from the values in your selected column. Formula cells use the values saved in the workbook, so recalculate and save the file in Excel before uploading if the results have changed.

If your source system exports a text file, create barcode labels from CSV and check its delimiter and quoted fields.

Map the scan value separately from the printed caption

A SKU such as SKU-1001 can be encoded as Code 128, while Cotton shirt appears as a caption under it. Select UPC or EAN only when the identifier already belongs to that numbering system. Changing the symbology does not register a product or create an official GTIN.

The PDF renderer currently prefixes mapped prices with a dollar sign. Supply a numeric price without a currency symbol. For other currencies, leave Price unmapped and include the desired price text in the caption. Long captions are shortened to fit; check a sample before printing a large run.

Using UPC or EAN numbers? Verify the barcode check digit before generating a full label batch.

Match your paper before committing label stock

Choose A4 or US Letter and check the columns, rows, margins, label width, label height and gaps. The generic presets are starting layouts, not certified manufacturer templates. The sheet diagram previews positions, while the free sample PDF shows example barcode artwork in that geometry.

Full PDF export for your workbook requires a paid unlock; the first 20 barcode rows and sample layout are free to inspect. Print without Fit to page, hold a plain-paper test against the label sheet, and scan a printed test label with the scanner you will actually use.

Start with standard paper and label sizes in the barcode label template picker or enter your own measurements in the sheet planner.

Barcode Labels from Excel questions

No. It reads your workbook and exports a separate label PDF. It does not modify the workbook.

Main bulk workspace · Choose a barcode format · Excel barcode files