Azalea Software, Inc. www.azalea.com Barcodes in Excel Spreadsheets Free Excel Barcode Macro

Printing barcodes in a spreadsheet is easy using our barcode fonts with the free macros we provide. All of Azalea's barcode font packages can print bar codes in Excel spreadsheets. Make UPC, ISBN-13, POSTNET, Code 128, Code 39, and other symbologies from your exiting data.

print bar codes in Excel spreadsheetsThese Excel macros begin with your input data and then add the start and stop characters, calculates all of the check digits, and then maps into our fonts’ character set. You don’t have to learn how barcodes are built or how they work. Use our sample spreadsheets and everything is pre-built for you.

The Excel spreadsheets below all include a macro that creates barcodes from your existing spreadsheet data. The spreadsheets are self-documenting and include comments about how they work and how to use them. You can edit and modify our spreadsheets to suit your needs or simply copy the macro into your own spreadsheet.

Macros and User Defined Functions for Excel 2003 & 2007:
    UPC version A  •  UPC version E  •  ISBN-13  •  EAN-13
    UPC version A check digit (more info...)  •  UPC version E undo

    Code 128 code set A  •  Code 128 code set B  •  Code 128 code set C •  Code 128 & Excel
    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
    UPC version A check digit  •  UPC version E undo

    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
    POSTNET  •  Interleaved 2 of 5  •  ITF-14

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

An alternative is to use the Excel XLA that ships with all of our font packages. The XLA file includes custom functions that create barcodes in your spreadsheets. Download AzaleaBarCodes.xla into your XLStart directory (Program Files\Microsoft Office\OFFICE11\XLSTART). If you're running Windows XP or Vista, insert barcode.dll into your \WINDOWS\SYSTEM32 directory. On Windows 2000, Windows Server, or WindowsNT, put barcode.dll in your \WINNT\SYSTEM32 directory. Reboot your computer and our barcode functions will appear as a user defined function in Excel.

UPC, ISBN-13, EAN, ISSN  •  Code 128  •  Code 39  •  Interleaved 2 of 5  •  POSTNET

free barcode softwareIf you don't see what you're looking for please ask us. After all these years we have sample code for other applications and dev tools we'd be glad to share with you.

Try out our free demo! It includes a free Code 39 barcode font for you to download and play with.

Email or call us if you have questions.