Generate QR Codes in Google Sheets — Formula Guide

Step-by-Step Guide

1. 1

   Open your Google Sheet and put your URLs or data in column A (starting from A1).

2. 2

   In cell B1, enter the QR formula: =IMAGE("https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl="&ENCODEURL(A1))

3. 3

   Resize row 1 and column B to be large enough to show the QR code (right-click row → resize to ~160px height).

4. 4

   Drag the formula down from B1 to generate QR codes for all rows in column A.

5. 5

   To use custom-branded QR codes instead: generate in bulk on QRCrack (Bulk QR Generator), download the ZIP, then insert as images using Insert → Image → Image in cell.

6. 6

   For automated generation via Apps Script: open Extensions → Apps Script and use the UrlFetchApp to call the Charts API programmatically.

7. 7

   Download your sheet or share with your team — QR codes render live from the formula.

Code Snippet

// Google Sheets IMAGE formula (put in any cell)
=IMAGE("https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl="&ENCODEURL(A1))

// Apps Script to generate QR codes as actual images
function insertQRCodes() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const lastRow = sheet.getLastRow();

  for (let i = 1; i <= lastRow; i++) {
    const url = sheet.getRange(i, 1).getValue();
    if (!url) continue;

    const qrUrl = "https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl="
                  + encodeURIComponent(url);
    const blob = UrlFetchApp.fetch(qrUrl).getBlob();
    const img = sheet.insertImage(blob, 2, i); // column B
    img.setWidth(100).setHeight(100);
  }
}

Frequently Asked Questions

More Integration Guides