Can Excel create barcodes? Yes, and it’s as easy as downloading the correct fonts. You don’t have to purchase any of those barcode software programs that you can find online unless you need a more unusual kind of code, such as an ISBN or a postal code. Free fonts are available for most of the common barcodes, and fee-based fonts are available for the others (at reasonable prices).

There are also many sites that generate barcodes for you, which cost nothing (although some do ask for donations). My favorites include: Online Barcode Generator, which offers (believe it or not) 102 different barcode types, Free Barcode Generator (with 99 different types), and Barcode Generator.org (with 67 different types). Bet you didn’t know there were so many different barcodes.

If, however, you prefer to generate your own barcodes in Excel (or Word, PowerPoint, or any other program that uses Windows fonts), you can do that as well, and it’s really easy.

How to download barcode fonts

First, you need to access the Internet and download the appropriate fonts. The most commonly used barcodes are:

  • UPC-A and UPC-E codes, which means Universal Product Code, are used for consumer products (groceries, household goods, etc.). They are scanned at the Point-of-Sale (POS).
  • EAN-13 and EAN-8 codes, which means European Article Number, are similar in purpose to UPC codes.
  • Code128 codes, which refer to the ASCII 128-character set, are used in logistics for ordering, distribution, and transportation.
  • Code39 codes, which literally means Code 3 of 9, uses 39 digits and characters. These codes are used for the automotive industry, name badges, inventory, and industrial applications.

Here’s an example of how to use these fonts. 

1. Click Barcode Link to locate and download the free barcode fonts for Code128 and Code 39 (use the Free 3 of 9 Extended font called fre3of9x.ttf).

2. Double-click the link called Download Code 128 Barcode Font. Click the Save button, then click OK.

3. When the Font dialog window opens, click the Install button to add this font to your Windows font folder.





READ SOURCE

LEAVE A REPLY

Please enter your comment!
Please enter your name here