Creating QR codes individually for extensive lists in documents can be a laborious process. Google Sheets offers a way to streamline this by automating the insertion, which helps conserve significant time. The key tool here is the IMAGE function, designed to pull images directly from the web and place them into the selected cell.
To start, type =IMAGE into any cell, and Google Sheets will display built-in guidance along with a sample. Select the arrow button on the side to view the full details. Take the provided sample featuring the Google logo, insert it into your cell, and hit Enter. The sheet will then download the image online and render it right there.
By integrating a request to QRServer, it's possible to produce QR codes on the fly within a Google Sheets document.
QRServer facilitates the creation of QR images through web-based calls. This service integrates seamlessly into Google Sheets for automatic placement of the data. Employ the IMAGE function once more for this purpose.
Consider a sample setup with multiple rows: the initial two columns hold the item names and their corresponding URLs. The next column produces the QR code via QRServer. The image fetch requires building the URL in this format: =IMAGE("https://api.qrserver.com/v1/create-qr-code/?data="&(A2)&"&color=000000&bgcolor=FFFFFF&size=200x200").
The retrieval link starts with the QRServer API endpoint: https://api.qrserver.com/v1/create-qr-code/. Additional options follow, connected by a question mark and ampersands. The primary element sets the QR target using 'data', pulled from the adjacent left column.
Next come customizable choices for the front and rear hues: 'color' and 'bgcolor' use hexadecimal RGB values, following common web standards. The concluding option, 'size', determines the dimensions of the resulting QR code.
Google Sheets' IMAGE feature supports incorporating visuals from numerous web locations. Its documentation includes a demonstration with a company logo.
These setups prove useful for applications like information displays or inventory layouts, where smartphone scanning swiftly links users to specific online pages. After completing the sheet, export it as a PDF to your computer through the File options.
The QR codes in Google Sheets load fresh each time the file opens, ensuring they update dynamically. For other options beyond Google's tool, try Microsoft Office 365 or the web-based Excel, both of which offer an IMAGE equivalent, though the formula structure may require tweaks.
This piece first appeared in our affiliated outlet PC-WELT, adapted and translated from its German version.