BizCode Barcode Add-In for Microsoft Excel
The most professional and unique barcode solution for Microsoft Excel
Quick Overviews
  • Mature barcode plug-in
  • No Programming Skills
  • MS-Excel 2007/2010
  • Linear & 2D barcode support
  • Barcodes Freely Adjustable
How to Encode Data into EAN-13 Using Excel Add-In
Excel EAN-13 Generator is a powerful barcode generating component, enabling single EAN-13 barcode or EAN-13 barcode lists to be easily created in MS-Excel 2007/2010. Supplementary barcode EAN-2 and EAN-5 barcode may also be generated and inserted for EAN-13 barcodes in Microsoft Excel Workbooks.
BusinessRefinery provides a comprehensive guide for EAN-13 generation in MS-Excel, requiring minimum EAN-13 knowledge. Rich data property options are also provided for encoding EAN-13 barcodes with dynamic numeric data. Here is passage about how to control EAN-13 data in Excel; other EAN-13 settings please see:
EAN-13 Data Related Properties

Symbology

Barcode Generator for Microsoft Excel gives full power to users to determine that which data type they want to encode into EAN-13 barcode with Barcode Type option.

Excel EAN-13 Barcode Add-in encodes:
  • 0, 1, 2, 3, 4, 5, 6, 7, 8, 9

Code

Barcode Generator for Microsoft Excel gives full power to users to control EAN-13 barcode data length with Data option.

Supplementary Barcode

Barcode Generator for Microsoft Excel gives full power to users to determine that whether to encode and insert an EAN-2 or EAN-5 barcode on EAN-13 barcode with Barcode Type and Supplement Code options.

Check Digit Calculation

Barcode Generator for Microsoft Excel gives full power to users to decide that whether to add and display Modulo 10 check digit for EAN-13 with Display checksum char option.

Human-readable Text

Barcode Generator for Microsoft Excel gives full power to users to decide that whether they want to display Code text or not under EAN-13 symbol with Display Text option and specify it with Font option.
Customize EAN-13 Barcode Data in Excel
Ensure you have installed those following programs before you start to encrypt your EAN-13 valid character sets in Excel Workbook:
Encode EAN-13 Barcode in Excel
  1. Create a new Excel Document and activate Barcode Add-In for Microsoft Excel;
  2. Go to "Barcode Setting Panel" and choose "Barcode Type" to "EAN-13";
  3. Input some data - "012345678901" in "Data";
  4. Click "Generate"; then an EAN-13 barcode occurs in your Excel Workbook.
Encode EAN-2 for EAN-13 Barcode in Excel
  1. Select the existed EAN-13 barcode in Excel;
  2. Go to "Barcode Type" to "EAN-13+2";
  3. Go to "1D Barcode" and input "13"in "Supplement data";
  4. Click "Update"; then an EAN-13+2 barcode occurs in your Excel Workbook.
Encode EAN-5 for EAN-13 Barcode in Excel
  1. Select the existed EAN-13 barcode in Excel;
  2. Go to "Barcode Type" to "EAN-13+5";
  3. Go to "1D Barcode" and input "13579"in "Supplement data";
  4. Click "Update"; then an EAN-13+5 barcode occurs in your Excel Workbook.