How to Scan QR Code to Excel Spreadsheet (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

QR codes’ popularity is increasing daily in the marketing and advertising industry. These codes can direct customers or target audiences directly to hyperlinks. Not to mention, Smartphones nowadays are equipped with handy tools to scan these codes that can directly lead them to the preferred intention. These advantages make QR codes a more potent tool not only in marketing but also in medical, education, etc. sectors. In this tutorial, we will focus on making QR code in Excel Spreadsheet to scan.


Download Practice Workbook

You can download the workbook containing the dataset and QR codes for the demonstration from the download link below.


Step-by-Step Procedure to Scan QR Code to Excel Spreadsheet

Excel is a powerful tool that can generate scannable QR codes very easily. To generate a QR code in an Excel spreadsheet we need to use an add-in and to scan we need scanning tools. There are different scanning tools available that can scan these QR codes. We can use smartphones for this purpose too. The process is divided into parts for a better understanding, regardless of your knowledge of Excel. We are going to convert each entry in the following dataset into a QR code in an Excel spreadsheet and scan them to find if they are working as intended or not.

scan qr code to excel spreadsheet


Step 1: Install Add-in

Add-ins are very useful tools that make our experience with Microsoft Office programs very smooth. These add-ins help make up for the lack of built-in tools in the program. The add-in that can help us generate a QR code in an Excel spreadsheet is called the “QR4Office”. To install this add-in in your Excel, follow these steps.

  • First, go to the Insert tab on your ribbon.
  • Then click on the Get Add-ins option from the Add-ins group.

scan qr code to excel spreadsheet

  • As a result, the Office Add-ins box will open up. Make sure you are in the Store tab in it.
  • Then in the search box on the left, type in “QR4Office” and then press Enter.
  • Once the search result is up, click on Add beside the add-in.

scan qr code to excel spreadsheet

  • Next, click on Continue in the following window.

Hence, this will add the desired add-in that can help us generate a QR code in an Excel spreadsheet that we can scan.

Read More: Open Source QR Code Generator


Step 2: Open Add-in in Spreadsheet

If you are adding this add-in for the first time it should be already open by the end of the first step. But if you want to reopen it or if it didn’t open by the end of the first step follow these simple steps to open the add-in in the Excel spreadsheet.

  • First, go to the Insert tab on your ribbon.
  • Then click on My Add-ins from the Add-ins group.

scan qr code to excel spreadsheet

  • Now the Office Add-ins box will open up again. This time, make sure the My Add-ins tab is open.
  • Then select “QR4Office” from your add-in list.
  • After that, click on Add.

As a result, QR4Office will now open in the Excel spreadsheet.

scan qr code to excel spreadsheet


Step 3: Select Type of Encode

Once you have downloaded and added the add-in to your Excel spreadsheet, it is time to start encoding your data into QR codes. But first, you need to select the type of data you are encoding in QR codes into.

You will find this option on top of the QR4Office window. For the first two entries in our dataset, we have two URLs. So we need to select “http://” or “https://”.

scan qr code to excel spreadsheet

For the third entry, we have ‘New York City”. If we want to open it on a map, we need to select the encoding type as geo: and enter the coordinates.

But if you want to encode these values as just a string (for example, the fourth entry of our dataset), select custom as the encoding type and then put the value in the entry box.


Step 4: Customize Options for QR Code

After selecting the type and the text/code you want to encode, you can also customize your QR code in the add-in before generating.

You can change the color of the QR code and the background from the Color and Background options under the Options section.

Then again, you can change the size of the generated QR code from the Size bar under the Options section. You can also resize it after inserting it.

Moreover, you can also change the error correction from the option under such name under the Options section in case the QR code you are generating gets damaged for some reason.

We are selecting the default black and white as colors and medium as the error correction option for our demonstration.


Step 5: Insert QR Code

Once you have selected the input and customization options from the previous step, you can finally insert the QR code into your spreadsheet.

To insert the QR code into your spreadsheet, simply click on Insert from the bottom of the QR4Office window.

scan qr code to excel spreadsheet

Once you have done that the QR code will pop up on your spreadsheet.

scan qr code to excel spreadsheet

You can also right-click on the QR code and save it as a picture from the context menu for external use.

Read More: Batch QR Code Generator from Excel 


Step 6: Scan QR Codes

Next, let’s scan each QR code we have generated in the Excel spreadsheet to see if it directs us to the hyperlinks we are intending to reach. To do that you need a QR code scanner. But for now, we are using our smartphone’s scanner for this purpose. Usually, smartphones nowadays come with this feature built-in in the devices. If your smartphone doesn’t have one, you can download a third-party application from the store depending on the OS you are using and that should do the trick.

The final look of our dataset after generating all of the QR codes is like this.

scan qr code to excel spreadsheet

By scanning the first QR code from the entry, we will have exceldemy.com opened in the browser.

Now scan the second QR code from this Excel spreadsheet to open google.

scan qr code to excel spreadsheet

Scanning the third QR code will direct us to the map of New York city at the co-ordinates we had entered.

Meanwhile, scanning the fourth QR code will just show us the text.

scan qr code to excel spreadsheet


Conclusion

That concludes your guide on how to generate a QR code in an Excel spreadsheet and scan it to redirect to desired hyperlinks. Hope you can generate your QR codes now and scanning them would yield accurate results. I hope you found this guide helpful and informative. If you have any questions or suggestions, let us know in the comments below. For more guides like this, visit Exceldemy.com.


Related Articles

Abrar-ur-Rahman Niloy

Abrar-ur-Rahman Niloy

Hi! my name is Abrar-ur-Rahman Niloy. I have completed B.Sc. in Naval Architecture and Marine Engineering. I have found my calling, if you like, in Data Science and Machine Learning and in pursuing so, I have realized the importance of Data Analysis. And Excel is one excel-lent tool do so. I am always trying to learn everyday, and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo