How to Create QR Codes in Google Sheets & Excel (Bulk Guide, 2026)

Spreadsheets are where most bulk QR code projects start. You have a list of URLs, product SKUs, inventory IDs, or contact records sitting in Google Sheets or Excel, and you need a QR code for each row. The question is how to get from a column of data to a column of scannable codes without copying and pasting one at a time.

There are three practical approaches: using a formula inside Google Sheets, installing a Google Workspace add-on, or uploading your spreadsheet to a dedicated QR code platform like QRLynx Bulk Generator. Each method works, but they differ significantly in flexibility, tracking, design options, and scale. This guide walks through all three so you can pick the right workflow for your project.

If you are new to QR codes in general, start with our complete guide to creating QR codes first. If you need QR codes for enterprise asset tracking, warehouse inventory, or IT equipment labels, see our enterprise asset tracking guide for that specific workflow.

Method 1: The IMAGE + ENCODEURL Formula in Google Sheets

Google Sheets can generate QR codes natively using the IMAGE function combined with a QR code API. The most common approach uses the Google Charts API or the QuickChart API to render a QR code image directly inside a cell. No add-on or external software is required.

The formula pattern is straightforward. If your URL is in cell A2, you place this formula in the adjacent cell:

=IMAGE("https://quickchart.io/qr?text="&ENCODEURL(A2)&"&size=200")

This formula does three things: it takes the value from cell A2, URL-encodes it so special characters do not break the request, and passes it to the QuickChart QR API, which returns a PNG image. The IMAGE function renders that image inside the cell.

You can also use the legacy Google Charts API, which still works as of 2026:

=IMAGE("https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl="&ENCODEURL(A2))

According to Google Sheets IMAGE function documentation, the IMAGE function accepts any publicly accessible URL that returns an image. The QR API returns a PNG, which Sheets renders inline.

The ENCODEURL function is important because URLs often contain characters like ampersands, question marks, and equals signs that would break the API request if left unencoded. The ENCODEURL documentation confirms that it percent-encodes all reserved characters for safe use in URLs.

Advantages of the formula method

• No installation required — works in any Google Sheets document immediately
• Free and unlimited — no cost per code
• Automatically updates when the source cell changes
• Easy to copy down a column for hundreds of rows

Limitations of the formula method

• Generates static QR codes only — you cannot change the destination after printing
• No scan tracking or analytics
• No design customization — the codes are plain black and white squares
• No logo embedding or brand colors
• Images are rendered at low resolution inside cells
• Exporting high-quality images requires extra steps
• Depends on an external API — if the API goes down, images break

The formula method is ideal for internal use cases where you need simple, disposable QR codes quickly: inventory labels, internal links, test batches, or personal projects. For anything customer-facing, branded, or requiring analytics, you will need a more capable approach.

Method 2: Google Workspace Add-ons for QR Codes

Google Workspace Marketplace offers several QR code add-ons that integrate directly into Google Sheets. These add-ons provide a graphical interface for generating QR codes from selected cells, often with more options than the raw formula method.

To install an add-on, go to Extensions > Add-ons > Get add-ons in Google Sheets and search for "QR code." Popular options include QR Code Generator, QR Monkey for Sheets, and Awesome QR. Most offer a free tier with basic generation and a paid tier for bulk operations or design features.

How add-ons typically work

1. Install the add-on from the Google Workspace Marketplace
2. Select the cells containing the data you want to encode
3. Open the add-on sidebar and choose your QR code settings
4. Click generate — codes appear in adjacent cells or as downloadable images

Advantages of add-ons

• More user-friendly than raw formulas
• Some offer basic design options (colors, size presets)
• Can generate downloadable image files directly
• Often include batch generation for selected ranges

Limitations of add-ons

• Still generate static QR codes — no tracking or analytics
• Free tiers are often limited to a small number of codes
• Add-ons require granting permissions to third-party developers
• Design options are typically basic compared to dedicated platforms
• No logo embedding, custom shapes, or advanced branding
• Cannot create dynamic QR codes that update after printing

Add-ons sit in a middle ground. They are easier than formulas for non-technical users and can handle modest batches, but they do not solve the fundamental limitations of spreadsheet-generated QR codes: no tracking, no dynamic updates, and limited design. For teams that need those capabilities, a dedicated QR platform is the better path.

Method 3: Using QRLynx Bulk Generator with Spreadsheet Data

For teams that need dynamic QR codes with tracking, branding, and bulk generation from spreadsheet data, the QRLynx Bulk Generator provides a complete workflow. You prepare your data in Google Sheets or Excel, export it as a CSV file, upload it to QRLynx, and generate hundreds of fully customized, trackable QR codes in a single batch.

The bulk generation workflow follows five steps:

1. Prepare your CSV — Export your Google Sheets or Excel file as CSV. Each row needs at minimum a destination URL. Optional columns include QR code name, folder assignment, and metadata.
2. Upload to QRLynx — Go to QR Codes > Bulk Create in your dashboard and upload the CSV file.
3. Preview and configure — Review the parsed data, choose your QR code type, and configure design settings (colors, logo, shape, error correction).
4. Generate — QRLynx creates all codes in a single batch, each with its own short URL and tracking.
5. Download — Export all codes as a ZIP file containing individual PNG or SVG images, ready for print or digital use.

Every code created through bulk generation is a dynamic QR code. That means you can change the destination URL after printing, view scan analytics (location, device, time), set expiration rules, add password protection, and apply smart redirect rules. None of those capabilities are available with the spreadsheet formula or add-on methods.

Bulk generation is available on QRLynx Business plans (up to 100 codes per batch) and Enterprise plans (up to 500 codes per batch). See pricing details for a full comparison.

Can You Generate QR Codes in Excel?

Microsoft Excel does not have a built-in QR code formula equivalent to the Google Sheets IMAGE function. However, there are several workarounds that Excel users can use to generate QR codes from spreadsheet data.

Excel for Microsoft 365 (Desktop)

The desktop version of Excel supports add-ins from the Microsoft Office Add-in Store. Search for "QR code" in the add-in store (Insert > Get Add-ins) to find options like QR4Office or QR Code Generator. These work similarly to Google Sheets add-ons: select cells, configure settings, and generate codes.

Excel with VBA Macros

Advanced users can write VBA macros that call a QR code API and insert the resulting images into cells. This approach is powerful but requires programming knowledge and macro-enabled workbooks. It is suitable for IT teams building internal tools but not practical for casual users.

Excel Online

Excel Online (the browser version) supports a limited set of add-ins. Some QR code add-ins that work in the desktop version may also work online, but compatibility varies. The formula-based approach from Google Sheets does not directly translate because Excel does not have an equivalent IMAGE function that renders external URLs as inline images.

The practical Excel workflow

For most Excel users, the fastest path is to export the spreadsheet as CSV and upload it to a QR code generator. This avoids the limitations of Excel's add-in ecosystem and gives you access to features like custom design, dynamic codes, and scan tracking. If you are working with inventory, product catalogs, or asset lists in Excel, the QRLynx Bulk Generator accepts CSV exports from Excel directly.

Formula vs Add-on vs QRLynx Bulk: Comparison Table

Choosing between the three methods depends on your use case, volume, and whether you need tracking or branding. Here is a side-by-side comparison:

The formula method is the fastest way to get started. It costs nothing and works immediately. But the moment you need to track scans, update destinations, add your logo, or produce print-quality images, you outgrow the formula approach. Add-ons improve the user experience but do not solve the tracking or design gap. A dedicated bulk generator like QRLynx fills all those gaps at the cost of a subscription.

Common Use Cases: When to Use Each Method

The best method depends on what you are building and who will scan the codes. Here are the most common scenarios and the recommended approach for each.

Internal inventory labels

If you need QR codes on warehouse shelves, office equipment, or storage bins that link to an internal spreadsheet or database record, the Google Sheets formula method works well. These codes are scanned by your own team, do not need branding, and rarely need updating. See our enterprise asset tracking guide for detailed workflows.

Product packaging and marketing materials

Customer-facing QR codes on packaging, flyers, posters, or retail displays need to look professional, load reliably, and provide scan data. Use the QRLynx Bulk Generator to create branded dynamic codes with tracking. If you need to change the destination URL after printing (for seasonal campaigns, A/B tests, or product page updates), dynamic codes are essential.

Event badges and registration

Conferences, trade shows, and workshops often need a unique QR code per attendee. Export your registration list from Google Sheets as CSV, upload to QRLynx, and generate all codes at once. Each badge gets a unique scannable code linked to the attendee's profile or check-in page.

Restaurant menus and table service

A single restaurant might need 20 to 50 identical menu QR codes for table tents, plus unique codes for different locations or promotions. The formula method can handle prototyping, but production codes should be dynamic so you can update the menu URL without reprinting.

Real estate listings

Agents managing multiple property listings can keep a Google Sheet of listing URLs and generate QR codes for each property sign, flyer, and brochure. Dynamic codes let you redirect the QR code to a new listing when the property sells, reusing the same physical sign.

Educational materials and classrooms

Teachers creating QR scavenger hunts, resource sheets, or assignment links can use the Google Sheets formula for quick, free generation. For school-wide deployments or recurring use, a dedicated platform provides better management and tracking.

Tips for Printing QR Codes Generated from Spreadsheets

Generating QR codes is only half the job. Printing them correctly determines whether they actually scan in the real world. Here are the most important print considerations when working with spreadsheet-generated codes.

Size matters

The minimum recommended print size for a QR code is 2 cm by 2 cm (about 0.8 inches) for close-range scanning. For posters, signs, or anything scanned from more than an arm's length, scale up proportionally. Our QR code size guide covers the exact calculations for different scanning distances.

Resolution and export quality

QR codes generated by the IMAGE formula in Google Sheets are rendered at the resolution specified in the URL parameter (e.g., size=200 means 200x200 pixels). For print, you want at least 300 DPI, which means a 200px image only prints cleanly at about 1.7 cm. Increase the size parameter to 600 or higher for print use, or export as SVG from a dedicated tool.

Contrast and color

QR codes require strong contrast between the foreground modules and background. Plain black on white is the safest choice. If you use custom colors (available through QRLynx but not through the formula method), keep the foreground dark and the background light. Avoid inverting colors or using low-contrast combinations.

Quiet zone

Every QR code needs a white border (called the quiet zone) around it. The minimum is four modules wide. When placing QR codes on busy backgrounds or near text, ensure this margin is preserved. Cropping too close to the code pattern can prevent scanning.

Always test before printing at scale

Before printing 500 labels or 1,000 flyers, test-scan at least five codes from the actual printed material using multiple devices. Test in the lighting conditions where the codes will be used. This single step prevents costly reprints.

Advanced: Customizing the QR Code Formula

The basic IMAGE formula can be extended with additional API parameters for more control over the generated QR codes.

Changing the size

Adjust the size parameter to control resolution. For the QuickChart API: =IMAGE("https://quickchart.io/qr?text="&ENCODEURL(A2)&"&size=400") generates a 400x400 pixel image. Larger sizes produce sharper codes but may slow down your spreadsheet if you have hundreds of rows.

Adding error correction

QR codes support four levels of error correction: L (7%), M (15%), Q (25%), and H (30%). Higher error correction means the code can still scan even if partially damaged or obscured. Use: =IMAGE("https://quickchart.io/qr?text="&ENCODEURL(A2)&"&ecLevel=H&size=300"). Level H is recommended if you plan to print on surfaces that may get scratched or dirty.

Setting margins

Control the quiet zone with the margin parameter: =IMAGE("https://quickchart.io/qr?text="&ENCODEURL(A2)&"&margin=2&size=300"). The default margin is usually 4 modules. Reducing it saves space but ensure you maintain at least 2 modules for reliable scanning.

Encoding different data types

The formula is not limited to URLs. You can encode any text, including Wi-Fi credentials, vCard contact information, email addresses, or plain text messages. For Wi-Fi, the format is: WIFI:T:WPA;S:NetworkName;P:Password;;. Place this string in your data column and the formula generates a scannable Wi-Fi QR code.

For encoding structured data like vCards or calendar events, the text strings can be long and complex. At that point, consider using a dedicated QR code generator that handles formatting automatically rather than constructing raw strings in spreadsheet cells.

When to Move Beyond Spreadsheet QR Codes

The spreadsheet formula and add-on methods are excellent starting points. They are free, fast, and require no external tools. But there are clear signals that indicate you have outgrown spreadsheet-based generation:

• You need to track scan data. If knowing how many people scanned each code, from where, and on what device matters to your project, you need dynamic QR codes with analytics.
• You need to update destinations after printing. Static QR codes are permanent. Once printed, the encoded URL cannot change. Dynamic codes let you redirect without reprinting.
• You need branded codes. Customer-facing materials look more professional with custom colors, your logo, and a consistent design language. The formula method produces only plain black and white squares.
• You are managing more than 50 codes. Spreadsheet performance degrades with hundreds of IMAGE formula calls. A dedicated platform handles bulk generation more reliably.
• You need print-ready exports. Getting high-resolution PNG or SVG files from spreadsheet-generated codes requires awkward workarounds. Dedicated tools provide direct download in multiple formats.
• You are working with a team. Spreadsheet QR codes have no access controls, folder organization, or shared dashboards. A platform like QRLynx provides team workspaces, folder management, and role-based access for collaborative QR code programs.

The transition is straightforward: export your spreadsheet data as CSV, upload it to QRLynx Bulk Generator, and you immediately gain tracking, design customization, and dynamic management for every code in the batch. Your existing spreadsheet becomes the data source, and the platform handles everything the formula cannot.

Frequently Asked Questions About Spreadsheet QR Codes

Before diving into the full FAQ below, here are quick answers to the most common questions teams ask when generating QR codes from Google Sheets and Excel.

Can I track scans from QR codes generated in Google Sheets? No. The IMAGE formula creates static QR codes that encode a URL directly. There is no redirect layer, so no scan data is collected. For tracking, you need dynamic QR codes from a platform like QRLynx.

Do I need to pay for a QR code add-on? Not necessarily. The IMAGE formula is completely free and works without any add-on. Add-ons provide a friendlier interface and sometimes better export options, but the free formula method handles most basic use cases.

Can I use this method for thousands of QR codes? Technically yes, but Google Sheets performance slows significantly with hundreds of IMAGE formula calls because each one makes an external API request. For batches over 100 codes, a dedicated bulk generator is more reliable and faster.