Easily Create QR Codes in Google Sheets Step by Step Tutorial
In this video, you'll learn how to quickly and easily create QR codes in Google Sheets using simple formulas. This tutorial is perfect for anyone who wants to add QR codes to their spreadsheets for sharing contact information, linking to websites, or tracking data.
Formula:
Note: Please remove space from formula before using in google sheet. (Space before googleapis)
=IMAGE("https://chart. googleapis.com/chart?chs=150x150&cht=qr&chl="&ENCODEURL(A1))
Here's a step-by-step explanation of the formula ="https://chart.googleapis.com/chart?ch..."&ENCODEURL(A1)
1. Base URL:
https://chart.googleapis.com/chart: This is the base URL for accessing the Google Chart API, which offers various chart-generating capabilities, including QR code creation.
2. Chart Type:
?cht=qr: This parameter specifies that you want to create a QR code chart.
3. Size:
&chs=150x150: This parameter sets the size of the QR code in pixels, as width x height. In this case, it's set to 150 pixels by 150 pixels. You can adjust this value to customize the size of the generated QR code.
4. Data to Encode:
&chl=: This parameter is where you'll provide the data to be encoded into the QR code.
5. Data Encoding:
&ENCODEURL(A1): This function encodes the data in cell A1 to a URL-safe format, ensuring it's compatible with the API request. It's crucial for handling spaces, special characters, or reserved symbols that might otherwise cause issues in the URL.
6. Combining the Parts:
The formula combines all these elements to construct a complete API request that fetches a QR code image representing the data in cell A1, with a size of 150x150 pixels.
-------------------------------------------------------
#GoogleSheets #QRcode
Please watch more videos on this Channel...
Other Playlists:-
/ schoolingstreet
Please Subscribe To Get Notified About New Videos… Also, Like and Follow My Channel Social Pages Here….!
Facebook:
/ schoolingstreet