- Completely compatible with Microsoft Office Excel 365 on Windows, Excel 2021, 2019, Excel 2016, Excel 2013, Excel 2010 and Excel 2007
- Automatically calculate the EAN-13 (gtin) check digit without any Excel formula or function.
- Barcode fonts are not required in the generation of EAN-13 barcodes
- The generated EAN-13 barcodes in Excel documents can be printed by all printers
- Easy to insert EAN-13 barcodes in Excel spreadsheets with this mature plugin
- Turn a list of cells in Excel documents into EAN-13 barcodes easily and quickly
Video tutorial for creating, printing EAN 13 in Excel
Top
EAN-13, also known as European Article Number 13, UPC-13, GTIN-13, GS1-13, EAN/UCC-13, is the standard barcode version of European Article Number.
EAN-13 Barcode Add-In for Excel is a professional barcode plugin which can insert high quality EAN-13 barcodes in Microsoft Office Excel documents without any barcode fonts. Users with no programming skills can use this mature add-in freely.
EAN-13 Barcode Add-In for Excel is a professional barcode plugin which can insert high quality EAN-13 barcodes in Microsoft Office Excel documents without any barcode fonts. Users with no programming skills can use this mature add-in freely.
- EAN-13 Barcode Add-In adds EAN-13 barcodes in Excel documents with only a few steps.
- A single EAN-13 barcode and barcode tables can be generated easily and quickly.
- The data of the generated barcode images can be linked to contents of cells.
- Rich parameters of EAN-13 barcodes can be adjusted to meet special applications.
- The check digit is calculated and added by this mature barcode add-in for Excel automatically.
- Thermal printers are supported in printing high quality barcodes on low-resolution printers.
How to create, print EAN-13 barcode in Excel Worksheet?
Top
To generate and insert EAN 13 barcode in Excel document, we will show detailed steps to create a new EAN 13 barcode,
adjust EAN-13 image width and height, modify its text font style and font size, adjust image resolution for printing.
Open Excel Barcode Add-in
- Download and install OnBarcode Excel Barcode Generator Add-in
- Open an existing Excel document. Go to the Add-ins tab on Office Excel ribbon.
- Select Create Barcode button from the OnBarcode.com group section.
Create the first EAN-13 barcode image
- Select the cell
C4to insert an EAN-13 barcode - Change Data textbox value to "=LINK(B4)". The EAN-13 will encode the cell
B4value. - Check Resize Covered Cell. The EAN-13 covered cell will automatically adjust its width and height.
- Choose "EAN 13" as Barcode Type
- Click Generate to create, insert EAN-13 barcode image to cell
C4
-
Now you will find that an EAN-13 barcode image is created and inserted to cell
C4, and the barcode data is using the value of cellB4.
Start to Install Excel Barcode Add-in
Start using OnBarcode Excel Barcode Generator Add-in in your Excel document now with a free trial.
Start with free trial add-in:
Resize EAN-13 barcode image width & height
Now we will resize the EAN-13 barcode image width and height
- Select the created EAN 13 image, and make sure the option Auto resize is checked.
- To resize the EAN-13 image, hold the resize corner handles, and then drag the handles out to enlarge the EAN-13 image size.
- Click the image again, and you will find that the options Image width, Image height values have been updated.
- Click button Update to re-print the size adjusted EAN-13 barcode image.
Customize EAN-13 barcode with barcode options in Excel
Here we will adjust the EAN 13 barcode text font style and font size.
To change the EAN 13 text style, we will use the options under tab Barcode Size and 1D Barcode.
-
Uncheck Auto resize barcode text in tab "Barcode Size". We cannot change any barcode text size related settings, until we uncheck this option.
- Under tab Barcode Size, set Text margin to 24, which will increase the space between barcode and barcode text
- Under tab 1D Barcode, set Font size to 16, which will increase the displayed barcode text size.
- Click button Update to re-create the EAN-13 barcode with updated text style
Print EAN-13 barcode with high resolution image in Excel
If you need create Excel document with high resolution EAN-13 barcode image for printers, first you need enable Excel document for high resolution. See details here:
How to enable high resolution image in Excel document for barcode printing?
Sometimes, your Excel docuemnt with EAN-13 barcode images will be printed. We need re-generate EAN-13 image for printer.
How to enable high resolution image in Excel document for barcode printing?
Sometimes, your Excel docuemnt with EAN-13 barcode images will be printed. We need re-generate EAN-13 image for printer.
- Select the EAN 13 image, go to option DPI, and set value to 1200. The resolution (DPI) values should be the same or greater than your printer's
-
Click button Update to re-print high resolution EAN-13 barcode images.
How to generate multiple EAN-13 barcodes (batch barcodes) in Excel Worksheet?
Top
To generate and insert list of EAN 13 barcodes in Excel document at one time,
you need follow the steps below.
Here are the main stages to create batch EAN 13 barcode images at once.
Here are the main stages to create batch EAN 13 barcode images at once.
- Prepare a list of cell data in Excel file
- Generate the first EAN-13 barcode image as template with customized options applied.
- Create list of EAN 13 images based on the cell data list and contain customizd options from the sample EAN 13 template
Step 1: Open an Excel file with list of barcode data, and create the first barcode as template
You can open an Excel file with list of barcode data using Microsoft Excel application. Create the first barcode as template.
See step by step tutorial in details here: How to create a EAN-13 barcode in Excel Worksheet?
See step by step tutorial in details here: How to create a EAN-13 barcode in Excel Worksheet?
Step 2: Create multiple barcodes in Excel
- Click the first barcode in Excel, and you will find the message "Copy from: Cell [C4] EAN13".
-
Select cell
C5where you want to create and insert another EAN-13 barcode. -
Click Duplicate button, and you will find that a new EAN-13 barcode has been created and inserted in cell
C5
- You can select multiple cells by pressing Shift key. Select two cells
C6andC7together, and click Duplicate All button.
The two new EAN-13 barcode images have been printed and inserted in cellsC6andC7.
EAN-13 Data Characters Encoding in Microsoft Excel
TopEAN-13 data character set
EAN-13 barcode can encode numeric digits from 0 through 9.
EAN-13 with add-on symbol
EAN-13 barcode may be accompanied by an two-digit or five-digit add-on symbol.
- Two-digit add-on: include 2 digits data
- Five-digit add-on: include 5 digits data
|
Two Digits Add-on
|
Five Digits Add-on
|
|
|
EAN-13 check sum digit
The EAN-13 check digit is an additional digit used to verify that an EAN-13 bar code has been scanned correctly.
Using OnBarcode Barcode Generator for Excel add-in, the EAN-13 barcode software will automatically calculate the last checksum digit for you.
If your provided EAN-13 data includes the 13th digit, the software will ignore it, and calculate the checksum digit based on your first 12 digits.
You can view the EAN-13 check digit calculator at:
How to calculate EAN-13 check digit?
Customize EAN-13 barcodes with options in Microsoft Excel
TopBasic Settings
- Barcode Type: choose "EAN 13" for EAN-13 barcode, "EAN 13 +2", or "EAN 13 +5" for EAN-13 barcode with 2-digit or 5-digit supplemented data.
- Data: Key in EAN-13 barcode data. The valid EAN-13 data formats is 12 or 13 digits (0-9). If EAN-13 has supplemented barcode, add "+" with supplemented data. For example, EAN13 with 2-digit supplemented data "123456789012+12".
EAN-13 Supplemented Barcode
- Bar height: (In Supplement data under tab "1D Barcode" ) This is a multiplicator of the height of the bar module; The default is 0.8 (80% of Y - bar module height).
- Bar space (in px): The space between the barcode and the supplement bar. Default is 15 pixel.
Barcode Common Settings
- Customize EAN 13 Human Readable Interpretation (displayed text), please view the options here:
How to customize created 1d barcode displayed HRI (barcode text) in Excel - Customize EAN-13 barcode dimension width and height, please view the details here:
Barcode dimension size options in Excel - EAN-13 bar/space module colors, you can apply EAN-13 bar and space modules color settings.
view details here:
How to apply barcodes bar and space color settings in Excel?
How to generate EAN-13 with 2 or 5-digit add-on code in Excel Worksheet?
Top
EAN/UPC bar codes may be augmented with a two-digit supplemental code to indicate the issue number for a periodical.
Five digit supplemental codes are used with the product number to identify paperback books.
It's really easy to create EAN-13 barcode with supplemental codes in Excel using Barcode Generator for Excel Add-in.
It's really easy to create EAN-13 barcode with supplemental codes in Excel using Barcode Generator for Excel Add-in.
- Open Excel Barcode Generator Add-in in Excel
- Choose Barcode Type as EAN 13 +2
-
In Data textbox, key-in 12 or 13 digits for EAN 13 barcode, followed by "+" char and 2 digits for supplemental code. For example:
"123456789012+12".
Common Asked Questions
What is the EAN-13 code?
EAN-13 is a 13-digit barcode, which includes 12 data digits and 1 check sum digit. EAN is short for European Article Number,
and now it is renamed as GTIN (Global Trade Item Number). EAN 13 code will be used to uniquely identify retail products worldwide.
Using Excel Barcode Generator add-in, you can provide the 12-digit data or complete 13-digit EAN code, and the barcode software will create and print EAN 13 barcode images in Microsoft Excel document.
Using Excel Barcode Generator add-in, you can provide the 12-digit data or complete 13-digit EAN code, and the barcode software will create and print EAN 13 barcode images in Microsoft Excel document.
What is the difference between EAN and EAN-13?
EAN barcode includes EAN-13, EAN-8, and their two or five add-on barcodes. OnBarcode Excel Barcode add-in supports both EAN-13 and EAN-8 barcodes generation
in Office Excel files.
What is the EAN-13 barcode layout?
The 13 digits EAN-13 code is grouped as follows:
- 2 or 3 digits for the number system or the country code
- 5 or 4 digits for the manufacturer code or prefix
- 5 digits for the product code
- 1 digit for the check digit
How to check if the EAN-13 barcode created in Excel is valid?
The last digit of EAN-13 is a check digit. It will be used to verify the first 12-digit data. Using Excel barcode add-in,
the generated EAN-13 barcode check digit is calculated and verified by the barcode software.
If you want to know more about EAN-13 check digit calculator, view details here:
How to calculate EAN-13 check digit?
If you want to know more about EAN-13 check digit calculator, view details here:
How to calculate EAN-13 check digit?
What is the minimum size for EAN-13, how to apply it in Excel?
The GS1 recommended minimum size for an EAN-13 barcode is 30mm in width and 20 mm in height. The barcode add-in user
can input the specified EAN-13 barcode width and height through property
Image Width and Image height in the "Barcode Settings" pane.
How do I print EAN-13 barcodes in Excel document?
To print good quality EAN-13 barcodes in Microsoft Excel documents, you need check the following rules:
- The EAN-13 barcode image resolution (DPI) is the same or higher than the printer's resolution.
- The EAN-13 human readable text is using the legible fonts. The GS1 System recommends use OCR-B font to render EAN-13 text label. OnBarcode Excel Barcode add-in is using a free OCR-B font.
