Excel QR Code Generator: What Works and What Does Not

There is no QR function in Excel

Start here, because it saves an hour of searching. Excel — desktop, Microsoft 365, or web — ships no QR code formula, no Insert menu entry, and no built-in barcode object. The =QRCODE() you may have seen in a forum post does not exist in any version.

What Excel does have is the thing that matters: your data, in a column, already structured. Codes are easy. Getting a thousand rows of URLs into a thousand correctly named files is the actual job, and that is the one worth solving properly.

The four approaches, ranked by how well they hold up

1. Generate outside Excel, from the column (the one to use)

Copy the column of URLs, paste it into a bulk QR code generator, and download a ZIP of images named after your own data. No add-in for anyone to install, no macro to be blocked, and the files are real PNG or SVG you can drop into a mail merge, a label sheet or InDesign.

This is the approach that survives contact with a colleague's machine, which none of the others reliably do.

2. An Office add-in

Insert > Get Add-ins, search for a QR generator, and you get a task pane that writes a code into the sheet. Fine for a handful of codes on your own machine. The problem appears when you send the file: the codes are add-in objects, so anyone without that add-in sees blanks or broken placeholders. Check what the add-in does with your data, too — a free add-in that sends every cell to an unnamed server is not free.

3. A VBA macro

The classic answer, and increasingly the wrong one. It is Windows desktop only — no Mac, no Excel on the web, no mobile. Modern Office blocks macros from files that came from the internet or email by default, so a macro-driven workbook usually arrives dead. And it needs a code-generation library anyway, which is a dependency you now maintain.

Use it only when the workbook stays on one controlled machine.

4. The IMAGE formula — Google Sheets only

In Google Sheets, =IMAGE("https://…" & A2) renders an image from a URL and updates when A2 changes, which is genuinely useful for a live-updating sheet.

Two warnings. First, Excel's own IMAGE() function exists in Microsoft 365 but is restricted, and the old Google Charts endpoint most tutorials still reference was deprecated years ago — that is why so many copy-pasted formulas now render a blank box. Second, a formula-rendered code is not a file. It lives as a remote fetch, so it disappears offline, cannot be exported at print resolution, and breaks when the sheet is shared with someone who cannot reach the endpoint.

For anything going to print, export real files instead.

Getting a column of data into codes

The usual spreadsheet job is not one code, it is a few hundred: product SKUs, staff badges, table numbers, asset tags, event tickets. The pattern that works:

1. Build the full URL in a helper column. ="https://example.com/p/" & A2 beats hand-typing. Copy down.
2. Add a filename column. Whatever should name each file — SKU, room number, employee ID. This is what turns a ZIP of qr_001.png into something usable.
3. Paste both columns into the bulk generator, choose PNG for screens or SVG for print, and download.
4. Reunite files with rows using the filename column, in a mail merge or a label template.

If those codes go on anything printed that might change later — a price list, a menu, an asset tag pointing at a moving system — generate them as dynamic codes so the destination can move without reprinting a single label.

What breaks, and why

Codes vanish when the file is shared. Add-in objects, not images. Export real image files instead.

A formula shows a blank box. The endpoint it calls is dead — most tutorials still cite the retired Google Charts API.

Codes stretch out of square. Excel row-height and column-width changes scale an in-cell image non-uniformly, which destroys the finder patterns. Lock the aspect ratio in Format Picture, or place codes outside the grid.

Printed codes will not scan. Excel's print scaling shrinks everything to fit the page. A code that is 2 cm on screen can land at 8 mm on paper — below the practical floor. Set print scaling to 100% and check the size guide.

The macro does nothing. It is blocked, or you are on Mac or the web. Nothing you can fix inside the file.