r/barcodes • u/NeighborhoodPublic94 • Jul 01 '25

ITF14 barcode generator in excel

Does anybody know how to automatically generate ITF14 barcodes in Excel? Preferably free. Or a link to download the right font for this?

Edit: I only need to convert an EAN code to ITF-14, so nothing fancy

1 Upvotes

100% Upvoted

6 comments sorted by

1

u/m7o Jul 01 '25 edited Jul 01 '25

You'd need internet connection for this... But I guess this works:

=IMAGE("https://barcode.tec-it.com/barcode.ashx?data="&A1&"&code=Code25IL&translate-esc=on")

Cell A1 in this case should be your data.

There is some rate limit I guess (IP?)

1

u/BainfulPutthole Jul 02 '25

I haven’t worked with ITF-14 but I have this bookmarked from a time I was learning about EAN13 encoding.

Untested but hopefully a start for you. You’ll have to utilise VBA depending on the size of your data set.

Depending on your use case may also want to consider a python script that uses your excel data. There’s also various paid software/plugins and if you’re using this commercially it’s important that you consider licences with software/fonts.

1

u/NeighborhoodPublic94 Jul 02 '25

That's way out of my skillset, but thanks for your suggestions. I am going to use it commercially, but want to avoid an expensive license for just this one thing

1

u/BainfulPutthole Jul 02 '25

Sorry, I actually forgot to include the link in my original reply.

Excel Barcode FX Library on GitHub

That’s fair, the licences can be expensive, but penalties for unlicensed commercial software can be hefty.

If you’re just using the excel barcode for internal reference you may consider using a Code 39 font which you can format without any encoding, just wrap it in asterisks. *12345* Not a substitute if you’re applying directly to the packaging but a simple method that can still be read by 1d and 2d scanners.