How to Create QR Code in Excel (3 Suitable Methods)

To explain how you can generate QR codes in Excel, let’s use a dataset that contains the Site Name and its URL which is the Value for our QR code.

Method 1 – Using Office Add-ins to Create QR Code in Excel

Steps:

• Go to the Insert tab.
• Select the Get Add-ins option from the Add-ins group.

A library will appear on the screen.

• Search for QR4Office. You should get a single exact match.
• Click on Add to add the QR4office to your Add-ins.

• Select Continue, and QR4Office will be installed.

• Select the cell where you want to add the QR code (in this case D5).
• Go to the Insert tab again.
• Select My Add-ins.

• This will lead you to your My Add-ins library.
• Select QR4Office.
• Click on Add.  

• QR4Office opens on the Excel worksheet. You can type text or URL that you want to encode. You can also change the color, size, and background of the QR code from here.

• Type in the text or URL that you want to encode. Here, we typed the URL for ExcelDemy.
• Click Insert to get your QR code.

• This fills the QR code for the desired site.

• Repeat the process to get all the other QR codes you want.

Method 2 – Creating User Defined Function to Generate a QR Code

Steps:

• Go to the Developer tab.
• Select Visual Basic. This opens the Visual Basic window.

• Go to the Insert tab. 
• Select the Module option to open a new module.

• In the Module, type in the following code.

Function QR_Generator(qrcodes_values As String)
    Dim Site_URL As String
    Dim Cell_Values As Range  
    Set Cell_Values = Application.Caller
    Site_URL = "https://chart.googleapis.com/chart?chs=100x100&&cht=qr&chl=" & qrcodes_values
    On Error Resume Next
      ActiveSheet.Pictures("Generated_QR_CODES_" & Cell_Values.Address(False, False)).Delete
    On Error GoTo 0
    ActiveSheet.Pictures.Insert(Site_URL).Select
    With Selection.ShapeRange(1)
     .Name = "Generated_QR_CODES_" &  Cell_Values.Address(False, False)
     .Left = Cell_Values.Left + 2
     .Top = Cell_Values.Top + 2
    End With
    QR_Generator = ""   
End Function

• Save the code as Excel Macro-Enabled Workbook and go back to your sheet.

• Select all the cells where you want your QR codes. We selected cells D5, D6, and D7.

• Write the following formula.

We used the QR_Generator function defined by the VBA code. This function will return us the QR code for the Value in cell C5.

• Press Ctrl + Enter to get QR codes for all the cells.

Method 3 – Creating QR Codes in Excel Using the IMAGE Function

Steps:

• Apply the following formula and use Fill Handle to AutoFill QR codes in the rest of the cells in column D.

Things to Remember

• Using the conversion functions and installing add-ins requires an internet connection.
• While using the IMAGE function to generate QR codes, the generated QR codes get fitted according to the cell height. You can resize the QR codes just by changing the row height according to your needs.

Frequently Asked Questions

1. Can I use a specific font to generate a dynamic QR code in Excel?
There is a dedicated font named AlphanumericQR to generate QR codes in Excel.

2. How do I generate a QR code with a formula in Excel?
With the help of the IMAGE function in a formula, we can generate a QR code in Excel.

3. Is it possible to create multiple QR codes at once in Excel?
With the help of a VBA code, we can create multiple QR codes quite easily.

Download Practice Workbook

You can download the practice workbook used in this article from the download link below.

QR Code in Excel: Knowledge Hub

• Batch QR Code Generator from Excel
• QR Code Attendance Tracking with Excel
• How to Scan QR Code to Excel Spreadsheet
• Excel VBA: Open Source QR Code Generator

<< Go Back To Learn Excel