QR codes are a handy tool to bridge the offline with the online.
Whether it’s to redirect an offline advertising campaign’s audience to your online destination, or to track your conference’s visitors while they’re moving from stage to stage, QR codes can be used for a wide variety of tasks.
The simple formula to create a QR code is as follows:=IMAGE(“https://chart.googleapis.com/chart?chs=200×200&cht=qr&chl=”&A2&””)Here, the ‘A2’ part at the end concerns the reference to the cell containing the data you want to create a QR code for, such as the url in the example below.
The part before is concerns a call to Google’s chart API, which has an option (‘qr’) to generate QR codes.
If you’d like to create QR codes in bulk, simply add more URLs (or other types of data, such as identification codes) below A2, select cell B2 and drag the blue box at the right bottom of the selected cell down.

Comments to: Holy sheet: How to create QR codes with Google Sheets

Your email address will not be published. Required fields are marked *

Attach images - Only PNG, JPG, JPEG and GIF are supported.

Login

Welcome to Typer

Brief and amiable onboarding is the first thing a new user sees in the theme.
Join Typer
Registration is closed.