Skip to content
XigQR

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/1001Blue mug
https://example.com/p/1002Green mug
https://example.com/p/1003Red 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

  1. In Excel choose File → Save As and select CSV UTF-8 (Comma delimited). In Google Sheets choose File → Download → Comma-separated values.
  2. 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.
  3. 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

  1. Log in and open Bulk export in the dashboard.
  2. 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:

ProblemWhat happensFix
Empty valueRow skippedRemove blank rows
Too long (over 1,000 characters)Row skippedShorten the value or the link
DuplicateLater copy skippedUsually fine, or remove the repeats
More than 1,000 unique rowsExport refusedSplit 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.
PackPricePer 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$149about $0.30
1,000 credits$249about $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-0002 and 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.

Related tools and pages

More articles