How to Print labels with data from an Excel spreadsheet? - Video Guide


How to Print labels with data from an Excel spreadsheet? - macOS Tutorial

1. On your Mac, open Barcode & Label, then import an Excel spreadsheet by clicking the Drawer icon (located next to Settings). Select Excel → Select to choose your Excel file. A sample file, sample.xlsx, is provided for your convenience. Ensure you see the message "Excel file imported successfully" before proceeding to the next step.

Mac Import Excel

Import Spreadsheet

The Import Excel feature in Barcode & Label requires data to be stored in a worksheet with the first row serving as the header. This is illustrated below and explained in detail at the end of this section.

Excel Spreadsheet

Sample Excel Spreadsheet

2. To preview the imported Excel file, click Data Source (Drawer icon) → Excel → View. This will display sample columns and rows from the spreadsheet.

View Import Excel

View Imported Excel

To update the label with new Excel data, simply tap the Clear option to remove the existing data, then import a new spreadsheet.

3. Next, let's insert columns from the Excel spreadsheet onto the label. Tap the "+" button, then select "Add Text" → "Excel File" → "Excel Column: 01". The first column in the sample Excel file contains the Product ID. Tap the "+" button again to add "Excel Column: 02", which corresponds to the Product Name. The Inspector allows you to easily change the text to display any of the Excel columns.

Insert Excel Fields

Insert Excel Fields

4. In addition to using spreadsheet columns to add text on labels, you can also add a barcode. To do this, insert a Code 39 barcode, and in the Inspector, set the Input Type to "Excel Column: 01".

Insert Excel Fields

Excel Barcode Column

5. Tap the Preview button in the top-right corner to see how your labels will appear. The preview displays data from the first few rows of your Excel file.

Mac Print Excel Labels

Print Excel Labels

When you save your label design, the associated Excel data is saved with it. The next time you open the label, the data will be automatically available for printing.

How to Print labels with data from an Excel spreadsheet? - Video

How to Print labels with data from an Excel spreadsheet? - iOS Tutorial

1. On your iPhone/iPad, open Barcode & Label, then import an Excel spreadsheet by tapping on the top left Label icon. Select Data Source → Excel → Select to choose your Excel file. A sample file, sample.xlsx, is provided for your convenience. Ensure you see the message "Excel file imported successfully" before proceeding to the next step.

Import Excel on iPhone/iPad

Import Spreadsheet

The Import Excel feature in Barcode & Label requires data to be stored in a worksheet with the first row serving as the header. This is illustrated below and explained in detail at the end of this section.

Excel Spreadsheet

Sample Excel Spreadsheet

2. To preview the imported Excel file, tap on the Label → Data Source → Excel → View option. This will display sample columns and rows from the spreadsheet.

View Import Excel

View Imported Excel

To update the label with new Excel data, simply tap on the Clear option to remove the existing data, then import a new spreadsheet.

3. Next, let's insert columns from the Excel spreadsheet onto the label. Tap the "+" button (at the bottom toolbar), then select "Add Text" → "Excel File" → "Excel Column: 01". The first column in the sample Excel file contains the Product ID. Tap the "+" button again to add "Excel Column: 02", which corresponds to the Product Name. The Inspector allows you to easily change the text to display any of the Excel columns.

TIP – You can also add Excel fields to the label before importing the Excel spreadsheet.

Insert Excel Fields

Insert Excel Fields

4. In addition to using spreadsheet columns to add text on labels, you can also add a barcode. To do this, insert a Code 39 barcode, and in the Inspector, set the Input Type to "Excel Column: 01".

Insert Excel Fields

Excel Barcode Column

5. Tap the Preview button in the top-right corner to see how your labels will appear. The preview displays data from the first few rows of your Excel file.

Mac Print Excel Labels

Print Excel Labels

When you save your label design, the associated Excel data is saved with it. The next time you open the label, the data will be automatically available for printing.

Excel Spreadsheet Format

The following provides an overview of the Excel Spreadsheet Format supported by Barcode & Label.

Excel Spreadsheet

Sample Excel Spreadsheet

Excel Spreadsheet Format Notes

  • Column Headers in the First Row.
  • Up to 10 columns supported.
  • Up to 1000 rows supported (50 rows in the Free version).