-How to Create QR codes using Google Sheets

1.  Create new Sheet file from your Drive

Open your Drive using your Google account. Then click New button and select Google Sheet

2. Start pasting your links

Write or paste the links you want to create QR codes for.

3. Export QR codes using the below formula

In the cell in front of the link, paste the below formula:

=image(“https://image-charts.com/chart?chs=150×150&cht=qr&choe=UTF-8&chl=”&ENCODEURL(A2))

Then click Enter

You can then drag the cursor from the corner of the cell to apply it to the other cells.

You can also resize the rows by dragging it down to increase the QR code.

4. Save QR code as an image to your device

You can save it as an image in your device by using Snapping tool

• Press buttons: Win+Shift+S   then select the QR code
• Paste the image in WhatsApp or Word Document or any other file.