How to Generate QR Codes in Excel and Google Sheets (Step-by-Step Guide)

—

by

Himanshu
in ,

You can generate QR codes in Excel (Microsoft 365) and Google Sheets easily using built-in features or free add-ons. Here’s a detailed guide for both platforms:

✅ In Microsoft Excel (Microsoft 365)

🔸 Method 1: Using Excel Add-in – “QR4Office”

📌 Steps:

  1. Open Excel and go to the Insert tab.
  2. Click on “Get Add-ins” (or Office Add-ins).
  3. Search for “QR4Office” and click Add.
  4. Once added, go to Insert → My Add-ins → QR4Office.
  5. A QR code generator pane will appear on the right.

🎯 To Generate a QR Code:

  • Enter the text or URL you want to convert.
  • Adjust size, color, and error correction level.
  • Click Insert — the QR code will appear in your sheet as an image.

🔸 Method 2: Using a Web API (Google Chart API)

You can generate QR codes dynamically using a formula with an image from an online API.

📌 Steps:

  1. Use this formula in a cell:
=IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A2)

✅ Replace A2 with the cell that has the text or link you want to turn into a QR code.

📝 chs=150x150: Size of the QR code
📝 chl=: The data encoded in the QR code

Note: Excel’s IMAGE function is available in Microsoft 365 versions only.

✅ In Google Sheets

📌 Steps:

  1. In a cell, enter this formula:
=IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A2)

✅ Replace A2 with the reference cell containing the text or URL you want in the QR code.

The QR code will appear in the cell as an image.

🧠 Extra Tips:

  • You can drag the formula down to generate QR codes for an entire list.
  • You can use ENCODEURL(A2) inside the formula to safely encode special characters:
=IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & ENCODEURL(A2))

Top rated products