How to easily create a QR code using Google Sheets

QR codes is a handy tool to instantly connect the offline phenomena with their online form. They can be used for a variety of problems, from redirecting with a Billboard on the street to the point of sale of the goods on the Internet, to tracking the activity of participants in video conferencing.

How they are actually created and stored? Here’s one simple way: comes to the aid of the program Google Sheets. A simple formula for creating a QR code looks like the following:

=IMAGE(“https://chart.googleapis.com/chart?chs=200×200&cht=qr&chl=”&A2&””)

– where “A2” at the end is correlated with the cell reference containing the data for which you want to create a QR code, for example, in the URL shown in the picture example;

– Peredistyy fragment refers to the API for Google charts, which has the option to generate QR codes;

in this case the QR graph is converted to an image by using the encapsulation IMAGE.

If you want to create multiple QR codes, just add additional URLS (or other data types, for example, identification codes) below A2, select cell B2 and drag the selection box down, holding the blue box in the lower right corner of the selected cell. So the formula will apply to the selected number of rows.

Leave a Reply

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

Releated

Diet and exercise win diabetes of the 2nd type in 61% of patients

Two independent studies conducted in Qatar and the UK, revealed that the idea that diabetes 2 type can be defeated by reducing weight. And so it was no secret that losing weight to a normal level and physical activity are beneficial to the health of the people. But this time, scientists have proven to cure […]

Updated microdom Ecocapsule easier and much cheaper

Ecocapsule (Ecocapsule) – the creation of the Slovak startup Nice Architects, was presented for the first time in 2015, and its final shape was formed by the year 2018. This microtomic egg-shaped, suitable for Autonomous living outside of urban infrastructure. For adherents of this style is now available a cheaper version – Space (the price […]

Control of the spacecraft Crew Dragon is very similar to a video game

After publishing the video with the flight of the spacecraft Crew Dragon to ISS experts are convinced that the management device is really built on a new “digital” principles. Moreover, it is very similar to the browser-based simulation game released by SpaceX earlier. It is very similar to video games and far from the usual […]