QR Code Guides
How to Create QR Codes in Bulk From Excel or CSV
Turn a spreadsheet column of links or IDs into hundreds of QR codes. Prepare your sheet, export a clean CSV, validate it, and download one ZIP, with the pitfalls that trip up most first attempts.
By XigQR Team · Published
If you need a QR code for every product, table, asset tag or handout, making them one by one is slow and error-prone. If the data already lives in a spreadsheet, you can create them all at once. This guide takes you from a messy Excel sheet to a ZIP of numbered QR codes, including the CSV mistakes that cause most failed first attempts.
What bulk generation does, and what it does not
XigQR's bulk export takes a list of up to 1,000 unique values, one per row, and creates one QR code for each. The values can be links or plain text. You need a free account. You get a single ZIP containing a numbered image for every code and a manifest.csv that maps each file name back to its content.
Bulk codes are static: each one contains its value directly, so it works independently of XigQR. For structured types such as Wi-Fi or vCard, use the templates, or supply the finished text string as the value. Bulk export does not merge data into a design template, add per-row logos or create dynamic codes.
Step 1: Lay out your sheet
Keep it simple. Use one column for the content you want in the QR code, and optionally a header in the first row.
| A (header: url) | B (your own reference, optional) |
|---|---|
| https://example.com/p/1001 | Blue mug |
| https://example.com/p/1002 | Green mug |
| https://example.com/p/1003 | Red mug |
XigQR looks for a header named content, url, text, data or link and uses that column. If there is no such header, it uses the first column. The safest layout is a file with only the content column, which avoids any confusion about delimiters.
Step 2: Build the values with a formula (optional)
If your sheet has IDs and you need full links, build them with a formula instead of typing. In Excel or Google Sheets, with an ID in column A and a base address you control:
="https://example.com/p/"&A2
Fill the formula down, then copy the column and paste as values, so the CSV contains the final text rather than formulas. Add tracking parameters in the same way if you use them, for example &"?utm_source=label".
Step 3: Clean the data
- Remove blank rows and stray spaces. Leading and trailing spaces are trimmed, but blank rows are reported as problems.
- Remove duplicates. Repeated values are dropped automatically so they are not created, or charged, twice, but it helps to know about them. In Excel, use Data → Remove Duplicates.
- Keep values short. Each value can be up to 1,000 characters, but shorter values produce simpler, easier-to-scan codes. Long tracking URLs are the usual cause of dense, fragile codes.
- Protect IDs from Excel's formatting. Excel turns long numbers into scientific notation (1.23E+15) and drops leading zeros. Format the column as Text before you enter IDs, or build full links as above.
- Check a handful by hand. Open five links from the list in a browser before you generate hundreds.
Step 4: Save as CSV
- In Excel choose File → Save As and select CSV UTF-8 (Comma delimited). In Google Sheets choose File → Download → Comma-separated values.
- If your sheet has several columns, check the delimiter. Some regional settings save CSV files with semicolons instead of commas. If that happens, save only the content column (a single column has no delimiter), or change the setting.
- Values containing commas, such as a URL with commas in it, are wrapped in quotes by Excel automatically. Leave the quotes.
Step 5: Upload and validate
- Log in and open Bulk export in the dashboard.
- Upload the CSV (or paste one value per line) and press Check my list.
The check reports how many codes will be created and lists problem rows by line number:
| Problem | What happens | Fix |
|---|---|---|
| Empty value | Row skipped | Remove blank rows |
| Too long (over 1,000 characters) | Row skipped | Shorten the value or the link |
| Duplicate | Later copy skipped | Usually fine, or remove the repeats |
| More than 1,000 unique rows | Export refused | Split the file |
Nothing is created, and nothing is charged, at the checking stage.
Step 6: Choose your export
- Free: PNG files with the XigQR frame and footer. This is ideal for checking that your data and layout work. It costs no credits.
- Watermark-free (credits): PNG, SVG or PDF without the frame, at a size you choose up to 4096 px. This uses one credit per unique QR code. Codes whose content you have already unlocked on your account cost nothing extra.
| Pack | Price | Per QR code |
|---|---|---|
| 1 QR code | $1 | $1.00 |
| 10 credits | $7 | $0.70 |
| 50 credits | $25 | $0.50 |
| 100 credits | $39 | $0.39 |
| 500 credits | $149 | about $0.30 |
| 1,000 credits | $249 | about $0.25 |
Packs are one-time purchases, not subscriptions, and credits do not expire. Current prices are always on the pricing page. If you do not have enough credits for the export, nothing is created and nothing is charged, and you are told how many are needed.
Step 7: Download and use the ZIP
When the job finishes, download the ZIP. It contains:
qr-0001,qr-0002and so on: one numbered file per code, in the order of your valid rows.manifest.csv: each file name and the content it encodes. Use it to match codes to your products or assets, for example with a lookup in your spreadsheet.errors.txt: only if a row could not be rendered, with the row number.
Rename or place files with a lookup against the manifest rather than relying on row order, especially if some rows were skipped as duplicates or empty.
If an export is interrupted
Large exports run in the background, one code at a time, and write the ZIP to disk, so they do not need to hold everything in memory. If a job stops part-way, press Retry on the export. Credits are reserved when the job is created and the unlocked codes stay unlocked, so a retry does not charge again.
Print and label tips
- Pick SVG or PDF for label printers and layout software so you can scale without blur.
- Test a handful of printed labels on the real material before printing the lot. See the printing guide.
- Print a human-readable ID next to each code for the day a label is scuffed.
Examples of where bulk codes earn their keep: manufacturing and asset labels, event tables and signage and per-product shelf codes. The overview is on the bulk generation page.
Frequently asked questions
How many QR codes can I create at once?
Up to 1,000 unique rows per export. Split larger lists into several files.
Can I upload an .xlsx file directly?
Not currently. Save it as CSV first, or paste the column into the text box.
Are duplicates charged twice?
No. Duplicate values inside the file are removed, and content you have already unlocked on your account does not use another credit.
Can each code have a different logo or color?
No. Bulk exports use the default design. Customized designs are created one at a time from the generator.
Can I track scans for bulk codes?
Bulk codes are static, so scans are not counted. For per-placement scan counts, create dynamic codes individually; see Dynamic vs Static QR Codes.
Start your first bulk export
Log in, open Bulk export and run a free check on your list. Or read about bulk generation before you start.
Creating and previewing QR codes is free. Free downloads are PNG files with a small XigQR frame and footer. A one-time payment (from $1 per QR code, with credit packs for more) unlocks watermark-free PNG, SVG and PDF exports of that QR code. No subscription.
Create your QR code
Preview it free in seconds. Download with XigQR branding, or unlock watermark-free files with a one-time payment.