Printing Barcodes in Excel

All of our barcode fonts work within Microsoft Excel spreadsheets. All of our bar code font packages come with Excel macros that create barcodes from your spreadsheete data. Our Excel macros print UPC, Code 128, Code 39, Interleaved 2 of 5, POSTNET, and other barcode symbologies.

Our free sample code includes a macro function that adds the start and stop bars to your data, and then calculates any needed check digits. Pass your cell or text string to our macro and format the returned text in our barcode fonts.

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 the macro to your own spreadsheet.

make UPC barcodes in Excel

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

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

    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 & ReadMe for Excel 2004 (Mac):
    UPC version A  •  UPC version E  •  ISBN-13  •  EAN-13  •  EAN-8

    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

We have free sample spreadsheets for Excel 2003 and Excel 2007 (Windows) and Excel 2004 (OS X). The functions are provided in text form as well. Use our functions as reference implementations if you need to port it to another language or platform.

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.