How to Create QR Code in Excel [4 Ways]

Can you create a QR code in Excel? QR codes, also known as Quick Response codes, can be scanned to quickly access a wide range of information. It is undoubtedly a great way to streamline processes and increase data accessibility. Integrating QR codes into Microsoft Excel would be even better. Thus, today we will walk you through how to generate QR code in Excel, ensuring that you can easily and efficiently utilize the power of this technology.

The easiest way to generate QR code in Excel is to use a QR code generator. iMyfone QRShow is such an advanced QR code generator that can convert various contents into QR codes including links, images, text, Excel, etc. Whether you are an individual user or a business, you can find the QR code solution you want. Below we will show you how to create QR code in Excel and how to convert Excel to QR code.

1. How to Create QR Code in Excel with iMyFone QRShow

Step 1: Visit the iMyfone QRShow Excel to QR code converter online and click 'Sign in/up' at the top right to sign up your account.

Step 2: Select the corresponding type according to the QR code content you want to generate in your Excel. For example, if you want to generate a QR code for a link, select 'URL'. Then copy and paste your link.

Optional Step: Enhance the professionalism of your dynamic QR code by personalizing it. You can customize your QR code with your logo, template, color, eyes, and more.

Step 3: Simply click 'Generate QR Code' to create a QR code for your content.

Step 4: After generating, you can click 'Download' to save your QR code as JPG, PNG, SVG, or PDF.

Step 5: Go to your Excel document and choose 'Insert' > 'Pictures' > 'This Device' to add your saved QR code into Excel.

2. How to Convert Excel to QR Code with iMyFone QRShow

Step 1: Go to iMyFone QRShow QR Code Generator and then choose 'Excel'.

Step 2: Click 'Add File' to upload Excel from your device. You can also drag & drop or copy & paste your Excel file. It allows you to add multiple files at once, which is really awesome.

Step 3: If you want to protect the security of your Excel, you can check 'Private' to set a secure password. Only people who know your password can access your Excel.

Step 4: Finally, customize your QR code and one-click to create QR code for Excel file.

Excel Addins are useful because they offer functions that simplify tasks within Excel. They also include previously unreleased features or enhanced functionality. Here is how you can generate QR code Excel using third-party add-ins:

Step 1: First open the Excel file to which you want to add QR codes.

Step 2: Select Insert. Next, go to the Add-ins area.

Step 3: Search and select a QR code generator add-in. Hover your mouse, over to the Add button and click.

Step 4: Enter the URL you want a QR code for. Personalize your QR code with the right color and size.

Step 5: Press the button for insert. In the chosen cell, the add-in will automatically add a QR code.

With Microsoft 365 for Windows, Mac, and Web, you can create unique QR codes by using the image () function. The IMAGE function might not be available in all versions of Microsoft 365. Additionally, you need a QR code generator API to convert Excel text into a QR code image.

Step 1: Install Power Query (if not already installed)

Open Excel. Go to the "Data" tab.

Click on "Get Data" and select "Get Data from Online Services."

Choose "From Other Sources" and then select "Web."

Enter the following URL: https://www.myget.org/F/powerquery-msi.

Follow the prompts to install Power Query.

Step 2: Create a QR Code Generator API Key

Go to a QR code generator website that provides an API. For example, you can use qr-code-generator.com or qr-code-api.com.

Sign up for an account and obtain an API key.

Step 3: Create a QR Code in Excel

Open Excel and enter the text you want to convert to a QR code in a cell. For example, enter the text in cell A1.

Go to the "Data" tab and click on "Get Data" > "From Other Sources" > "Blank Query."

In the formula bar, enter the following Power Query M formula, replacing YourAPIKey with the actual API key you obtained:

This formula sends a request to the QR code generator API and retrieves the QR code image.

Press Enter, and a dialog box will appear. Click on "OK."

In the Power Query Editor, you will see a table with a column containing a URL. Close the Power Query Editor.

In a blank cell, enter the following formula, replacing WebURL with the actual URL from the Power Query result:

This formula uses the IMAGE function to display the QR code image.

Press Enter, and the QR code for the entered text should appear in the cell.

You cannot use the IMAGE function if you do not have Excel 365 or Excel Online. However, there is an additional option: VBA. Copy and paste the code below into a standard code module. Run the code after that. The macro places the QR code into cells C19:C25 of Sheet1 based on the URL in cell C3. You may modify them to suit your needs.

Creating a QR code for your Excel is just the beginning, tracking the scans is also a crucial step. It is worth noting that static QR codes are fixed data and have no tracking function. To track QR code, you need to use a dynamic QR code. You can use a QR code generator with tracking function, such as iMyFone QRShow QR Code Generator. Below is how to track Excel QR code with QRShow.

View also: Static QR Code vs Dynamic QR Code

Step 1: Follow the steps in the Part 1 to generate a dynamic QR code.

Step 2: Visit the QRshow dashboard and click 'Dynamic QR Code' under 'My QR Code'. Then choose the Excel QR code you created before.

Step 3: Click on the 'Analysis' icon and you can monitor real-time scanning data, such as the number of scans, scanning time, device, geographic location, and device, etc.

Whether you want to convert Excel to QR code or create QR code in Excel, iMyFone QRShow makes this process very simple. Through today's tutorial, you will be able to easily create QR codes and integrate them into Excel spreadsheets, thereby enhancing data management and sharing capabilities. Use qrshow to generate QR codes for your content immediately!