Excel QR Code with Caption

1

Im using the following formula to show specified data from a cell in excel, I want to add Caption below linked to a specific cell in the same row and want to drag the formula down.

My current formula reads as:
=IMAGE(“https://quickchart.io/qr?text=”&N2,N2,3,150,150)

Please assist with:

  1. Adjustment to formula to add the caption (Linked to cell)
  2. Ability to change the Font type and size (eg. Arial, Bold, 14)
2

Any assistance would be greatly appreciated…

3

Hi @CobusD, have a look at the QR code documentation, specifically the caption parameter. You should add caption to the URL.

It would look something like

=IMAGE("https://quickchart.io/qr?text="&N2,N2,3,150,150 & "&caption=" & A2)

(assuming your caption is in A2)

4

If the caption contains spaces you must use the ENCODEURL function which would alter the formula to:

=IMAGE(“https://quickchart.io/qr?text=”&N2,N2,3,150,150 & “&caption=” & ENCODEURL(A2))

I didn’t see, or missed that ENCODEURL information in the documentation regarding captions.

I also found it helpful to increase the size of the QR code until the caption fits below it nicely rather than fool around with the fonts and sizes. Once placed in a document, I can always resize the QR Code and the caption still looks good.

5

This doesn’t work. is there a typo maybe. I copy it straight into my excel cell. not working

6

Hi Derek,

I created a QR Code for the BBC Home Page with a caption in Google Sheets.

The first column contains the URL to the BBC Home Page (Cell A2).

The second column contains the Caption I want below the QR Code (Cell B2).

The third column is an image of the QR Code as generated by Quick chart. I consider this image a test image because I can shoot it with my phone to see if it works, but I cannot download this image. The formula in this cell is:
=IMAGE(“https://quickchart.io/qr?text=” & ENCODEURL(A2) & “&size=300” & “&margin=4” & “&caption=” & ENCODEURL(B2))

The fourth column generates a link that will take you to a new tab with nothing but the QR Code image. This is an image you can download and save. Right click on the image to Save Image As… The formula in this cell (D2) is:
=“https://quickchart.io/qr?text=“&ENCODEURL(A2)&”&caption=“&ENCODEURL(B2)&”&size=300&margin=4”

I will try to send you a shared link to my spreadsheet in another reply. I am a new user and I am limited to 2 links in this reply.

1 Like
7

Here’s the link to my spreadsheet.