QR Code Generator for Excel — No Add-in Required
Quick Answer
To add a QR code to Excel: generate on QRCrack, download as PNG, then in Excel go to Insert → Pictures → insert the QR code image. Position it over the relevant cell using 'Move and size with cells'.
Step-by-Step Guide
- 1
Generate your QR code on QRCrack and download as PNG.
- 2
Open Excel and navigate to the cell where you want the QR code.
- 3
Go to Insert → Pictures → This Device → select your QR code PNG.
- 4
Right-click the inserted image → Format Picture → Properties → select 'Move and size with cells' so the QR code stays anchored.
- 5
Resize the image to fit within the cell (hold Alt while dragging to snap to cell borders).
- 6
For bulk QR codes: use QRCrack's Bulk QR Generator with your list of URLs. Download the ZIP, then use Excel's VBA macro to batch-insert images from a folder.
- 7
Repeat for each row. To automate, use the VBA macro provided below.
Code Snippet
' Excel VBA: Bulk insert QR code images from a folder
Sub InsertQRCodes()
Dim ws As Worksheet
Dim folderPath As String
Dim fileName As String
Dim cell As Range
Dim pic As Picture
Dim i As Long
Set ws = ActiveSheet
folderPath = "C:\Users\YourName\Downloads\QRCodes\" ' path to QR ZIP extracted folder
i = 1
Do While ws.Cells(i, 1).Value <> ""
fileName = folderPath & ws.Cells(i, 1).Value & ".png"
If Dir(fileName) <> "" Then
Set cell = ws.Cells(i, 2) ' insert in column B
Set pic = ws.Pictures.Insert(fileName)
With pic
.Left = cell.Left
.Top = cell.Top
.Width = 80
.Height = 80
.Placement = xlMoveAndSize
End With
End If
i = i + 1
Loop
MsgBox "QR codes inserted successfully!"
End SubReady to generate your Microsoft Excel QR code?
Free, no signup, no watermarks. Custom colors and logo supported.
Generate QR Code — FreeFrequently Asked Questions
Does Excel have a built-in QR code generator?
Excel 365 has a basic QR code add-in under Insert → Add-ins → search 'QR'. For custom branded QR codes, generate on QRCrack and import.
Can I generate 500 QR codes for an Excel product catalog?
Yes. Use QRCrack's Bulk QR Generator — paste all product URLs, download as ZIP, then use the VBA macro above to bulk-insert into your Excel file.
Can I use QR codes in Excel for inventory management?
Yes — link each QR code to a product SKU page or Google Sheets row. Print the QR and attach to physical inventory.
How do I print QR codes from Excel?
Set print area to include QR code cells. Use Page Setup → Scale → adjust so QR codes print at minimum 2cm × 2cm.