How to Create QR Codes in Bulk — Spreadsheet to Zip in One Minute
Need a QR code for every product, table, or poster? Here's how to create QR codes in bulk: paste a spreadsheet of URLs into Linkly, then export every QR code as PNG or SVG in a single zip. Every code is a dynamic QR code: change where it points after printing, and see every scan.
Transcript
The full spoken transcript, split by chapter.
- 0:00Two hundred QR codes, one spreadsheet
- Say you need a QR code on every product. Or on every table, and every poster. Two hundred of them. Making those one at a time in a QR generator? That's an afternoon gone. In Linkly, you paste a spreadsheet and you're done. Let me show you.
- 0:14Bulk import: paste URLs, nicknames, your domain
- Okay, so this is Linkly. I've got a plant shop that wants a care-card QR code for every plant it sells. Twelve destination URLs, a nickname for each, and the shop's own domain. Straight from a spreadsheet. Bulk Import opens a grid. Paste, and it's already worked out where everything goes. Hit import… and every row turns green with its own short link.
- 0:36Export every QR code as one zip (PNG or SVG)
- Now the bit that saves the afternoon. Search for the batch, tick the box at the top to select all of them. Twelve selected. Then Bulk, Export QR Codes, PNG. Linkly renders all twelve right there in the browser and hands you one zip. That took about a second.
- 0:52What's inside the zip
- Inside: one file per link, named after the nickname you gave it. So whoever's laying out the cards knows exactly which code goes where. SVG is there too, if your printer wants vectors.
- 1:02The .qr.png trick: QR codes from a spreadsheet formula
- And here's the trick I actually like. Every Linkly short link has a QR image at the same address, with .qr.png on the end. So in a spreadsheet, one formula fills a whole column with QR codes. Mail merges and label printers work the same way.
- 1:18Why dynamic QR codes beat a plain generator
- One last thing. And it's the reason I'd do this in Linkly rather than a plain QR generator. Every one of these codes is dynamic. The code points at the short link, not at the page. So when a product page moves, or you spot a typo after two hundred labels are already printed, you change the destination in Linkly and every printed code just follows. No reprint. You also see every scan. Which code, and where it was scanned. Linkly is free to start, and everything you need is just below this video.
