QR Tools

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.

No file at hand? .

How to generate barcodes from Excel

  1. Add your file. Choose an Excel or CSV file, or paste a column of values.
  2. Pick the column and the type. Code 128 suits most internal codes. The hint under the type says what each one accepts.
  3. 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.
  4. 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

Barcode types at a glance

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

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.