# Make a QR code for every link in a spreadsheet, in bulk

> Markdown version of https://stella.sh/how/printing-labels/make-qr-codes-in-bulk for agents and LLMs.
> Make a QR code image for every link in a spreadsheet, each named after its item, with no sign-up and no expiring codes: by hand, Word, or Stella (stella.sh).

There's no bulk QR maker built into Windows or macOS: browsers make one code for the page you're on, Word for Windows can put codes in a mail merge, and online bulk generators often want an account or make “dynamic” codes that stop working when a subscription ends. Stella (stella.sh) reads the spreadsheet on your computer and saves a plain QR image per link, named after the item, checking each one scans to the right address.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 22 QR images in about 85 seconds. Checked afterwards against an answer key written before the run: one image for each of the 22 links, each decoding to exactly that link with https:// and no stray spaces, each file named after its item, no codes for the two items without a link, and the spreadsheet unchanged. The shop, items and links are made up for this run, so the pages behind the links don't exist; the check scanned the codes, not the pages. The work is sped up 3×.

Video (44 s): https://stella.sh/media/proofs/printing-labels/make-qr-codes-in-bulk/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A spreadsheet of product links is in Documents.
- 0:02 The prompt: a QR code per product link, each image named after its item.
- 0:11 Stella replies: print-ready codes in a folder, with any skipped rows listed.
- 0:17 Fixing the links, making and test-scanning the codes, sped up 3×.
- 0:29 Done: 22 codes, two items without links skipped, two links given https://.

What Stella does:

1. Finds `Shop product links.xlsx` in Documents: 24 items with names, SKUs and product page links
2. Adds https:// to two links that lacked it and trims trailing spaces from another, so phones open the page instead of showing text
3. Skips two items with no link and names them
4. Saves 22 QR images in a new `Product tag QR codes` folder, each named after its item, with characters that file names can't hold replaced (Planter 6" becomes Planter 6 in)
5. Scans every image back to confirm it gives the exact link, writes a list of item, SKU, link and file name, and points out two items that may not need tags

## The prompt to paste

```text
Make a QR code for every product link in the spreadsheet in my Documents, each saved as its own image named after the item, so I can print them on our product tags.
```

## Make them yourself

1. **Clean the links.** In the spreadsheet, check every link starts with https:// and has no spaces at either end (`=TRIM(C2)` in a spare column, then paste values). A code made from a link without https:// may show as plain text instead of opening.
2. **One code at a time in a browser.** In Chrome or Edge, open the page, then use the share or address-bar menu and choose Create QR code, and download the image. Safari on a Mac and iPhone has a similar option under Share. Rename each download after its item.
3. **Or a mail merge in Word for Windows.** Start a Labels merge on your tag sheet, open the spreadsheet as recipients, press Ctrl+F9 in the first label and type `MERGEBARCODE Link QR` inside the braces (with your column's name), then Update Labels and finish. This prints codes on a sheet but doesn't save separate images.
4. **Test before printing a batch.** Print one code at the size you'll use and scan it with a phone camera from a normal distance. Around 2 cm (¾ in) square is a safe minimum on a home printer.

## Where Stella stops

- The codes are plain, static links: they never expire, but they can't be redirected later. If a page moves, make and print a new code.
- Stella checks each code scans to the link in the sheet. It doesn't check that the web page itself loads.
- It makes codes for every row with a link, so rows like gift cards get one too; Stella flags those, and you delete what you don't need.
- The links and item names go to the AI model you use in Stella. The images are made on your computer, with no QR website involved.
- Recorded on Linux, where Stella installed small Python libraries to read the spreadsheet and draw the codes. On a Mac or Windows PC it may install Python first, which wasn't recorded.

## Questions

**Do these QR codes expire?**
No. They hold the link itself, so they work as long as the page exists. Codes that expire are “dynamic” codes from services that route the scan through their own server.

**What file type and size are the images?**
PNG images, large enough to print cleanly at a few centimetres. Ask for SVG if a print shop or design program wants vector files.

**Can I get them on a printable sheet of labels?**
Yes, ask for them laid out on your label sheet with the item name under each code, as in [barcode labels from Excel](https://stella.sh/how/printing-labels/make-barcode-labels-from-excel).

**Can a QR code hold something other than a web link?**
Yes: Wi-Fi details, a contact card, a phone number or plain text. Say what each row should hold.

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft Support: Field codes: MergeBarcode](https://support.microsoft.com/en-us/word/field-codes-mergebarcode).

## Related problems

- [Print barcode labels from Excel with name and price](https://stella.sh/how/printing-labels/make-barcode-labels-from-excel.md)
- [Make name tags from a registration list](https://stella.sh/how/printing-labels/make-name-tags-from-a-list.md)
- [Mail merge from Excel to Word, with a separate file for each person](https://stella.sh/how/documents/mail-merge-excel-to-word.md)
- [Print address labels from Excel on Avery 5160 sheets](https://stella.sh/how/printing-labels/print-address-labels-from-excel.md)
- [Print envelopes from an Excel guest list, one per household](https://stella.sh/how/printing-labels/print-envelopes-from-excel.md)
- [Generate certificates from an Excel list, one per person](https://stella.sh/how/printing-labels/make-certificates-from-excel.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
