Generate QR codes using Excel and Google Sheets

QR Code (Quick Response Code) is the newest trend or tactic, and it is becoming more effective than ever. Touchless, frictionless marketing and eCommerce are becoming increasingly popular. The QR code can be easily read/scanned using smartphones. Many businesses now use QR codes for contactless sign-in, ordering food in restaurants, and other purposes. A QR code is made up of black squares arranged in a square grid on a white background that can be read by a camera of smartphone. It was created to enable fast decoding speeds, hence the name quick response code.

In both Excel and Google Sheets QR codes can be generated using the IMAGE function. This function inserts an image into a cell.

Syntax of IMAGE function for Google Sheets

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

• url – The URL of the image, including protocol (e.g. https://webisora.com).
• mode – [ optional – 1 by default ] – The sizing mode for the image
  - 1 resizes the image to fit inside the cell, maintaining aspect ratio.
  - 2 stretches or compresses the image to fit inside the cell, ignoring aspect ratio.
  - 3 leaves the image at original size, which may cause cropping.
  - 4 allows the specification of a custom size.
  - Note that no mode causes the cell to be resized to fit the…