Need a QR code for every table, product, ticket, asset tag or name badge? Making them one at a time is slow. Here's how to turn a spreadsheet into a folder of QR code images in one go.
1. Prepare your spreadsheet
Put one code per row. Use a column named url (or data or text) for what goes in the code, and an optional filename column for each image's name:
filename,url table-01,https://example.com/menu?table=1 table-02,https://example.com/menu?table=2 asset-1043,ASSET-1043
In Excel or Google Sheets, choose File → Save as / Download → CSV. Commas, semicolons and tabs are all detected automatically, and quoted values with commas inside are fine.
2. Make the codes
- Open the WBS QR Code Generator and set your style first: colours, error correction, size and margin (and your logo, with Pro).
- In Batch QR codes from a CSV, choose your CSV file or paste the rows.
- Pick PNG, SVG or both, and click Make ZIP of QR codes.
- You get
qr-codes.zipwith one image per row, named from your filename column, plus anindex.csvlisting each file and its content.
Everything happens in your browser; the CSV is never uploaded. The free version makes up to 3 codes per batch so you can check the result. WBS QR Pro ($7 one-time, no subscription) makes up to 1,000 per batch. Every code is static, so none of them expire.
Make one now with the free WBS QR Code Generator: static codes that never expire, no sign-up, no watermark, and nothing is uploaded.
3. Put the codes on labels, badges or cards
- Word mail merge: keep the image file names in your data and use an INCLUDEPICTURE field, or place codes by hand for small runs.
- InDesign / Affinity data merge: add a column with each image's path (prefix the column name with @ in InDesign) and merge.
- Label printers and Canva: upload the folder of PNGs and drag them in.
Tips
- Keep the content short (a short link per item) so every code stays small and quick to scan.
- Use filenames that match your labels, like
table-01, so nothing gets mixed up. - Scan a few codes from the batch before printing them all.
Questions
Can I make bulk QR codes for free?
Yes, up to 3 per batch in the free version, and unlimited one-at-a-time codes. WBS QR Pro ($7 one-time) makes up to 1,000 per batch as a ZIP.
Is my spreadsheet uploaded?
No. The CSV is read and the codes are made in your browser. Nothing is sent to a server.
Do bulk QR codes expire?
No. They're static codes with your content inside, so they keep working as long as your links do.
More free tools from Wood Between Studio
- Free Invoice Generator: make invoices, quotes and receipts as PDFs in any currency, with tax and discounts. No sign-up, no watermark, and nothing is uploaded.
- WBS Tools: compress images, convert JPG to PDF, merge, split and rotate PDFs in your browser. Files are never uploaded.
- Brimreel Web: record your screen, a tab or your webcam in the browser. No time limit, no watermark, and the video is saved to your computer, not uploaded.
- Tablark reload & countdown timer: a free online countdown and repeating interval timer with a beep, plus a reload bookmarklet.