QR Codes in Excel: How to Create Them

QR codes in Excel are a solution and a tool that is gaining ground in the creative and entrepreneurial projects of many people around the world.

Today we see QR codes in many different areas of commerce, because they can store many types of information. A QR code can hold data such as links to websites, text, contact details, connection details and even information for bank payments.

For all these reasons, QR codes have become very popular across the commercial sector, and they will very likely replace the old barcodes in the near future.

How do you make a QR code without macros?

Excel is a very powerful tool, but it has no built-in feature for creating QR codes. That is why, below, we will show you a way to create a function that turns the information in Excel cells into a working QR graphic.

To create QR codes in Excel we need to use some Google tools that belong to the chart API for developers, but this time we will use it to generate the graphic inside Excel.

Using the API is very easy; all you need is the following URL:

http://chart.apis.google.com/chart?cht=qr&chs=300x300&chl= Edwin Ortiz

Replace the characters after the equals sign (=), paste it into any browser, and as if by magic you get a QR code ready to use. Here is a video (click the image) where I explain in detail how to use it.

QR codes in Excel using macros

Sometimes we need to create QR codes in bulk to make product labels, ID cards and so on, which will later be scanned with a mobile phone and stored in another Excel sheet. For this, we can use the following function, which works together with other Excel functions and ultimately produces QR codes in Excel, as easily as using the most basic function.

Below you will find 3 templates from my shop, plus the explanatory video (click the image) on how to create QR codes in Excel in bulk, and the code used in the video.

Prefer to have it ready?

More guides in Excel automation for office work