How to Generate QR Codes in Microsoft Excel (Formulas & VBA)

Generating QR codes inside Excel allows supply chain managers, event planners, and teachers to create bulk barcodes alongside product IDs and student names.

Method 1: The Modern Excel IMAGE Formula

In Excel 365, insert this formula into cell B2 (where A2 contains your URL or serial number):

=IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=" & ENCODEURL(A2))

Drag the formula down to generate hundreds of QR codes instantly!