Quick to Create ITF-14 in Excel
Top
Here we will show you how to quickly create a ITF-14 barcode in Excel document using Excel ITF-14 Barcode Generator Add-in.
Before we start to create and print ITF-14 barcodes in Excel cells, you need open an Excel file and Excel Barcode add-in from Excel software toolbar "Add-in".
Before we start to create and print ITF-14 barcodes in Excel cells, you need open an Excel file and Excel Barcode add-in from Excel software toolbar "Add-in".
- Select cell
B2from Excel spreadsheet. The cell contains 13 digits. ITF-14 code is a fixed 14 digits, you can provide 13 data digits or 14 digits with last one check sum digit. - Choose
ITF-14in "Barcode Type" list from "Barcode Settings" pane -
Click Generate button to print ITF-14 barcode on selected cell.
-
You have created the first ITF-14 barcode image on Excel successfully.
Start to Install Excel Barcode Add-in
Now you know how easy and quick to create an ITF-14 barcode on Excel document using Excel Barcode Add-in.
Start with downloading and installing free add-in:
Introduction of ITF-14 Excel Barcode Generator
Top
As one of our professional barcode generation products, ITF-14 Excel Barcode Add-in makes users to easily and quickly create linear ITF-14 barcode and barcode lists or tables on Microsoft Office Excel 2016/2013/2010/2007.
 |
Apart from Excel Barcode Add In (not font), OnBarcode.com also provides barcode generator add-ins support creating other linear and 2D barcodes for Excel, including Codabar, One Code, GS1 128, Code 128, EAN, UPC, Interleaved 2 of 5, POSTNET, QR Code, Data Matrix, PDF-417, etc. |
Features of ITF-14 Barcode Add-In for Excel
Top- ITF-14 Barcode Add-in for Excel is available for Microsoft Office 365, 2019, 2016, 2013, 2010 and 2007.
- Directly create ITF-14 barcodes in MS Excel using barcode generator for excel within a few seconds.
- Both single ITF-14 barcode image and barcode lists are supported by this barcode generator.
- May covert all cells of the excel document into ITF-14 barcodes with a few clicks.
- Industry standards of ITF-14 are well configured in all barcodes with Excel Barcode Plugin.
- Barcode parameters, including barcode size, rotation, etc, are all adjustable.
- Check Digit Calculation is supported by ITF-14 Excel Barcode Add-In.
- No programming skills are necessary when inserting ITF-14 with Excel Barcode Add-In.
- Even low-resolution printers can be used to print high quality ITF-14 barcodes.
Install ITF-14 Excel Barcode Add-In
Top- Download the Excel ITF-14 Barcode Add-in and unzip it.
- Close all the excel documents on your computer.
- Run the setup file to install the barcode plug-in.
- Start an Excel document and click "Install" in the pop-up pane.
- An "Add-Ins" button will be added on the menu bar when all finished.
Customize ITF-14 Bearer Bars in Excel
Top
ITF-14 barcodes may include bearer bars, which are surrounding horizontal and vertical bars.
The bearer bar is mandatory unless it is not technically feasible to apply it (in which case reading reliability will be reduced).
For ITF-14 barcode printed on a label, sometimes only horizontal bearer bars along the top and bottom will be printed.
Using OnBarcode Excel ITF-14 Barcode Generator add-in, it will automatically print all four bearer bars on ITF-14 in Excel file. You can choose the bearer bar width for your barcodes in Excel.
Here we will follow the previous demo, which has generated one ITF-14 barcode in Excel document.
The bearer bar is mandatory unless it is not technically feasible to apply it (in which case reading reliability will be reduced).
For ITF-14 barcode printed on a label, sometimes only horizontal bearer bars along the top and bottom will be printed.
Using OnBarcode Excel ITF-14 Barcode Generator add-in, it will automatically print all four bearer bars on ITF-14 in Excel file. You can choose the bearer bar width for your barcodes in Excel.
Here we will follow the previous demo, which has generated one ITF-14 barcode in Excel document.
- Select the printed ITF-14 barcode on cell
B2 - Find the "Bar Style" group in tab "Barcode Size", change Bearer bar (Horizontal) and Bearer bar (Vertical) values to 2.
- Click "Update" button on top of the "Barcode Settings" pane
-
The selected ITF-14 barcode image has been re-printed in Excel with new bearer bar sizes
Insert ITF-14 Barcode into Excel Document
TopHow to Create an ITF-14 Barcode for Excel
After clicking "Add-Ins", the Barcode Generator will be activated, and then switch to "Create Barcode", and a "Barcode Settings" panel will appear on the right side. Then click the cell where you want to insert an ITF-14 barcode, and select "ITF-14" in the "Barcode Type" pull-down menu. When inputting required ITF-14 data, click the "Generate" button, and an ITF-14 barcode will be generated.
How to Customize ITF-14 on Barcode Settings Panel
Click the ITF-14 you want to customize, and switch to the "Barcode Size" and "1D Barcode" tab in the "Barcode Settings" panel on the right side. Then revise the parameters which you want to reset, like bar width & height, bearer bar size, etc, and click the "Update" button when you finish, and you'll get a new ITF-14 barcode. Note that the wide to narrow bar ratio of ITF-14 is 2:0 to 3:0.
How to Generate ITF-14 Barcode List in Excel
The Excel Barcode Add-In also allows generating barcode lists and tables apart from a single ITF-14 image at a time. Choose a column or a row of cells with data, and select "ITF-14". Then click "Generate" to finish the creation of a barcode list or table.
How to Link ITF-14 Barcode to Cell for Excel
Choose a created ITF-14 barcode and click the "Link To Cell" button, then choose a cell with data, and click "Update" button (otherwise click "Cancel" button). When finished, the barcode is linked to the data of the cell, and would change if the data changed. Our product also supports linking multiple barcodes to cells.
More tutorials and detailed are included in
How to create, print barcode images in Excel?.
Common Asked Questions
What is an ITF-14 code?
An ITF-14 code is a 14-digit, 1d barcode supported by GS1 System, used to encode the GTIN-14 code on cases, pallets, and other bulk packaging units throughout the supply chain.
ITF-14 is also known as GTIN-14, and is part of the GS1 standard and is designed for logistics and warehousing.
Using Excel Barcode Generator add-in, you will be able to encode 14 digits GTIN code in ITF-14 barcode images in Excel 365/2021/2019/2016 application.
Using Excel Barcode Generator add-in, you will be able to encode 14 digits GTIN code in ITF-14 barcode images in Excel 365/2021/2019/2016 application.
What is GTIN 14 code used for?
A GTIN-14 is always 14 digits in length. A GTIN-14 code is used to identify shipping units and packaging levels in the supply chain.
OnBarcode Excel Barcode add-in supports ITF-14 barcode generation with GTIN-14 code encoded in Excel documents.
OnBarcode Excel Barcode add-in supports ITF-14 barcode generation with GTIN-14 code encoded in Excel documents.
How to convert EAN-13 to ITF-14?
If you want to convert an EAN-13 code to ITF-14, you can add an ITF-14 indicator digit (0-8),
and the Excel Barcode add-in will re-calculate the checksum digit for the new ITF-14 barcodes in Excel file.
What size is the ITF-14 barcode?
ITF-14 barcode minimum X-dimension is 0.495mm. ITF-14 barcode minimum height is 31.75mm.
In Excel, you can provide GTIN-14 codes and the barcode software will print the ITF-14 barcode with right dimension size in Excel cells.
What is the difference between Interleaved 2 of 5 and ITF-14?
Interleaved 2 of 5 (ITF 2of5) is a continuous two-width, encoding numeric-digits only barcode symbology
ITF-14 barcode is an application of Interleaved 2 of 5, required by GS1 System, to encode GTIN-14 code.
The ITF-14 barcode contains a thick black border around the symbol called the Bearer Bar, and Interleaved 2 of 5 does not have any Bearer Bar.
Using Excel Barcode freeware without font, you can create and print both Interleaved 2 of 5 and ITF-14 with Bearer Bar in Excel cells.
Using Excel Barcode freeware without font, you can create and print both Interleaved 2 of 5 and ITF-14 with Bearer Bar in Excel cells.
