How to batch generate QR codes from Excel

Teams that need hundreds of unique QR codes—event tickets, shelf labels, asset tags, or campaign landing pages—should not paste URLs one row at a time. A spreadsheet is the natural source of truth: one row per code, columns for the encoded payload, optional filename, and optional label text for print layouts.

This guide walks through preparing an Excel or CSV file, importing it into a bulk QR code generator, and exporting a ZIP of PNG or SVG files ready for design tools or label printers.

Prepare your spreadsheet

• Column A (or any column): full URL or text to encode—no line breaks inside cells.
• Optional name column: used as the image filename, e.g. booth-042.png.
• Optional label column: short text printed beside the symbol on composite label sheets.
• Use UTF-8 CSV if special characters appear; avoid merged cells and formulas that Excel cannot export as plain values.

Import and map columns

On QRBatch’s home generator, open Excel import, upload your .xlsx file, then choose which column holds the QR content, which column (if any) defines filenames, and which row range to process. A demo template is available in the import dialog so new users can match the expected layout on the first try.

After import, review the textarea preview: each line should match one future QR image. Adjust start/end rows if you only need a subset (for example rows 2–501 skipping the header).

Design, generate, and download

Set size, margin, error correction, colors, and optional logo once—they apply to the whole batch. Click generate; when processing finishes, download the ZIP. Archive the spreadsheet version alongside the ZIP so reprints six months later use the same data.

Common mistakes

• Trailing spaces in URLs that work in Excel but fail on mobile scanners.
• Duplicate filenames overwriting images in the ZIP—use a unique ID column.
• HTTP-only links on HTTPS marketing pages—prefer HTTPS everywhere.
• Editing the sheet after export without regenerating—always pair print runs with a dated export folder.