12.7 Interesting Add-ons : QR Code Generator

Translating any URL into a QR code is quite useful today. This can be done quite easily using an Add-on in Google Sheet named "QR Code Generator". You can use it to create 20 QR codes per day for free.

Install QR Code Generator

• 1. In a Google Sheet document, click "Add-ons" then select "Get add-ons".

  2. Search with key word "QR Code Generator".

  3. Select the first result (the one with most comments) and then click "Install"

  4. When the system ask to bind to an email, using the University email.

  5. Accept its permission requirements (or you cannot use it).

Create QR Code

• 1. In a Google Sheet, click "Add-ons" then select "QR Code Generator" and then select "open". The QR Generator panel will be displayed at the right side.

  2. In QR Code tab, to make it easy, check at "Save as Document", and if you want border, check "Draw Border". If you prefer image, use "Save as PNG".

  3. In Setting tab, setting desired document name or file name (in case of PNG) and target output folder (your root is default). Once finish setting, move back to "QR Code" tab.

  4. Select one or more cells or whole column, then, at the QR Code panel, click "Generate".

  5. QR code(s) will be generated as much as data you select in step 4.

  6. The QR code(s) will be saved in the target folder as document or file(s) according to your selection.