Barcode label generator for Excel: from spreadsheet to printed sheets
Last updated:
If your codes already live in Excel, you do not need barcode fonts or add-ins: a barcode label generator that reads Excel files can lay them out on your label sheet in one step. This guide uses the batch mode of the free EasyArchive generator and common 30-up Letter sheets as the example.
Steps
Check your sheet size
Read the pack: page size (Letter or A4), labels per sheet and label size. A common Letter layout is 30 labels of 2⅝ × 1 in, which matches the tool's "Avery 5160 · Letter · 30 (2⅝×1in)" template.
Prepare the spreadsheet
One row per label and one column with the code. Format the code column as Text to keep leading zeros. Add optional text columns and a quantity column.
Import in batch mode
Open the Barcode & QR Label Generator, go to batch mode and choose your CSV, TSV/TXT, XLSX or XLS file. Pick the worksheet and tick "First row contains column names" if needed.
Map columns and code type
Choose the barcode value column, text-line columns and quantity per row. Code 128 suits letters and digits, QR suits phone scanning, EAN-13 only if you have GS1 numbers.
Check and generate
Click "Check rows & preview"; invalid rows are listed and skipped. Then "Generate PDF".
Test and print
Print one page on plain paper at 100% / Actual size with the right paper size, compare it with the label sheet, then print the batch.
Which label sheets work?
Built-in templates: Avery 5160 and 5163 (Letter), Avery L7160, L7163, L7651 and generic grids (A4), plus a Letter 3×10 grid. Other brands work when the label size, count and margins match a template — always test first. EasyArchive is not affiliated with Avery or any other label brand; template names only indicate matching sizes.
Limits and privacy
Up to 5,000 labels per PDF (one batch); split larger lists into several batches. The file is processed in your browser.
Retail barcodes
Official EAN/UPC numbers for retail products are issued by GS1. The tool draws the code and checks the check digit, but does not issue numbers.
Related guides
- How to print barcode labels from Excel for free (archive boxes and folders)
- Fill PDF forms in Arabic, write Arabic on a PDF and add Arabic page numbers
- Write Arabic in a PDF file: Hijri dates and Arabic page numbers
- All guides
Turn your spreadsheet into labels
Frequently asked questions
Can I make barcodes in Excel without fonts or add-ins?
Yes: keep the codes in an Excel column and import the file in the generator's batch mode; the PDF is laid out for your sheet.
Which template matches 30-up Letter labels?
"Avery 5160 · Letter · 30 (2⅝×1in)" (2⅝ × 1 in). Compare with your pack and print a test page.
Why are my labels misaligned?
Print at 100%, turn off "Fit to page" and choose the correct paper size (Letter vs A4).
How many labels per run?
Up to 5,000 per PDF; split larger lists into batches.