Our Customers
|
EAN 8 Barcode Generator Plug-in for Excel 2019 and 2016
How to Convert Data in Excel to 1D EAN-8 Barcode Labels
- Good Excel EAN-8 barcode generator add-in which can be used in inventory control
- Generate high-quality EAN-8 barcode in Excel, without adding any barcode fonts
- Easily and quickly convert your data in Excel spreadsheet to EAN-8 barcode
- Able to link cells with corresponding EAN-8 barcodes in Microsoft Excel
- Customize EAN-8 barcode image size by inputting corresponding numeric values
- Generate & rotate EAN-8 barcode in Excel with four available orientations
This guide will walk you through the process of generating EAN-8 barcodes directly inside your Excel spreadsheets. Whether you need barcodes for small retail products, books, or shelf labels, the BarcodeLib Barcode Generator Add-in makes the task straightforward.
Think of this add-in as a specialized "barcode printer" that lives inside Excel. Instead of printing on paper, it prints accurate, retail-standard barcode images directly into your worksheet cells. You provide the numbers, and the add-in handles the technical details. Including calculating the check digit automatically.
Quick Start: Creating Your First EAN-8 Barcode
Creating an EAN-8 barcode in a selected Excel cell is an easy task. Let's walk through it step by step.
Before we begin, it helps to know what EAN-8 expects. An EAN-8 barcode always contains 8 digits in total.
- The first 7 digits are your business data (the product information).
- The 8th digit is a check digit. A mathematically calculated number that verifies the barcode was scanned correctly. Think of it as a built-in error checker.
- The add-in can accept either 7 digits (and calculate the 8th for you) or the full 8 digits (if you already have the complete number).
1. Set Up Your Data and Add-in
- Open Your Excel Workbook: Launch Microsoft Excel and open the document where you want to create your barcode.
- Enter Your Data: Locate cell B3 in your worksheet. Type the following number into cell B3: 1234567. (This is a 7-digit example. The add-in will calculate the 8th check digit for you.)
- Open the Barcode Add-in: Look at the ribbon menu at the top of your Excel window. Click on the tab labeled "Add-ins" . In the BarcodeLib group, click the button that says "Create Barcode" . The "Barcode Settings" pane will appear on the right side of your window.
2. Generate the Barcode
- Select the Target Cell: Click on cell B3 to select it. This is where your EAN-8 barcode image will appear. (Notice that cell B3 already contains the number 1234567.)
- Choose the Barcode Type: In the "Barcode Settings" pane, find the dropdown menu labeled "Barcode Type" . Click it and select "EAN 8" from the list.
- Link to Your Data: In the "Data" text box, you have two options. For this example, type the formula: =LINK(B3)
This formula tells the barcode in B3: "Take whatever number is in this same cell and encode that." This creates a live link between the barcode and the cell.
- Generate the Barcode: At the bottom of the "Barcode Settings" pane, click the Generate button.
3. Check Your Result
- Look at cell B3. You should now see an EAN-8 barcode image appear directly in that cell.
- Notice that the cell's width and height have been automatically adjusted to fit the barcode image perfectly. The add-in does this for you.
- Look at the human-readable text printed below the barcode. You will see 8 digits. The first 7 should match your number 1234567, and the 8th is the automatically calculated check digit.
Note: If you do not see a barcode, double-check that you selected cell B3 before clicking "Generate." Also, ensure that cell B3 contains only digits (0-9) and is either 7 or 8 digits long.
Understanding EAN-8 Barcode Data in Excel
To use EAN-8 effectively, it helps to understand the data requirements and options available.
EAN-8 Data Character Set
EAN-8 barcodes are designed for retail and can only encode one type of information: numeric data.
- They only support the digits 0 through 9.
- No letters (like A, B, C) are allowed.
- No special characters (like -, /, $) are allowed.
- If you need to encode letters, you would need a different barcode type, such as Code 128 or Code 39.
How Many Digits Does EAN-8 Contain?
- A standard EAN-8 barcode contains 8 digits in total.
- The first 7 digits are your GS1 business message (the product information).
- The 8th digit is a checksum digit (check digit), automatically calculated from the first 7.
EAN-8 with Add-On Symbols
Like its cousin EAN-13, EAN-8 barcodes can optionally include add-on symbols. These are smaller, secondary barcodes attached to the main barcode.
- Two-digit add-on: Contains 2 digits. Often used for magazines to indicate the issue number.
- Five-digit add-on: Contains 5 digits. Often used for books to indicate the recommended retail price or a supplementary code.
How to Create an EAN-8 Barcode List in Excel
The add-in can insert not only a single EAN-8 picture but also supports generating barcode lists or tables in one operation.
Using Duplicate All
- Create a single, correctly formatted EAN-8 barcode in the first cell of your target range (e.g., C4). Make sure it links to the first data cell (e.g., B4) using the =LINK(B4) formula.
- Click on this template barcode to select it.
- Now, click and drag to select the range of empty cells below it where you want new barcodes (e.g., C5 through C10).
- In the "Barcode Settings" pane, click the "Duplicate All" button. This will fill the selected range with barcodes, each automatically linked to the corresponding data cell in column B.
EAN-8 Barcode Property Settings
- Set the Barcode Type property to EAN 8 or EAN 8 +2 or EAN 8 +5.
- Set the Data property with the value to encode. Type is string.
User should only provide 7 digits, and DO NOT include last digit checksum character.
- Valid Data Scope:
- 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
- Valid Data Format:
7 digits. There are totally 8 digits in EAN-8 barcode, first 7 digits are barcode value, and last digit is the checksum digit, which is generated by barcode library automatically.
- Sample: Data = "1234567"
- Set the Supplement data property with the supplement value to encode. Type is string.
Provide 2 digits for barcode type EAN 8 +2, and provide 5 digits for type EAN 8 +5.
Sample for BarcodeType.EAN8_2: barcode.SData = "12".
Sample for BarcodeType.EAN8_5: barcode.SData = "12345".
- Add checksum char property is not applied here. Barcode Library will always add a check character in the last digit (modulo 10).
- Barcode Size Settings.
- Set property Unit of Measure (Unit of Measure) for properties Bar Width, Bar Height, Margins.
Valid values are Pixel, CM, Inch.
- Set the Image Width and Image Height properties.
Both types are float.
- Set the Bar width (X) (for bar cell width) and Bar height (Y) (for bar cell height) properties.
Both types are float.
- Set the Left Margin, Right Margin, Top Margin and Bottom Margin properties.
Types are all float.
- If the Auto Resize property is chacked, the generated barcode image width and height will be the same as property "Image width", and "Image hight", and it will generate the maximum Bar Width and Bar Hight.
- Set the DPI property (Value is expressed in DPI - Dots per inch).
Type is int.
- Setting up Barcode data text style in barcode image (Tab: 1D Barcode).
- Set the Display barcode data properties. If Display barcode data is checked, barcode data will be displayed with the barcode.
- Set the Font property. The font used to display text in barcode image.
- Set Rotate property.
If you want to rotate barcode image, valid values are : 0, 90, 180, 270
|
