Bulk QR Code and Barcode Generator

How it works

Turn a whole list into QR codes or barcodes in one go. Paste cells from Excel, Google Sheets or a CSV file, enter one item per line, or number a sequence, then download every code as a PNG or SVG file in a single ZIP. This free bulk barcode generator also handles Code 128, EAN-13, EAN-8, Code 39 and ITF-14, adds check digits for you and flags problem rows before you print. Your list is processed in your browser and never uploaded. You can also print QR code labels and barcode labels straight onto US Letter sheets in common Avery sizes, starting from any label on the sheet.

Three ways to add your list

• Paste from Excel or CSV: select the cells in Excel or Google Sheets, header row included if you like, then copy and paste. The tool works out whether the first row is a header; you pick the column that goes into each code and the one that names the files. A CSV file works the same way once you open it in a spreadsheet.
• One per line: one link or ID per line, with blank lines skipped. Handy when you already have a list of URLs.
• Number sequence: set a prefix, start, count or end number, step, zero padding and suffix, such as BIN-0001 to BIN-0500. The first three and the last value appear as you type, with no need to fill a spreadsheet first.

Popular uses

Inventory and storage bins

Number your bins and shelves with a sequence (for example BIN-001 to BIN-200) and choose Code 128 for a handheld scanner, or QR code if people will scan with a phone. Add a second line of text such as the aisle or the contents so the label reads at a glance.

Asset tags for equipment

Copy the asset tag column from your equipment list, header included, and choose it as the code column. For a scanner that types the ID into your system, choose Code 128. To open each item's record with a phone camera instead, choose QR code and use a template such as https://your-site.example/asset/{id}.

Moving boxes

Number the boxes and print QR code labels with the room and a short list of contents on each one. Link each code to a shared sheet or form with the full packing list, and anyone unpacking can see what is inside without opening the box.

Product barcodes and in-store codes

For codes used only inside your own business, you can use EAN-13 numbers starting with 20 to 29. GS1 sets these aside as restricted circulation numbers: they are never issued as product GTINs, and the GS1 office in each country decides how they may be used. Choose a sequence with prefix 20 and zero padding 10, and every check digit is calculated for you. To sell through retailers, you need official numbers from GS1 US or the GS1 office in your country; this tool draws the barcodes for numbers you already have.

Google Forms with each code's ID filled in

1. In Google Forms, choose "Get pre-filled link", type a sample answer such as TEST in the ID question, and copy the link.
2. Paste the link into the template and replace TEST at the end with {id}, for example …&entry.123456789={id}.
3. Paste your list of IDs or set up a sequence. Each QR code opens the form with its own ID already filled in.

When the template is a link, each value is encoded for URLs, so spaces and symbols such as & will not break it.

Print QR code labels and barcode labels on Letter sheets

Choose "Print labels" as the output and your list is laid out on label sheets, ready to print from your browser, with no mail merge in Word. Each label gets a code plus one to three lines of text, such as an asset tag, an item name and a location; text shrinks to fit and is cut off only when it is too long, with the affected rows listed.

• Avery-compatible sizes: US Letter sheets laid out like Avery 5160 (30 per sheet, 2⅝ × 1 inch), 5163 (10 per sheet, 4 × 2 inch), 5167 (80 per sheet, 1¾ × ½ inch) and 22806 (12 square labels, 2 × 2 inch), plus an A4 sheet of 21 labels and a custom size for anything else.
• Start at any label: on a partly used sheet, enter the first unused label and the ones before it stay blank.
• Several copies of each: print two of the same label in a row, for example one for the item and one for its box.
• Safe edges: most printers cannot print the outer 0.12 to 0.2 inch of the page, so codes and text in labels that touch the edge are pulled in automatically.
• No labels that will not scan: if a barcode would be squeezed too thin for its label, for example a Code 128 bar narrower than 0.19 mm, the tool explains why and turns off printing instead of wasting a sheet.

Avery is a trademark of Avery Products Corporation. This site is not affiliated with Avery; the product numbers only describe sheets with the same layout.

Line it up before you print

1. Under "What to print", choose "Alignment test page" and print it on plain paper. It shows only the label outlines, their numbers and a 2-inch ruler.
2. Measure the ruler. If it is not exactly 2 inches, your print settings are scaling the page: set the scale to "Actual size" or 100% and the margins to "None", and avoid "Fit to page".
3. Hold the test page over a label sheet against the light. The lines should sit on the label edges. If everything is off in one direction, enter the difference under "Offset adjustment" and print the test page again. Tick "Remember this printer's offset" to keep it.
4. Once it lines up, load the label sheet, switch back to "Labels" and click Print labels.

Barcode or QR code?

Use a barcode when a scanner reads an ID into your inventory, asset or checkout system: Code 128 is the most versatile, and EAN-13 is for retail products. Use a QR code when people should open a web page, form or manual with their phone camera. You can make both from the same list: make the QR codes once, then switch to Code 128 and make them again.

For a single code, use the barcode generator or the free QR code generator, which also lets you pick colors and add a logo.

Printed codes never expire, so pick links you can keep

These are static QR codes: the link is stored in the code itself, with no redirect service in between, so a printed label never stops working because some service shut down. The link inside still has to keep working, though. Use addresses you control for the long run, avoid link shorteners and pages you might move later, because changing the link means reprinting every label.

How to make QR codes in bulk

1. 1Choose how to add your list: paste from Excel or CSV, enter one item per line, or set up a number sequence.
2. 2To turn IDs into links, add a template such as https://example.com/asset/{id}.
3. 3Pick QR code or a barcode type, and check the results for any red rows.
4. 4Choose PNG or SVG and click Download ZIP, or choose Print labels, pick your sheet and click Print labels.

FAQ