EAN-13 Barcode Generator Add-in for Excel

Create, print EAN-13 barcode in Excel spreadsheet. Free Download. No gtin check digit calculator, barcode font, Excel macro, VBA, formula.

Free Download to generate, print EAN-13 barcode in Excel spreadsheet w/o barcode EAN-13 font, Excel macro, VBA, formula.



In this EAN-13 generator Excel user guide, you will learn how to create, print EAN-13 barcode images in Microsoft Office Excel files.

  • Quick to create EAN-13 barcodes based on Excel cell data
  • Customize EAN 13 barcode with dynamic image width, height setting, text style, font size, high resolution DPI for printers
  • Easy to generate bulk EAN 13 barcode images
  • No font, vba, macro programming required.

How to create EAN-13 barcodes in Office Excel without fonts?

  1. Download EAN-13 Barcode Generator Excel Add-in
  2. Install AN-13 add-in to create AN-13 barcodes in Excel files
  3. Step by Step Tutorial














  • Completely compatible with Microsoft Office Excel 2016, Excel 2013, Excel 2010 and Excel 2007
  • Automatically calculate the EAN-13 (gtin) check digit without any Excel formula or function.
  • Users do not need to know EAN-13 barcode specifications and programming skills
  • 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
  • Industry standards are predefined well in EAN-13 barcodes
  • 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




A quick video tutorial for making EAN 13 in Excel
Top


EAN-13 Barcode Generator Introduction

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 Data

EAN-13 barcode can encode numeric data from 0 through 9.

How many digits is EAN-13

Each EAN-13 includes 13 digits. The first 12 digits are data message, followed by a trailing check digit. Using OnBarcode EAN-13 barcode generator software, you need input the first 12 digits only, and our software will calculate the last check sum digit automatically.

Features of EAN-13 Barcode Add-In for Excel

Top
  • 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, insert 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.

  1. Download and install OnBarcode Excel Barcode Generator Software

  2. Open an existing Excel document. Go to the Add-ins tab on Office Excel ribbon.

  3. Select Create Barcode button from the OnBarcode group section.

  4. Select a cell [C6] to insert EAN 13 barcode. Change Barcode Type to EAN 13. Keyin a dummy data with 12 digits 012345678912. Click button "Generate" in the Barcode Setting.
    Note: Each EAN 13 barcode includes 13 digits. The first 12 digits are data message, and the last digit is the check sum digit, which will be calculated and generated by EAN 13 barcode generator automatically.

  5. Now you can see a EAN 13 barcode with dummy data generated and inserted on Cell [C6].

  6. Here we will link the new created barcode with data from cell [B6].
    • Click button Link to Cell
    • Click on the cell [B6] containing the EAN-13 barcode number. Then click button Update.
    • Now you can see that the EAN-13 barcode data is from [B6].


  7. Now we will resize the EAN-13 barcode image width and height
    • Select the created EAN 13 image, check option Auto resize
    • 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-draw the resized EAN-13 barcode image.


  8. 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.
    • 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


  9. 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 list of 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.
  1. Prepare a list of cell data in one Excel column
  2. Generate a sample EAN-13 barcode image for template with customized options applied.
  3. Create list of EAN 13 images based on the cell data list and contain customizd options from the sample EAN 13 template


  1. Open an existing Excel document with a list of sample EAN-13 data. Open OnBarcode Excel Barcode Generator Add-in on MS Excel

  2. Generate a sample EAN-13 barcode image as template. All list of barcodes will use the same options as the sample image.
    • Enable Auto resize
    • Set DPI to 1200
    • Set Image width to 3200. Set Image height to 1356.
    • Set Text margin to 96
    • In tab 1D Barcode
    • Set Font size to 16
    • Click button "Update" to re-draw the EAN-13 image for template

  3. Open Batch Barcode panel to generate list of EAN 13 barcodes.

  4. Select the list of sample EAN-13 barcode data cells. And now the button Generate Batch Barcodes is clickable.

  5. Click button Generate Batch Barcodes. Then select the template EAN 13 barcode image.

  6. Choose Cell C6 as the first Cell to generate EAN 13 barcode. Click

  7. Click button Generate Batch Barcodes. Now all list of EAN 13 barcodes are created on Excel sheet.

    All of EAN 13 barcodes are applied the same options as the template barcode, and each EAN-13 is using different EAN13 data.

    Now you can delete the template EAN 13 barcode from the Excel file.
Barcode Types Supported by Excel Barcode Generator
Top
OnBarcode is a market-leading provider of barcode imaging generator, reader controls and components for ASP.NET, Windows Forms, WPF, as well Java, Android, iOS (iPhone, iPad) across all major enterprise development platforms. We provides comprehensive tutorials and how-tos for various linear, 2d barcode information, such as C# in ASP.NET, C# .NET, C# Barcode Encoding, C# Barcode Image, VB.NET in ASP.NET, VB.NET Winforms, VB.NET Barcode Encoding. OnBarcode barcode products are supported by RasterEdge ASP.NET Document Viewer, which supports ASP.NET PDF Viewer, ASP.NET MVC Document Viewer, ASP.NET PDF Editor, MVC PDF Viewer. And provide high quality C# Convert PDF to Tiff, C# Convert PDF to Word, C# Convert PDF to HTML, C# Convert PDF to Jpeg images, and their easy and simple documents, like C# PDF SDK, C# extract text from PDF, C# Compress PDF, Print PDF in C# and C# extract image from PDF.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.