BulkBarcode
Menu
GeneratorsUtilitiesGuides

Barcode guide

How to Print Barcodes from an Excel List

If you have your product data in Excel - SKU numbers, UPC codes, tracking numbers or serial numbers - you do not need to retype anything. The fastest way to turn that list into printable barcodes is to copy the column, paste it into a bulk generator and print the sheet. This guide walks through it step by step.

The fastest way: copy the column, paste it here

  1. Open your spreadsheet and select the column that holds your barcode data (for example the SKU or UPC column).
  2. Copy the cells (Ctrl+C / Cmd+C). Rows in Excel paste as separate lines.
  3. Open the generator for your barcode type - Code 128 for SKUs and logistics, EAN-13 or UPC-A for retail products, QR for URLs.
  4. Click into the input box and paste (Ctrl+V / Cmd+V). Each row becomes one barcode.
  5. Click Generate, then Print Sheet to print the whole batch on one page of label paper.

Which barcode type should you use for Excel data?

Match the barcode to where it will be scanned. SKU and bin codes in a warehouse use Code 128 because it is compact and reads well at small sizes. Retail products sold through stores or Amazon use EAN-13 or UPC-A. If you are encoding URLs, Wi-Fi details or serialized links, use a QR code. When in doubt, ask the customer, carrier or marketplace which symbology their scanners expect - most have a written specification.

Clean up your data before you paste

  1. Remove empty rows and duplicate values you do not want to print.
  2. Strip leading/trailing spaces (Excel: TRIM) - a stray space can make a Code 128 or Code 39 value unexpectedly long.
  3. For UPC-A and EAN-13, paste 11 or 12 digits - the check digit is calculated automatically.
  4. For GS1-128, keep the parentheses around the application identifier, e.g. (01)09501101530003.

Printing tips for office printers

Barcodes do not need a specialist printer - a normal laser or inkjet on sticky label paper (Avery or compatible) works well. Use the highest print quality setting, disable any 'economy' or 'fast draft' mode, and print at 100% scale with 'fit to page' turned off so the barcode is not resized. A quick test scan of one label before you print the whole run catches sizing problems early.

Should you generate barcodes inside Excel instead?

You can buy barcode fonts and generate codes directly in Excel, but most barcode fonts do not calculate check digits for EAN/UPC and some add quiet-zone or start/stop issues that make codes fail. Generating from a bulk tool is faster, produces vector-quality output, and guarantees the code is structurally complete and scannable. Use this generator to produce the images, then print them on your label sheets or drop them into your label design.

Reference

Frequently Asked Questions

Can I paste a whole column from Excel?
Yes. Copy the column and paste it into the generator - each Excel row becomes one line and therefore one barcode. Hundreds of rows work in one go.
Do I have to convert Excel to CSV first?
No. Direct copy-and-paste from Excel, Google Sheets or Numbers works, because each row pastes as a new line.
Will spaces or formatting break my barcodes?
Leading/trailing spaces make values longer than expected and can break strict formats. Trim cells before pasting (Excel TRIM function).
Can I print thousands of barcodes at once?
Yes, paste as many rows as you need. The output prints as a grid of labels you can run on a laser printer or a professional label printer.

Related barcode tools

Code 128 GeneratorEAN-13 GeneratorQR Code GeneratorUPC-A GeneratorAll Barcode Tools

Related guides

What Is EAN-13Print Barcodes on Avery Labels