Bulk barcode generator from an Excel file
One barcode for every row of your spreadsheet, without formulas, fonts or add-ins. Download the images in a ZIP, named from your own column, and a PDF ready to print.
- 100% free
- No usage limits
- No sign-up
- Nothing uploaded: runs in your browser
No file at hand? .
Layout and text
Printer alignment
Print the PDF at 100% (“Actual size”), not “Fit to page”.
| Row | Problem | Content |
|---|
How to generate barcodes from Excel
- Add your file. Choose an Excel or CSV file, or paste a column of values.
- Pick the column and the type. Code 128 suits most internal codes. The hint under the type says what each one accepts.
- Choose what to get. Images in a ZIP, named from a column of your choice, and a PDF laid out on the label sheet you select.
- Generate and download. Invalid rows are listed with their row number and reason.
Why not do it inside Excel?
Excel has no barcode function. The usual workarounds are a barcode font, which needs extra start, stop and check characters built with formulas, or a paid add-in. Both break easily: one missing character and the code does not scan. Generating the bars outside Excel from the raw values avoids all of that, and your spreadsheet stays as it is.
What you get
- PNG imagesFor documents, websites and inserting back into Excel or Word.
- SVG imagesVector files that stay sharp at any size, for design and print software.
- A printable PDFAll the codes on label sheets, with optional text lines and copies per row.
- manifest.csvThe list of files with the value encoded in each one.
Barcode types at a glance
- Code 128Letters and digits in a compact form. The usual choice for stock, shipping and internal labels.
- Code 39Capital letters and digits. Longer than Code 128, used by older systems.
- EAN-13, EAN-8 and UPC-ARetail products. The check digit is added if you leave it out and verified if you include it.
- ITF-14Outer cartons of retail products.
Print a test page first
Set your printer dialog to 100% or “Actual size”. “Fit to page” shrinks the sheet by a few percent, and by the last row the print is off by several millimetres.
Print the first page on plain paper with “Print the outline of each label” turned on, and hold it against a label sheet in front of a window. If the whole grid is shifted, enter the difference in “Shift right” and “Shift down”; negative numbers move it left or up. Then turn the outlines off and print on the real sheet.
Private by design
Product lists and internal codes stay on your device. Your browser reads the file and creates the images and the PDF in a background worker.
Known limits
- Barcodes are validated (characters, length, check digit) and their bar width is checked against the label size, but they are not scanned back. Test one printed label with your scanner before printing the batch.
- EAN and UPC codes are drawn with even-height bars and the digits centred underneath, rather than the traditional layout with longer guard bars. Scanners read them the same way.
- Generating a barcode does not register its number with GS1.
- PNG images are 3 pixels per bar module. For large prints, use the SVG files or the PDF.
- The templates follow the measurements published for each sheet; they have not been checked against every physical product. Printers also shift by a millimetre or two, so print a test page first.
- Text lines use a standard Western European font. Other alphabets print as “?” in the text, although the QR codes themselves can contain any character.
- The whole PDF is built in memory. A million labels is the hard ceiling for one file, and very large batches depend on the memory of your device.
- Password-protected workbooks must be unlocked first.
Frequently asked questions
Is it really free?
Yes. It is 100% free, with no usage limits, no account, no sign-up, no watermark and no paid plan. There is no cap on rows or labels.
Is my spreadsheet uploaded?
No. Your spreadsheet is read inside your browser and the PDF is built on your own device; nothing leaves it. The page only downloads its own code from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never your files, their names or the contents of your labels.
How do I generate barcodes from an Excel list?
Choose the Excel file, pick the column with the values and the barcode type, and press “Generate barcodes”. You get a ZIP with one PNG and one SVG per row and a PDF with all of them laid out on label sheets.
Do I need a barcode font or an Excel add-in?
No. Barcode fonts need start, stop and check characters that Excel does not add by itself, which is why codes typed with a font often fail to scan. Here the bars are calculated from the value, including the check characters.
How many barcodes can I create at once?
There is no row cap. The practical limit is your device’s memory, because the ZIP and the PDF are built in memory, with a ceiling of one million labels per file.
How are the image files named?
By the value of the barcode, or by the column you choose. Repeated names get -2, -3 and so on, and the ZIP includes manifest.csv with the list of files.
What happens with invalid values?
They are not drawn. Rows with letters in an EAN code, a wrong number of digits or a wrong check digit are listed with their row number and the reason, so you can fix the spreadsheet.
Can I insert the barcodes back into Excel?
Yes: unzip the images and insert the PNG files into your sheet or into Word. For printing, the PDF is simpler, because the sizes are already correct.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives your files, your text or the contents of your codes. You can change your choice at any time with “Cookie settings” at the bottom of the page.