Generate Code 128 barcodes from excel


If you look for how to generate Code 128 barcodes from excel excel through internet, you will find with lot of companies that sell proprietary products to make this kind of codes, but is not easy to find a free tool to do the job… however they exists. At sourceforge there is a project called ‘openbarcodes‘ that give us all the resources to make them, and of course they are free.

The steps to follow are the following:

  1. Download this file, it contains the font used to write the barcodes:
  2. Extract the file code128.ttf in the folder FONTS of Windows (normally “C:\WINDOWS\Fonts”). In my case it is at:

  3. Download the following excel file that contains the macro necessary to generate the Code 128 barcodes with checksum, without this checksum the scanner can’t read the data correctly.
  4. In the column A you have to enter the numbers (or string) to encode, and in colunm C will appear the encoded barcodes. The column B is hidden because it’s used to make some calculations.



One reply on “Generate Code 128 barcodes from excel”

Leave a Reply

Your email address will not be published. Required fields are marked *