Skip to main content

Batch Export

Generate hundreds or thousands of QR codes at once from a CSV file. Perfect for events, inventory, product catalogs, and marketing campaigns.

What is Batch Export?​

Batch Export allows you to:

  • Generate multiple QR codes from a single CSV file
  • Apply custom frames and text to each QR code
  • Use different data for each code (URLs, vCards, text, etc.)
  • Customize filenames for each exported image
  • Export all codes in one ZIP file
  • Apply same encryption password to all codes (optional)

Quick Start​

  1. Prepare a CSV file with your data
  2. Click Create tab → Batch Export button
  3. Upload your CSV file
  4. Preview and adjust settings
  5. Click Export All as PNG/JPG/SVG
  6. Download ZIP file with all QR codes

CSV File Format​

Basic Structure​

The CSV file must have a header row with column names:

data
https://example.com/product1
https://example.com/product2
https://example.com/product3

Available Columns​

Column NameRequiredDescriptionExample
data✅ YesURL or text datahttps://example.com
frametextNoCustom frame textProduct ABC
filenameNoCustom export filenameproduct-abc
fontfamilyNoFrame text fontArial

Example CSV Files​

Simple URLs​

data
https://scottsdalemint.com
https://dealers.scottsdalemint.com
https://qr-generator.scottsdalemint.com

URLs with Frame Text​

data,frametext
https://scottsdalemint.com,Retail Store
https://dealers.scottsdalemint.com,Dealer Portal
https://qr-generator.scottsdalemint.com,QR Generator

Complete Example with All Fields​

data,frametext,filename,fontfamily
https://example.com/product-001,Gold Bar 1oz,gold-bar-1oz,Roboto
https://example.com/product-002,Silver Coin,silver-coin,Roboto
https://example.com/product-003,Platinum Round,platinum-round,Arial

vCard Batch (Business Cards)​

firstname,lastname,org,position,phonework,email,website,address,city,state,country,postalcode,frametext,filename
John,Doe,Scottsdale Mint,CEO,555-0100,[email protected],scottsdalemint.com,123 Main St,Scottsdale,AZ,USA,85251,John Doe CEO,john-doe
Jane,Smith,Scottsdale Mint,CFO,555-0101,[email protected],scottsdalemint.com,123 Main St,Scottsdale,AZ,USA,85251,Jane Smith CFO,jane-smith

Creating Your CSV File​

Using Microsoft Excel​

  1. Open Excel
  2. Enter column headers in first row (data, frametext, filename)
  3. Enter your data in rows below
  4. File → Save As → Choose CSV (Comma delimited) (*.csv)
  5. Click Save

Using Google Sheets​

  1. Open Google Sheets
  2. Enter column headers and data
  3. File → Download → Comma Separated Values (.csv)
  4. Upload to QR Generator

Using Text Editor​

Create a file with .csv extension:

data,frametext
https://example.com,Product 1
https://example.com,Product 2

Important: Use commas (,) as separators, not semicolons or tabs.

Template Files​

Pre-made CSV templates are available in the app:

TemplateDescriptionUse Case
Simple Batch2 URL columnsBasic URL list
With Frame Text6 URLs + framesProduct labels
vCard SampleContact cardsBusiness cards, badges
Multi-line FrameComplex framesEvents, detailed info
With FilenamesCustom namingOrganized exports

Download templates:

  1. Click Batch Export
  2. Click Example CSV dropdown
  3. Choose a template
  4. Click to download
  5. Edit in Excel/Google Sheets
  6. Upload back to generator

Batch Export Process​

Step 1: Upload CSV​

  1. Click Create tab
  2. Click Batch Export button
  3. Click Upload CSV or drag-and-drop file
  4. App validates your CSV structure

Step 2: Preview​

After upload, you'll see:

  • ✅ Total rows detected: Number of QR codes to generate
  • 📊 Preview: First row's QR code preview
  • ⚠️ Validation errors: Missing columns or invalid data

Preview Controls:

  • Use ◀️ ▶️ arrows to preview different rows
  • Current row number shows (e.g., "1 / 100")
  • QR code updates live as you navigate

Step 3: Configure Settings​

Adjust global settings that apply to all QR codes:

Style Settings:

  • Preset selection
  • Dot colors and shapes
  • Corner styles
  • Background color

Frame Settings (if CSV has frametext column):

  • Enable/disable frames
  • Frame position (top, bottom, left, right)
  • Frame colors and styling
  • Font family (if specified in CSV)

Encryption (optional):

  • Enable encryption
  • Enter password (same for all codes)

Error Correction:

  • Choose level (L, M, Q, H)
  • Higher = more reliable but larger

Step 4: Export​

  1. Choose format: PNG, JPG, or SVG
  2. Click Export All as [format]
  3. Progress bar shows: "Creating QR codes... 5 / 100"
  4. When complete, ZIP file auto-downloads

Step 5: Extract ZIP​

  1. Locate downloaded qr-codes.zip
  2. Extract/unzip the file
  3. Find all your QR code images inside

Filename Generation​

The app generates filenames automatically using this priority:

Priority Order​

  1. filename column (if provided) — Highest priority
  2. frametext column (if no filename) — Second priority
  3. data column (if neither above) — Auto-generated from data
  4. Fallback — qr-code-{index} if all else fails

Examples​

data,frametext,filename
https://example.com,Product A,custom-name-a
https://example.com,Product B,
https://example.com,,

Results in:

  • custom-name-a.png (from filename column)
  • product-b.png (from frametext, sanitized)
  • example-com.png (from data, sanitized)

Filename Sanitization​

Special characters are replaced:

  • Spaces → underscores
  • Special chars (/, \, :, *, ?, ", <, >, |) → removed
  • Lowercase conversion
  • Max 255 characters

Example:

  • Input: Product #1 (Special!)
  • Output: product_1_special.png

Advanced Features​

Encrypted Batch Export​

Generate encrypted QR codes in bulk:

  1. Upload CSV file
  2. Enable Encrypt QR code in settings
  3. Enter one password (applies to all)
  4. Export as usual

Use case: Conference badges with encrypted contact info

  • All badges use same password
  • Share password with staff only
  • Public can't read attendee details

Custom Fonts​

Specify fonts for frame text:

data,frametext,fontfamily
https://example.com,Bold Title,Roboto Bold
https://example.com,Elegant Text,Playfair Display
https://example.com,Modern Sans,Inter

Available fonts:

  • System fonts (Arial, Times New Roman, etc.)
  • Google Fonts (loads automatically)
  • Custom uploaded fonts (if configured)

Variable Frame Positions​

While not in CSV, you can set frame position globally:

  • Top (default for horizontal text)
  • Bottom
  • Left (for vertical text)
  • Right (for vertical text)

All QR codes in batch use same frame position.

Performance & Limits​

Processing Speed​

Batch SizeEstimated TimeNotes
1-50 codes5-15 secondsVery fast
51-200 codes30-60 secondsMedium
201-500 codes2-3 minutesSlower, shows progress
501-1000 codes5-8 minutesMay need tab to stay open
1000+ codes10+ minutesKeep tab open, don't navigate away

Tips for large batches:

  • Keep browser tab open and active
  • Don't navigate away during export
  • Close other tabs to free memory
  • Use faster export format (SVG < PNG < JPG)
  • Maximum rows: 10,000 (technical limit)
  • Practical maximum: 1,000-2,000 rows
  • Optimal batch size: 100-500 rows

For larger needs, split into multiple CSV files.

Common Use Cases​

Product Labels (E-commerce)​

data,frametext,filename
https://store.com/product/gold-bar-1oz,1 oz Gold Bar - #GB001,gb001
https://store.com/product/silver-coin-eagle,1 oz Silver Eagle - #SE001,se001
https://store.com/product/platinum-round,1 oz Platinum Round - #PR001,pr001

Result: Product labels with QR codes linking to product pages

Event Badges​

firstname,lastname,org,position,email,frametext,filename
John,Doe,Acme Corp,CEO,[email protected],John Doe - CEO,badge-john-doe
Jane,Smith,Tech Inc,CTO,[email protected],Jane Smith - CTO,badge-jane-smith

Result: Attendee badges with encrypted vCard QR codes

Marketing Campaign​

data,frametext
https://campaign.com?utm_source=qr&utm_campaign=spring,Spring Sale 2024
https://campaign.com?utm_source=qr&utm_campaign=summer,Summer Promo
https://campaign.com?utm_source=qr&utm_campaign=fall,Fall Discount

Result: Trackable QR codes for different campaigns

Inventory Management​

data,frametext,filename
INV-2024-001,Gold Bar Storage A1,inv-001
INV-2024-002,Silver Coins Storage B2,inv-002
INV-2024-003,Platinum Rounds Storage C3,inv-003

Result: Internal inventory tracking labels

Troubleshooting​

CSV Upload Fails​

Error: "Invalid CSV format"

  • Ensure file is saved as .csv (not .xlsx or .xls)
  • Check for comma separators (not semicolons)
  • Verify header row exists
  • Remove any empty rows at bottom

Error: "Missing required columns"

  • CSV must have data column
  • For vCards, must have firstname and lastname
  • Check spelling of column names (case-sensitive)

Export Stops/Fails​

Browser freezes during export

  • Reduce batch size (try 100 rows first)
  • Close other browser tabs
  • Use faster computer if available
  • Try SVG format (fastest)

ZIP file not downloading

  • Check browser download settings
  • Disable popup blockers
  • Check disk space
  • Try different browser

QR Codes Look Wrong​

All QR codes are identical

  • Check CSV has different data in each row
  • Verify data column has unique values
  • Review preview before exporting

Frame text missing

  • Ensure CSV has frametext column
  • Check frame is enabled in settings
  • Verify column name spelling

Filenames are generic

  • Add filename column to CSV
  • Or use frametext for auto-naming
  • Check filename priority order

Best Practices​

  1. Test First — Upload CSV with 5-10 rows to test
  2. Preview All — Use arrows to check multiple rows before export
  3. Use Filenames — Add filename column for organized exports
  4. Split Large Batches — Keep under 500 rows for reliability
  5. Keep Originals — Save CSV file for future re-generation
  6. Version Control — Include date in filename: qr-batch-2024-06-03.csv
  7. Document Passwords — If encrypted, note password in secure location
  8. Test Scanning — Scan a few codes after printing to verify

Next Steps​