New Year offer

Celebrate the New Year with 10% off the Yearly subscription plan. Use code NEWYEAR26 at checkout.

View plans

Print Bulk Barcode Labels from Excel on A4 Label Sheets

Smart work for Fast shipping
Print Bulk Barcode Labels from Excel on A4 Label Sheets
Barcode Generator

Print Bulk Barcode Labels from Excel on A4

22-09-2026 · PDF Cropper

Typing barcodes one by one does not work for a full product catalogue. The Barcode Generator reads an Excel or CSV file and lays every label out on a printable sheet.

This is the quickest way to print bulk barcode labels from Excel on A4 label sheets.

Prepare Your Excel File

  • Barcode :

    The code to print.

  • Product Name :

    Printed above the barcode (optional).

  • MRP :

    A number like 499 prints as MRP ₹499 (optional).

  • Qty :

    How many labels for each product (optional).

Not sure about the format? Download the sample Excel file from the tool and fill it in.

Print on A4 Label Sheets

Choose your sheet - 65, 40, 24, 21, 14 or 12 labels per A4 page - or set a custom grid. The page preview shows exactly where each label lands.

Check Before You Print

  • Skipped Rows :

    Invalid codes are listed with their row number so you can fix them.

  • Print at 100% :

    Turn off fit to page so labels line up with the sheet.

Tips for a Clean Excel File

A well-prepared Excel file saves time and prevents errors. Keep one product per row, with the barcode and the optional columns laid out as in the sample file. Make sure the barcode column is formatted as text, because Excel sometimes changes long numbers into scientific notation or removes leading zeros, which breaks EAN and UPC codes. Remove empty rows and extra spaces, and check that product names are short enough to fit on the label size you plan to use. If you are not sure about the layout, start from the sample file and paste your data into it.

Choosing the Right Label Sheet

The best label sheet depends on how much information each label needs. Sheets with many small labels, such as 65 per page, work for simple barcodes without names. Sheets with fewer, larger labels, such as 21 or 24 per page, leave room for a product name above the barcode and an MRP below it. Always check the label sheet brand and layout printed on the packet, and match it with the template in the tool or set a custom grid with the exact label sizes and gaps. If you need price tags rather than plain barcode labels, the Price Tag Maker works from the same kind of Excel list.

Printing Labels on a Thermal Printer

If you use a thermal label printer instead of A4 sheets, choose a thermal label size and the tool creates one label per page. This is useful for printing barcodes on demand, one product at a time, or for sellers who already use a thermal printer for shipping labels. Load the matching label roll, set the paper size in the printer driver and print at actual size. QR codes can be printed in bulk from Excel in the same way with the QR Code Generator.

Checking Your Printed Labels

  • Scan a Few Labels :

    Test labels from the start, middle and end of the batch.

  • Check Alignment :

    Make sure labels sit in the centre of each sticker on the sheet.

  • Count the Quantities :

    Compare the number of labels printed for each product with your Qty column.

  • Look for Skipped Rows :

    Fix and reprint any rows that were skipped because of invalid codes.

Frequently Asked Questions

Can I use a CSV file instead of Excel? Yes. CSV files and pasted lists are also supported.

What happens if a code is invalid? The row is skipped and listed with its row number, so you can correct it and print it again.

How many labels can I create from one file? You can add your whole product list at once. Use the quantity column to print several labels for each product without repeating rows.

Can I print the MRP with the rupee symbol? Yes. Enter a number such as 499 in the MRP column and it prints as MRP with the rupee symbol below the barcode.

Conclusion

One Excel file, one PDF, a full set of labels. Upload your list to the Barcode Generator and print your whole range in one go.

Barcode Generator - Related Blog

Barcode Generator blog
Barcode Generator

Barcode Printing Tips

24-09-2026
Barcode Generator blog
Barcode Generator