How to Create QR Codes in Google Sheets Using a Chrome Extension

In Google Sheets, QR codes can be easily created not only by using formulas but also by utilizing extensions.

In this article, we will introduce how to create QR codes using a Chrome extension.

This method is useful if you want to save the generated QR codes to Google Drive.

あわせて読みたい

How to Easily Generate QR Codes in Google Sheets Using Formulas Have you ever thought creating QR codes is challenging, especially when using tools or writing code? With Google Sheets, you can easily generate QR codes usi…

Example Output

Select the cell containing the data you want to convert into a QR code.
Choose the size and file format for the QR code, then generate it.
Save the QR codes in bulk to Google Drive.

The extension to use is “QR Code Generator.”

“QR Code Generator” is an extension that allows you to easily create QR codes in Google Sheets.

You can generate QR codes based on data such as URLs and text.

It is characterized by its intuitive interface, requiring no complex setup.

How to Install the Extension

STEP

Open Google Sheets.

Open any Google Spreadsheet of your choice.

STEP

Open the Extensions menu.

Click on “Extensions” in the top menu > “Add-ons” > “Get add-ons”.

STEP

Search for “QR Code Generator” in the add-ons store.

Type “QR Code Generator” into the search bar and select the desired extension.

STEP

Install

Click the “Install” button and authenticate with your Google account.

STEP

The extension will be added to your Google Sheets.

Once the installation is complete, it will be added to the Extensions menu.

QR Code Creation Steps

STEP

Enter the data.

Enter the data you want to convert into a QR code (e.g., URL, text) into any cell.

STEP

Launch the Extension

Select and launch the installed extension from the menu.

STEP

Select the Cell That Contains the Data You Want To Convert Into a Qr Code

Select the cell that you want to convert into a QR code.

STEP

Set the size of the QR code.

Select the size of the QR code from the dropdown menu.

• Tiny(60px)
• Small (100px)
• Medium (150px)
• Large (200px)

STEP

Set the File Format for Saving.

Check the box for your desired file format.

Choosing the document format allows the QR codes to be saved together in a single file, making it easier to manage.

The PNG format is highly versatile and can be used both digitally and for printing.

Save as Document

Select this option if you want to save the QR code as a Google Document.

Save as PNG

The QR code will be saved as an image (PNG file) in Google Drive.

Use Second Column

Select the range of two adjacent cells or two columns.

The value in the first column will be displayed as a QR code, and the value in the second column will be displayed below the QR code.

Other Options

Draw Border

Add a border to the QR code.

Shorten URL

If the URL is long, selecting this option will generate the QR code using a shortened URL.

To use this option, a Bitly access token is required.

STEP

Generate the QR Code

Once you have completed the necessary settings, click the “GENERATE” button.

STEP

The Qr Code Will Be Saved To Google Drive

The QR code will be saved to Google Drive.

Summary

Creating QR codes with the extension is easy once the initial installation is complete.

Some extensions allow for design adjustments, making them ideal for those who prioritize customization.

By utilizing these tools, you can streamline your daily operations and marketing activities.

あわせて読みたい

How to Easily Generate QR Codes in Google Sheets Using Formulas Have you ever thought creating QR codes is challenging, especially when using tools or writing code? With Google Sheets, you can easily generate QR codes usi…

Our company offers support for improving work efficiency through the use of Google Apps Script.
If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us.
We are fully committed to supporting your business improvements.

Contact us here