Create QR Codes in Bulk From a Spreadsheet

Template columns explained

The QR template uses four columns. The payload is the part that matters most; the others help you organize files and keep a record of what each code is for.

Use unique labels, because they name the files inside the ZIP. A label like table-12 or sku-48213 makes it easy to match each image to its place on a floor plan or product list. Keep payloads clean: trim stray spaces, include https:// on links, and check for duplicates before uploading.

Who uses bulk QR codes

Making codes one at a time works for a handful. Once you need dozens, a spreadsheet keeps the data in one place, avoids copy-and-paste mistakes and leaves you with a record of exactly what each code contains.

• Restaurants: one code per table, linking to the menu or an ordering page with the table number
• Event organizers: individual codes for tickets, badges, sessions or check-in points
• Retail and warehouses: shelf labels and product tags pointing to spec sheets
• Schools and libraries: codes for classrooms, equipment and collections
• Marketers: separate codes per flyer batch or location, each with its own tracking parameters

Getting a clean print run

For professional print, choose SVG so each code scales without blur, or PNG at 1024 px for documents and label software. The printable PDF sheet lays the codes out for a desktop printer, which is handy for stickers and table cards. Turn on text labels if staff need to tell codes apart at a glance.

Before printing hundreds, scan a few codes from the preview, including the first and last rows, to catch errors in the source data. Keep colors dark on light and save the results spreadsheet with your project files. Because processing happens in your browser, very large batches depend on your device, so split huge lists into a few files if things slow down.