BatchQRCode

How to generate QR codes from Excel

No add-ins, no formulas, no VBA. Copy the column you want to encode, paste it into BatchQRCode, and download a ZIP of QR images. Takes about a minute.

The short version

Open your Excel or Google Sheets file.
Copy the column with your URLs, IDs, or values. Skip the header row.
Paste into batchqrcode.com.
Choose PNG, JPEG, or SVG. Click Generate.
A ZIP file downloads with one QR code per row.

Open BatchQRCode

Step by step: Excel to QR codes

Step 1: Prepare your spreadsheet

Make sure the values you want to encode are in one column, no merged cells, no formula errors. Common sources:

Product URLs from an inventory sheet
Attendee IDs from an event registration export
Asset tags from an asset tracking sheet
Coupon codes or serial numbers

Step 2: Export or copy the column

Two ways to get the data out:

Copy and paste: Select the cells in your column (skip the header row), copy with Ctrl+C or Cmd+C, then paste directly into BatchQRCode.
Save as CSV: In Excel, go to File, then Save As, then choose CSV (Comma delimited). Then upload the CSV file using the upload area on BatchQRCode.

In Google Sheets: File, then Download, then Comma Separated Values (.csv).

Step 3: Generate in BatchQRCode

Open batchqrcode.com. Paste your values into the text area, or drag your .csv file onto the upload area. Select PNG for standard use, SVG for large-format print, or JPEG for smaller file sizes. Click Generate.

Step 4: Download your ZIP

Your browser generates every QR code locally using WebAssembly. A ZIP file downloads when it is done. Files are named by row number (qr_001.png, qr_002.png, etc.), in the same order as your spreadsheet rows.

Why not use the Excel IMAGE() formula?

Excel has an =IMAGE() formula that can render QR codes inline. The standard approach looks like this:

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

It works, but it sends every URL or value in your sheet to a third-party server to generate the image. For public URLs that is usually fine. For internal systems, employee IDs, or confidential serial numbers, that is a real data exposure.

BatchQRCode generates QR codes entirely in your browser. Your spreadsheet data is never transmitted anywhere. Download the images and use them offline.

Frequently asked questions

Does this work with Google Sheets?

Yes. Copy your column in Google Sheets and paste into BatchQRCode, or download the sheet as CSV and upload the file.

How many rows can I process at once?

There is no limit. Large batches (500+ rows) may take a few seconds. Generation runs in your browser, so there is no server timeout or plan limit to hit.

What if my CSV has multiple columns?

Copy only the column you want to encode. Or open the CSV in a text editor and delete the extra columns before uploading.

Can I name each QR code file after its row value?

Not currently. Files are named by row number (qr_001.png). The order matches your spreadsheet exactly, so the CSV works as a lookup reference.