How to bulk extract QR code images

📘 Guide: Bulk Generate QR Code Images Using EventNook QR Generator

EventNook stores a QR Code ID for each attendee. You can turn these IDs into full QR images using this URL format:

https://qr.evnk.co/qr/get?v=QR_ID_HERE

With Google Sheets or Excel, you can generate hundreds of QR images in seconds.

---

✅ 1. Export the Attendee List from EventNook

1. Log in to EventNook Admin

2. Go to Manage → Report → Attendees

3. Click Export to download CSV/Excel

4. Ensure the export includes the TicketCode (QR / Barcode) field

---

✅ 2. Generate QR Code Images Automatically

If the QR ID is in column A, use this exact formula:

=IMAGE("https://qr.evnk.co/qr/get?v=" & A2)

How to use it:

1. Insert a new column next to your QR ID column

2. In the first row (e.g., B2), paste:

   =IMAGE("https://qr.evnk.co/qr/get?v=" & A2)

3. Drag the fill handle down to apply to ALL rows

4. Each row will automatically show a real QR code image

Example:

A (QR ID)	B (QR Code Image)
12345ABC	(QR Image)
X9F88ZK	(QR Image)
85HSHQ33	(QR Image)

---

✅ 3. Generate Only QR Links (If You Don’t Need Images)

For Excel or Google Sheets:

="https://qr.evnk.co/qr/get?v=" & A2

This produces a list of clickable QR image URLs you can download or embed elsewhere.

---

🟦 Final Summary

Task	Method
Bulk QR images	=IMAGE("https://qr.evnk.co/qr/get?v=" & A2)
Bulk QR URLs	="https://qr.evnk.co/qr/get?v=" & A2
Data source	Export attendee list from EventNook