#616 List of URLS to individual QR codes in Google Sheets

So we have a list of 616 web links that we need to make more accessible to users via QR codes. That would take ages with a QR code generator. With this google sheets tip you can create individual QR codes for all your links in the time it tales for you to drag a formula down a sheets column

Place this equation in your sheet =IMAGE(“https://chart.googleapis.com/chart?chs=200×200&cht=qr&chl=”&B2&””)

Change the B2 in the formula to the first cell that has an URL and drag copy down a column and you are done. Google charts will generate a QR code for each url.

Photo by Марьян Блан | @marjanblan on Unsplash

Read the full story by


Using the school LMS to provide emotional support in remote learning From Research to Promising Practices – Building Youth Connections for Wellbeing
We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK