Printing Barcodes in Excel Spreadsheets

All of Azalea Software’s barcode fonts, like UPCTools, C128Tools, C39Tools & POSTools, work within Microsoft Excel. We have free Excel macros that print UPC, Code 128, Code 39, Interleaved 2 of 5, POSTNET, and other barcodes right in your spreadsheet.

Convert your spreadsheet data into the equivalent barcode using our free Excel sample spreadsheets and macros. The barcode macros have with a function that adds the start and stop bars to your data & calculates any needed check digits. Pass your data into our macro and format the returned text in one of our barcode fonts. That’s all there is to it.

The great thing about using our Excel macros is that you don’t have to learn how barcodes are built or how they work. Just use our sample spreadsheets as your working template and copy our macro into your own spreadsheet.



right click on a macro and then save it to your hard disk

Macros and User Defined Functions for Excel 2003 & 2007:
UPC version A  •  UPC checkdigit  •  UPC version E  •  ISBN-13  •  EAN-13

Code 128 code set A  •  Code 128 code set B  •  Code 128 code set C
GS1-128 code set A  •  GS1-128 code set B  •  GS1-128 code set C

Code 39  •  Code 39 Full ASCII  •  Code 39 check digit

Interleaved 2 of 5  •  ITF-14  •  POSTNET

The macro code as text for Excel 2004 (Mac) & reference implementation:
UPC version A  •  UPC checkdigit  •  UPC version E  •  ISBN-13  •  EAN-13

Code 128 code set A  •  Code 128 code set B  •  Code 128 code set C
GS1-128 code set A  •  GS1-128 code set B  •  GS1-128 code set C

Code 39  •  Code 39 Full ASCII  •  Code 39 check digit

Interleaved 2 of 5  •  ITF-14  •  POSTNET

Mail Merge:
Excel 2003 and Word 2003  •  Excel 2007 and Word 2007

The Excel 2004 (Mac) functions are in text form. You can use these functions as reference implementations if you need to port them to another language or platform.

Copying a macro from one spreadsheet to another:
    Excel 2003 Excel 2007

If you don’t see what you’re looking for please ask us. We often have sample code for other applications and dev tools to share with you. If you write something you’d like to share with others, please contact us.