Note: All screenshots below can be opened full-size by clicking on them.

Installing the barcode fonts and add-in

Please close Excel before proceeding.

Unzip the downloaded archive by right-clicking and selecting Extract all from the context menu. Then, open the folder Fonts.
Excel Barcode Add-In
In the folder select all available fonts.

Right-click for context menu and select Install. This will install the barcode fonts on your PC. You may be prompted for an administrator password.
Excel Barcode Font
Next, go back to the parent folder and double-click setup.exe. Follow the instructions on your screen. This will install the Barcode Add-In on your PC.

Verifying the installation

Launch Excel and in the ribbon switch to the Add-Ins tab.

You should see the Barcode Add-In pane:
Excel Barcode Add-In Ribbon
Click the Info button and verify that the barcode fonts are listed. If you are running the demo of the Barcode Add-In, the dialog will also list the expiry date of the demo.
Excel Barcode Add-In Installed Barcode Fonts

Creating a single barcode in Excel

We start by creating a single barcode in Excel. In cell A1, enter the value 1000. Hit <Enter>, then click into the cell to select it.

Next, click the Create Barcode button to open the barcode creation dialog:
Excel Single Cell Barcode
The add-in defaults to Code 128 and placement of the code into the cell right to the source data. Leave all settings at default and click Ok.

You should see a barcode in cell B1.
Excel Single Code 128 Barcode

Creating a barcode sequence in Excel

Next, let's create a barcode sequence in Excel. Using auto-fill, create a list of numbers, starting with 100000 and incrementing by one. Make sure to select the generated numbers.

Next, click the Create Barcode button to open the barcode creation dialog:
Excel Sequential Barcode Series
Again, we'll be creating Code 128. Adjust the size to your liking, you can also experiment with the human readable text that goes under the barcode.
This time we don't need the original numbers anymore so we select Overwrite source cell in the Position pane.

Clicking Ok overwrites the original sequence with Code 128 barcodes:
Excel Sequential Code 128 Series

Excel Add-In Supported Barcode Symbologies

The current version of the barcode add-in (V5) supports the following barcode types:
  This table lists the requirements for the different types with regard to check digit calculation, encoded data and size:

SymbologyDataCheck digitRemarks
EAN 87 or 8 digitsalwaysUse size 36pt. with EAN Red., 72pt with EAN Standard

See Excel EAN Barcodes...
EAN 1312 or 13 digitsalwaysUse size 36pt. with EAN Red., 72pt with EAN Standard

See Excel EAN Barcodes...
UPC-A11 or 12 digitsalwaysUse size 36pt. with UPC Red., 72pt with UPC Standard

See Excel UPC Barcodes...
Code 128Digits, letters, special chars (max. 40 chars)alwaysAutomatic selection of Code 128 sub types A, B, C

Recommended size: 24pt. or higher

See Excel Code 128 Barcodes...
Code 128 GS1/EAN/UCCDigits, letters, parenthesized application identifier (max. 40 chars)alwaysAutomatic selection of Code 128 sub types A, B, C

Enter your data including application identifiers, e.g. (01)1234567890. The software will automatically insert all required FNC1 symbols.

Recommended size: 24pt. or higher

See Excel Code 128 GS1 Barcodes...
Code 2/5 InterleavedDigits 0-9 (max. 40 digits) optionalRecommended size: 24pt. or higher
Code 2/5 IndustrialDigits 0-9 (max. 40 digits)optionalRecommended size: 24pt. or higher
Code 39 / 39 ExtendedDigits, letters (max. 40 chars)optionalAutomatic selection of Code 39 / Code 39 Extended

Recommended size: 24pt. or higher

Excel Barcode Add-In Miscellaneous