How to Generate Bulk Barcodes and Print Labels from Excel?

2023-06-16 18:21

Even though there are a plethora of free online barcode generators available, there’s a dearth of integrated tools for users who want to both generate barcodes and edit labels. This is where Herelabel, a label editing and barcode generator software by HPRT, stands out as a rare gem. With its user-friendly interface design, it makes barcode label printing a breeze, seamlessly connects with all thermal label printers under HPRT, and helps you generate bulk barcodes and customized labels.

Most features of this software are free for users, all you need to do is to register for online access. Let’s dive into how it effortlessly enables bulk barcodes generating and printing from Excel.

Step 1: Prepare Your Excel Spreadsheet

If you need to print barcodes from excel, prepare an Excel spreadsheet containing the data needed for the barcode labels. This data may include product name, SKU, or other relevant information. Ensure the table structure is organized, and the data is clear. Here’s an example of a fixed asset barcode label worksheet:

asset labels worksheet

Step 2: Register Herelabel Software

Visit the official website of Herelabel at, click on "register" in the top right corner. After registration, go to "Herelabel" in the navigation bar to enter the label interface.

Step 3: Use Custom Label Template

Herelabel provides a plethora of industry templates. Choose the suitable one and select "edit label" as per the prompt to enter the label editing interface.

label templates provided by Herelabel software

If you want to create a new template, simply select "Create a new label". Define your label name and set the parameters such as size, number of rows and columns, etc. After finishing the edits, click "confirm" to save.

creat a new label interface in the Herelabel

Step 4: Add Label Items

Type the asset number, asset name, and other fixed items into the label. Align, adjust the font, and size using the software tools.

editing the label in the Herelabelediting the label in the Herelabel

Step 5: Import Data from Excel to Herelabel

In the "data source" dropdown menu, choose "Database text". In the connection option, select "Local data". Locate your spreadsheet and click "open" to import the data.

import data from excel

Click "Insert data", and the dropdown menu will display the header content of the first row in the Excel sheet. Select the corresponding header item for the variable parts of the label in the dropdown menu. Consequently, the content of the second row of labels in the Excel sheet will be fully displayed.

import data from excellabel generating

Step 6: Generate Bulk Barcodes

Select the barcode option on the left side. A random barcode will appear on the label editing window. Like the previous step, select "Database text" in the data source dropdown menu and "Local data" in connection options to upload the excel spreadsheet. Click "Insert data", then select "Asset Code" in the dropdown menu, and the random barcode will transform into a barcode containing the asset code information. In this way, you can generate bulk barcodes from excel.

barcode generating

Step 7: Customize Your Barcode Labels

Herelabel offers various customization options to create the perfect barcode label for your needs. You can choose from various types of barcodes and QR codes, such as code 128, code 39, EAN13, etc, and adjust the label’s size and orientation. Additionally, you can add text, logos, or other design elements to your label to make it more striking and personalized.

Step 8: Bulk Print Labels from Excel

Once you’ve adjusted the label content, click "print". In the preview window, you can see that the labels for other rows in the Excel sheet have also been generated automatically. Click print to complete your bulk label printing task.

bulk barcode printing

Using Herelabel to generate bulk barcodes and print bulk barcode labels from Excel, has become effortless. Just follow the simple steps above, and you can generate customized barcode labels for your business, optimizing inventory management and boosting operational efficiency. Take action now and experience the convenience and efficiency brought by Herelabel!

HPRT is a professional manufacturer engaged in the R&D and manufacturing of printing devices, committed to providing customers with high-quality products that integrate cutting-edge technology, excellent quality, and comprehensive worry-free services. The barcode label printer launched by HPRT, with its outstanding performance and stability, has won unanimous praise from users. In addition, HPRT supports customers in personal customization and provides professional OEM/ODM services. We warmly welcome interested customers to contact us, and HPRT will serve you with dedication.

We use cookies on our website to give you the very best user experience. By using this site, you agree to its use of cookies.

Send An inquiry

Send An inquiry

    Please fill in your name,email and requirement

  • Please fill in the type of request.
  • Please fill in your name.
  • Please fill in your email.
  • Please fill in your inquiry content.