Get started in 10 seconds

Generate QR codes and barcodes from your Google Sheets™ data in a few simple steps.

1. Select a cell or range of cells in your spreadsheet.

2. Choose QR Codes or Barcodes from the Code Type dropdown.

3. Preview the generated codes and adjust the settings if needed.

4. Click GENERATE

5. Open the generated Google Docs™ document or output folder to view your results.

Generate A code from A SINGLE CELL

Select a single cell containing the value you want to encode.

The Preview panel automatically displays the generated QR code or barcode.

For QR codes, use the size slider to adjust the dimensions. For barcodes, select the desired format from the Barcode Type dropdown.

Click GENERATE to create the output.

Generate multiple QR codes at once 

Select a range of cells in a single column. Each non-empty value will be encoded as a separate QR code or barcode.

Use the navigation arrows in the Preview panel to browse the selected values and inspect their generated codes.

Empty cells and rows are automatically skipped.

Tip: You can select an entire column to generate codes from multiple values at once. Empty cells will be skipped.

Add labels below codes 

Enable Use Labels to display text below generated QR codes or barcodes.

When enabled, you must select two adjacent cells or a range containing exactly two adjacent columns:

• First column: Contains the values to encode.

• Second column: Contains the labels displayed below the generated codes.

The Preview panel displays each generated code together with its corresponding label.

When Use Labels is disabled, select a single cell or a range in one column.

Choose a Code Type

The add-on supports two types of codes:

• QR Codes — Encode text, URLs, identifiers, and other values. Adjust the QR code size using the slider.

• Barcodes — Choose from supported formats, including Code 128, EAN-13, EAN-8, UPC-A, UPC-E, Code 39, Code 93, ITF, ITF-14, MSI, Pharmacode, and Codabar.

The add-on automatically determines barcode dimensions based on the selected format and encoded value.

Note: Some barcode formats require specific numeric lengths or character sets. Make sure your values are compatible with the selected format.

Preview Generated Codes

The Preview panel lets you inspect QR codes and barcodes before generating the output.

• Preview codes automatically when selecting cells.

• Navigate through multiple selected values using the arrows.

• See changes immediately when adjusting QR code size or barcode format.

• Preview labels when Use Labels is enabled.

• See the source cell reference below the preview.

The Preview panel is read-only and does not modify your spreadsheet.

You can enable or disable the Preview panel in Settings.

Output Options

Choose how your generated codes will be saved.

Save to Google Docs™

Creates a Google Docs™ document containing all generated QR codes or barcodes, ready for printing.

Draw Border

Adds a border around table cells in the Google Docs™ document.

Save as PNG Files

Saves each generated QR code or barcode as a separate PNG image file in Google Drive™.

You can enable both Save to Google Docs™ and Save as PNG Files to generate both output formats.

Note: At least one output format must be selected to enable the GENERATE button.

Tip: You can change the output document name and select the output folder in Settings.

Use Bitly

Optionally shorten URLs using your Bitly account before encoding them into QR codes. 

To enable this option, first configure your Bitly Access Token in Settings.

Common Use Cases

• ID cards

• Labels and stickers

• Event badges

• Inventory and asset tracking

• Membership cards

If you want to take it further, explore Templates. Start by generating a few QR codes to get familiar with the basics.