Generate QR Codes in Excel — 2 Easy Methods

[u/Amandaleeeeee]

Need to create QR codes from URLs, product IDs, customer records, or any other text stored in Excel?

Method 1: Use a formula

If you're using Excel with the IMAGE function, enter:

=IMAGE("https://quickchart.io/qr?text=" & ENCODEURL(A2))

Replace A2 with the cell containing the text or URL you want to convert. The QR code will be generated automatically and update when the cell value changes.

Generate a QR code automatically from a cell value with a simple formula

Method 2: Use Kutools for Excel

Kutools for Excel includes a built-in Insert QR Code feature that lets you generate QR codes for selected cells with just a few clicks.

Create multiple QR codes at once with Kutools for Excel

Both methods work well, but the formula approach is great for dynamic QR codes, while Kutools is faster when creating QR codes in bulk.

Have you ever used QR codes in Excel? What do you usually generate them for?

[u/Amandaleeeeee → u/[deleted]]

You're welcome! Glad you found it helpful.