A bulk QR code generator turns a spreadsheet into many QR codes in one go. Put a name column and a link or text column in Excel or CSV, upload the file, choose one style for all codes, and download a ZIP of PNG images. It saves hours compared with making each code by hand.
Making one QR code takes seconds. Making two hundred, one for every staff member, product or table, is a different job. Copying links into a generator one at a time is slow and invites mistakes. Working from a spreadsheet is faster, and the file becomes a record of what each code contains.
When you need many QR codes at once
Bulk generation makes sense whenever each item needs its own code. Common examples include:
- Staff badges. Each code links to a staff profile, a contact card or an internal page.
- Product labels. Each product or batch gets a code that opens its own information page, manual or reorder link.
- Asset tags. Laptops, tools, furniture and equipment carry a code with an asset number or a link to their record.
- Table numbers. Restaurants and event venues give each table a code that identifies it, for example in an ordering link.
- Event tickets and passes. Each guest receives a code containing a unique reference that staff can scan at the door.
- Classrooms and training. Each student or group gets a code for its own worksheet or folder.
If every code would contain the same thing, you do not need bulk generation. Make one code and print it as many times as you like.
Preparing your Excel or CSV file
A tidy sheet is the key to a smooth bulk run. Keep it simple:
- Use two main columns. One column for the name of each code, and one for the content: the link or text that the code should contain.
- Put headers in the first row. Clear headers such as "name" and "link" make it obvious which column is which.
- One code per row. Do not merge cells or leave blank rows in the middle of the list.
- Write full links. Include the beginning, such as https://, so phones open the link correctly.
- Keep names unique. The name is often used for the file name, so two rows called "Table 1" can be confusing or overwrite each other.
- Save in the right format. Many tools accept CSV, and Excel can save a sheet as CSV through "Save As". If your text includes Thai or other non-Latin characters, choose a UTF-8 CSV option so the characters are preserved.
Before you upload, read down the content column once. A typing mistake in one link becomes a printed code that leads nowhere.
Creating the codes with QR-TH
The QR-TH bulk QR code generator works from exactly this kind of sheet. The process is:
- Open the bulk page and upload your Excel or CSV file.
- Check that the tool has picked up the right name and content columns.
- Choose the style once: colours, shape and other design options apply to every code in the batch.
- Generate the codes and download a ZIP file containing one PNG image per row.
Because the style is set once, every badge, label or table card looks consistent. When designing, keep strong contrast between the dark modules and the light background, and leave a clear margin around each code so cameras can find it.
Static or dynamic when making many codes
When you create a batch, decide whether each code should be static or dynamic. Our guide to static vs dynamic QR codes explains the difference in full, but in short:
- A static code stores the link or text directly. It works without any account and never expires, but the content cannot change after printing.
- A dynamic code stores a short link that forwards to your destination. You can change the destination later and see scan statistics.
For bulk jobs, static codes suit content that will not change, such as asset numbers, table numbers or serial references. Dynamic codes are worth considering when the printed items will be around for a long time and the pages behind them may move, for example product labels that link to manuals or a website you plan to redesign. With hundreds of printed labels, being able to update a link instead of reprinting is a real advantage.
A simple compromise is to point static codes at pages on your own domain that you control, so you can update the page itself without changing the code.
Tips for file names, printing and testing
A few habits make the difference between a batch that just works and one that needs redoing:
- Use meaningful file names. Names such as badge-somchai or asset-0042 make it easy to match each image to the right item when you lay out labels.
- Choose a sensible print size. A code on a small product label is scanned from close up, while a code on a poster or table stand may be scanned from further away. Our QR code size guide explains how to pick a size for the scanning distance.
- Keep long content short. Very long links create dense codes that are harder to scan when printed small. A short link or a dynamic code keeps the pattern simpler.
- Test before you print the whole batch. Print a handful of codes at the final size, scan them with different phones, and check that each opens the right destination.
- Spot-check after printing. Scan a sample from the start, middle and end of the print run to catch alignment or printer problems.
- Keep the spreadsheet. It is your index of what every code contains, which is invaluable when someone asks what a particular label does.
FAQ
What columns do I need for bulk QR codes?
Usually two: a name column, often used for file names, and a content column with the link or text each code should contain. Put clear headers in the first row and one code per row.
Can I make bulk QR codes from Excel without converting to CSV?
Many tools accept Excel files directly, and you can always save a sheet as CSV from Excel. If your data contains Thai characters, choose a UTF-8 CSV option.
What file format do bulk QR codes download in?
The QR-TH bulk tool downloads a ZIP file containing one PNG image for each row, ready to place on labels, badges or cards.
Should bulk QR codes be static or dynamic?
Static codes suit fixed data such as asset or table numbers. Dynamic codes are better when destinations may change after printing or when you want scan statistics.
When you next face a long list of items that each need a code, start with a clean spreadsheet and try the free bulk QR code generator to turn it into a ready-to-print set in minutes.