Creating a Simple EAN13 Barcode Labelling Spreadsheet Using Excel
Disclaimer: The information contained on this page forms part of my GPC CPD portfolio and is therefore my personal opinion and in no way reflects the opinion or policy of my employer.
In addition to expanding my knowledge of barcode systems, the aim of this learning exercise was to create a very simple spreadsheet application that would contain a list of EAN13 codes, which could then be printed on to labels so that they could be attached to product packs that were not supplied with a barcode label. This allowed these additional products to be scanned into an automated product storage and retrieval system.
Download the Barcode-Creator.zip file here and then unzip the file
Go to Start>>Control Panel>>Fonts
Click File>>Install New Fonts…
Navigate to the location that you unzipped the parent “Barcode-Creator” folder and select the ean13.ttf
Open the Excel Spreadsheet
A security warning bar will appear – Click: Options>>Enable this Content>>OK
The Barcode Creator tool is made up of two sheets “BarcodeCreator” and List.
To add a product and barcode to the system, navigate to the “List” Spreadsheet.
Enter the product description in column A and then the first 12 digits of the chosen EAN code in column B. (The last digit is the check digit and is calculated – once you know what it is you can add it to column C).
Once you have added the entry in the “List” spreadsheet, make sure you save your changes.
Go back to the “BarcodeCreator” sheet and then select the product from the dropdown list.
On selection, four barcodes will appear to the right (I required 4 identical barcodes to be printed on one 760mm x 380mm label, although you can modify to suit your own purposes by adjusting the print area).
Click on the “Print” button.
The print area will be shown in print preview. You may need to modify the paper size and orientation settings to suit your requirements.
And that’s it! Very simple printing of barcode labels using a Macro-Enabled Excel Spreadsheet.