You have an Excel file with 300 product URLs, employee contacts, or asset links. You need a QR code image for each row — named, organized, and ready to print. Most tools make you convert to CSV first. At qree.app, you upload your .xlsx file directly.
The Quick Version
- Add
filenameandtitlecolumns to your spreadsheet - Upload the .xlsx file at qree.app/bulk
- Click Generate
- Download ZIP with all QR code images
Each QR code is dynamic — you get scan analytics on every single one and can change the destination URL later without reprinting.
Step 1: Prepare Your Spreadsheet
Open your Excel file. You probably have something like this:
| URL |
|---|
| https://shop.example.com/product/001 |
| https://shop.example.com/product/002 |
| https://shop.example.com/product/003 |
Add two columns to the left:
| filename | title | url |
|---|---|---|
| product-001 | Wireless Headphones | https://shop.example.com/product/001 |
| product-002 | USB-C Cable | https://shop.example.com/product/002 |
| product-003 | Phone Stand | https://shop.example.com/product/003 |
filename — determines the QR image filename in the ZIP (e.g., product-001.png). Use only letters, numbers, and hyphens. No spaces, no special characters.
title — the label shown in your dashboard. Can be anything readable: product name, person's name, location.
The remaining columns depend on your QR type:
| Your data | QR type | Required columns |
|---|---|---|
| Website links | URL | filename, title, url |
| Employee contacts | vCard | filename, title, first_name, last_name, email, phone, company, job_title |
| WiFi networks | WiFi | filename, title, ssid, password, encryption |
| Serial numbers, codes | Text | filename, title, text |
Step 2: Upload Directly
Go to qree.app/bulk (free account required). Select your QR type, then upload your .xlsx file. No need to export as CSV — the bulk generator reads Excel files natively.
You can also upload .csv if you prefer. Both formats work identically.
Choose image format (PNG or SVG) and size (200–1000px), then click Generate.
Step 3: Download and Use
Download the ZIP file. Inside you'll find:
- All QR code images, named by your
filenamecolumn - A
_mapping.csvfile linking each filename to its short URL and destination
filename,title,short_url,original_url
product-001,Wireless Headphones,https://qree.app/abc1234,https://shop.example.com/product/001
product-002,USB-C Cable,https://qree.app/xyz7890,https://shop.example.com/product/002
Send the QR images to your designer, print team, or use them directly in labels, badges, or packaging.
Step 4: Track Scans
Every QR code from your spreadsheet appears in your dashboard, grouped under the batch name. Click any QR to see:
- Total scans and unique visitors
- Countries and cities
- Devices and browsers
- Scan timeline
This data is available for each individual QR code — not just the batch as a whole.
Excel Tips
Keep it simple. Use the first sheet in your workbook. The generator reads only the first sheet.
No merged cells. Unmerge all cells before uploading. Merged cells produce empty or misaligned rows.
Watch for formulas. If your URLs come from formulas (CONCATENATE, TEXTJOIN), that's fine — the generator reads the calculated values. But double-check that the results are correct.
Clean up empty rows. Delete any empty rows below your data. Some Excel files have thousands of "empty" rows that are actually formatted.
Phone numbers as text. Excel likes to drop leading zeros from phone numbers. Format the phone column as Text before entering numbers, or prefix with an apostrophe ('): '+31612345678.
Max 500 rows per batch. For larger spreadsheets, split into multiple batches — they all appear in your dashboard.
Why Not Generate QR Codes Inside Excel?
You can create QR codes within Excel using the IMAGE function or add-ins (see our guide to QR codes in Excel). But these approaches have limitations:
- No downloadable image files. The QR codes live inside the spreadsheet — you can't easily extract them as PNG/SVG files for print.
- No tracking. Excel-generated QR codes are static. No scan analytics, no way to change the URL later.
- Quality issues. Formula-based QR codes depend on external APIs and are limited to basic black-and-white output.
- Scale. Add-ins often struggle with hundreds of codes, and the spreadsheet becomes slow.
Uploading your Excel file to a dedicated bulk generator gives you trackable QR codes, downloadable image files, and a dashboard to manage them.
Print Tips
Resolution. For product labels and stickers, use SVG — it scales perfectly to any size. If you need PNG, generate at 600px or higher.
Minimum size. Don't print QR codes smaller than 2×2 cm. Smaller codes are hard to scan, especially in poor lighting.
Test before mass printing. Generate 5 QR codes, print them at your target size, and scan each one. Confirm the redirect works and the analytics register.
Get Started
Upload your Excel file at qree.app/bulk and generate hundreds of trackable QR codes in minutes. XLSX and CSV both supported — no conversion needed.