With Google Sheets, it looks like Microsoft Excel, but some functions in Google sheets don’t have in Excel. A function that Microsoft Excel doesn’t have is the IMAGE function. This function is important for inserting an image into the cell.

For this article, I used the IMAGE function for calling the QR code image to generate value for the QR code image. So I show you step-by-step How to create QR codes in Google sheets using the IMAGE function and Google APIs QR code generation. Please enjoy and follow with me :

How to generate QR code

For QR code generator in Google sheets, you need :

1 – IMAGE Function

=IMAGE(url, [mode], [height], [width])

For : [mode],[height],[width] optional

2 – Google QR code generator link

https://chart.googleapis.com/chart?chs=<width>x<height>&cht=qr&chl=<data>

3 – Use the IMAGE function and Google QR code generator link together

For example :

<width> = 200, <height> = 200, <data> = cell B2

=IMAGE("https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl="&B2)

Final Result :

But if you need data as text or number with space or new line, you can understand about URL special code

URL code meaning :

%20 = space
%0A = new line

For Example :

Puthea Training = you should be written in the data cell as Puthea%20Training

Final Result :