Create QR Code Using Formula in Google Sheet

Create QR Code Using Formula in Google Sheet

You can create a QR code in Google Sheets using the following formula, which uses the Google Charts API:

scss
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&A1)

In this formula, "A1" is the cell that contains the data that you want to encode in the QR code. You can replace "A1" with any cell reference that contains the data you want to encode.

The formula generates a URL that points to the Google Charts API, which generates the QR code image. The "chs" parameter specifies the size of the image, and the "cht" parameter specifies the chart type (in this case, "qr" for QR code). The "chl" parameter contains the encoded data.

Once you enter this formula in a cell in your Google Sheet, the QR code image will be generated and displayed in the cell. You can then copy and paste the image to other cells or to other applications.

Note that the QR code image will only be displayed if the data in the cell is text or a URL. If the data is a number or a date, you will need to convert it to text first using the TEXT function, like this:

less
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&TEXT(A1,"0"))

This will convert the number or date in cell A1 to text format before encoding it in the QR code.