7

Creating high quality EAN-13 barcodes for free with Microsoft Excel, Word

Posted by Happy Hippo on 9/12/2009 01:48:00 pm
Update: a very good free website that generates high quality barcodes for you: http://www.terryburton.co.uk/barcodewriter/generator/
Update: if you require some sort of Windows automatization (e.g. in Excel), check out Auto It programming language for writing scripts : http://www.autoitscript.com/site/autoit/

The EAN-13 barcodes are used worldwide for marking products often sold at retail point of sale (for example books, etc). I recently found this free EAN-13 barcode making way (requires Microsoft Excel or similar), which I want to show below. First you need to download this archive that contains two files: EAN13.xls and ean13.ttf.

After you have downloaded and unzipped these files, right click on the ean13.ttf and click Install.


Then open EAN13.xls file in Microsoft Excel, and click Enable Macros (it will not work if macros are disabled!).

 
Now you can create your own barcodes, just by replacing the numbers with yours. Remember, you only need to enter first 11 digits of your code, the last one is a check digit and is calculated automatically. 
If you want to paste this code directly into a word processing program, just right click the cell with the barcode, and copy it, open your word processor and paste it there. 



Or alternatively, zoom in on the cell with barcode in excel, and press Print Screen button on your keyboard. And then crop the screenshot in any image editor. This will give you a high-resolution picture of you barcode.
Marco Manzini Landscape and Nature Photography
Alternatively you can use this program to generate the barcode for you.

7 Comments


Looking for help.
I installed ver 2.1.7 on my Windows 7 64 bit laptop. Import of profiles works fine. Those VPN connections I had that prompted me for user and password works fine. The ones that did not, do not. It prompts me for credentials which I never had in first place for these connections (I'm not talking about the required group authentication.
How do it get this new client to process the profile connection as before, not require credentials.
Thanks, Bill


Thanks Sir,

Lill Problem, your link at the end to generate barcode "http://www.fileden.com/files/2009/8/22/2551358/134984-ean13gen.rar" is not working :|


It is working, but I re-uploaded the file here just in case:

http://www.mediafire.com/?ytgbgb8dczfd9gx


meeboguest600574: What is happening is when i open the excel file if lookg great. i change up to 7 digets from the end and all ok when i go to the 8th if blanks the barcode. Any Ideas?

EAN-13 barcode is designed such that the last digit is a check digit, it is calculated from combination of previous digits, so there is no need to enter it. The code calculates it automatically.

Hope that helps.


I have searched for long time...
Finally, I found.
It works very well.
Thank you very much.


Nice solution for excel. I've found a Javascript Barcode Generator on the net that can be integrated into web pages.

© All content on this site is copyright, except where other sources are specified. Please contact me before using any resources on this blog in any way ©