The Scenario
The festival wrapped on Sunday night. Three days, 8,500 scans across four gate points. On Monday morning, the venue operations manager opens a blank Excel workbook and a message from the festival director asking for per-day attendance figures and a list of any passes scanned more than once. The scan data is in Passcreator under the 'FestivalGate2025' app configuration.
The bad version:
- Look for a scan export button in Passcreator's UI — find it returns one gate configuration at a time, each as a separate download.
- Download four CSV files, import them individually into separate worksheets, and spend two hours writing formulas to union them and look for duplicate pass IDs.
- Discover the date-time columns are formatted differently across the four files and spend another hour standardising before any formula works.
The festival director asked for this Monday morning. It's Monday afternoon and you still don't have a number you trust.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to the Passcreator app configuration API, pulls the full scan history, and writes the records into the workbook with the columns and flags you need.
Import the complete scan history for my Passcreator door scanner app configuration into this Excel workbook and flag any duplicate scans for the same pass occurring within 5 minutes
What You Get
- All 8,500 scan records written into the workbook, one row per scan.
- Columns: scan time (consistent format), pass ID, device identifier, scan status.
- All gate configurations included.
- Per-day attendance counts in a summary section.
- Duplicate scans — same pass ID, less than 5 minutes apart — flagged in a dedicated column.
What If the Data Is Not Quite Ready
You only want scans with an "accepted" status
Rejected scans should be excluded from attendance figures but reported separately.
Import all scan records for 'FestivalGate2025'. Split: write accepted scans into the 'Attendance' worksheet and rejected scans into the 'Rejected' worksheet. Calculate per-day attendance from 'Attendance' only.
You need to flag duplicates within a 5-minute window per pass
The gate reader had a connectivity issue and some passes were scanned twice within seconds.
Import all scan records for 'FestivalGate2025'. Flag any row where the same pass ID appears more than once and the time gap between scans is less than 5 minutes. Write these into a 'Suspected Duplicate' column.
You need attendee name alongside the pass ID for each scan row
The 'Attendees' worksheet has pass ID in column D and attendee name in column A.
Import all scan records for 'FestivalGate2025'. Join attendee name from the 'Attendees' worksheet on pass ID. Write all rows into the 'Scans' worksheet with an added 'Attendee Name' column.
Full import, filter, flag, join, and summarise in one shot
The director wants accepted attendance by day, duplicate flags, and attendee names — all by end of Monday.
Import all scan records for 'FestivalGate2025'. Separate accepted and rejected scans into separate worksheets. Flag duplicates within a 5-minute window. Join attendee name from the 'Attendees' worksheet on pass ID. Calculate per-day attendance (excluding flagged duplicates) and write the summary into the 'Summary' worksheet.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull all scan records from your Passcreator gate configuration and flag the duplicates. See also: exporting pass data for campaign audits and the PassCreator integration overview.