Export check-in data to CSV

After an event ends, you can export all check-ins to a CSV, Excel (.xlsx), or PDF file for archival, reconciliation, or further processing in Excel / Google Sheets. The CSV and Excel files contain full details of each check-in and check-out, including guest, door, time, and sync status.

When to export

Tip

Export the CSV after the event has ended and all offline scans have synced to the server. The exported file will then be complete and accurate.

Steps to export

1. Sign in to the CMS at app.qrs.com.vn.
2. Open the event you want to export.
3. Go to the event’s Analytics section.
4. Open the Export data menu and choose Export CSV, Export Excel, or Export PDF.
5. Download the file — a CSV opens in Excel, Google Sheets, or Numbers; the Excel option downloads a ready-made .xlsx workbook; the PDF option downloads a printable report of the event’s analytics.

Note

The CSV is the flat check-in list described below. The Excel (.xlsx) option downloads a full event workbook with 7 sheets — Summary, Check-in Velocity, Door Breakdown, Scanner Performance, Ticket Tiers, Custom Fields, and Check-ins — so it also carries the figures you see on the Analytics tab. Date and time columns in the workbook are labelled in UTC.

Columns in the CSV file

Each row corresponds to one check-in. The table below lists every column:

Column	Meaning
Guest name	The guest’s full name
Email	The email the guest registered with
Phone	The guest’s phone number (if any)
Ticket tier	The ticket type (e.g. VIP, Standard)
Check-in time	When the guest entered
Check-out time	When the guest left (if check-out is enabled)
Door	The door the guest passed through
Check-in method	How the guest was checked in: QR scan, kiosk, or manual lookup
Scanner	The staff member / device that performed the scan
Sync status	Currently always reads “synced”

Sync status

The Sync status column tells you whether that check-in has been recorded on the server:

Status	Meaning	What to do
Synced	The check-in was successfully recorded on the server	Nothing — the data is safe.

This column currently always reads “synced”. Every check-in is recorded on the server; if an offline-replayed scan arrives for a ticket that already has a check-in for the event, the duplicate is dropped (not stored) and the original check-in stays valid.

Note

Offline scans are cached on the scanner and sync automatically once the network returns. Each offline scan carries a timestamp, so check-in ordering on the server stays correct after sync.

Tip

When the same ticket is scanned twice (e.g. on two devices that are both offline), the system detects the duplicate at the event check-in level, automatically drops the duplicate scan (it is not stored on the server), and keeps the original check-in as valid — you do not need to resolve duplicates by hand.

Tips for working with the data

• Open in Excel / Google Sheets: duplicate the time column if you need to split date and time.
• Filter by door: use Excel’s filter to see entries per individual door.
• Filter by sync status: currently every row is “synced”, so there is no need to filter for unsynced entries.
• Count unique guests: use a pivot table on Guest name or Email to count unique guests.

Tip

Because every check-in is recorded directly on the server (the sync value is always “synced”), you do not need to check sync status after the event has ended.

Export the guest list (CSV / Excel)

Alongside the check-in file, you can also export the full guest list of an event — including guests who never arrived, guests whose invitations have not been sent, and any custom fields you added when building the registration form (for example: company, t-shirt size, an internal customer ID of your own).

Use the file to reconcile the invitation list, send a post-event email, or import it into your accounting CRM.

When to export

• Before the event: to review the invitation list, check for duplicates, or send a reminder.
• After the event: to compare actual door entries against the original invitation list, or to send a thank-you message.

Steps to export

1. Sign in to the CMS at app.qrs.com.vn and open the event.
2. Go to the event’s Guests section.
3. (Optional) Use the search box, the ticket-tier filter or the RSVP status filter to narrow the list to export.
4. Open the Actions menu at the top of the guests table and choose Export.
5. Download the file — it is a CSV file that opens in Excel, Google Sheets, or Numbers.

Note

If you applied a ticket-tier filter, an RSVP status filter or a search query before clicking Export, the downloaded file will only contain the guests matching that filter. Clear the filters to export the entire list.

Columns in the file

Each row is one guest. Beside the default columns (Guest name, Email, Phone, Ticket tier, Companion Of, Invitation status, Checked In, Checked In At, Ticket Link, RSVP Status, RSVP Responded At), the file adds a dedicated column for each custom field — named exactly with the label you set when creating the form question.

Column	Meaning
Name	The guest’s full name
Email	The email the guest registered with
Phone	The guest’s phone number (if any)
Ticket tier	The ticket type (e.g. VIP, Standard)
Companion Of	On a companion’s row: the email of the primary guest they belong to; empty on primary rows and guests without companions
Invitation status	Sent / pending / bounced / cancelled / unsubscribed / waitlisted
Checked In	Yes / No — whether the guest has entered
Checked In At	When the guest checked in
Ticket Link	A direct link to the guest’s ticket page
RSVP Status	Yes / No — the guest’s answer to the RSVP attendance ask; empty when no ask was answered
RSVP Responded At	When the guest last answered the RSVP ask
Custom fields	Each question you added to the form (company, t-shirt size, internal ID…) gets its own column

Note

The Companion Of column holds the primary guest’s email (not their name), which is exactly what the bulk-import wizard matches on — so a file you export can be edited and re-imported with companion links intact.

Tip

Custom-field columns use the exact label you typed when building the form, so non-technical colleagues can recognise them at a glance when opening the file.

Export a single scanner’s activity

In the event’s Scanners section you can download a CSV summarising the recent activity of your scanner fleet — the latest check-ins with guest, ticket tier, door passed, and entry time. It is handy for a quick check that each scanner is on the right door and processing the right volume.

Steps to export

1. Sign in to the CMS at app.qrs.com.vn and open the event.
2. Go to the Scanners section.
3. Click the Export button in the action bar above the scanner list.
4. Download the file — it is a CSV that opens in Excel/Google Sheets.

Caution

This file only contains the recent check-ins the system has recorded, not the full event history. Need the complete entry/exit report? Use the CSV export at the top of this page.

Columns in the file

Column	Meaning
Guest name	The guest who was scanned
Email	The guest’s email
Ticket tier	The guest’s ticket type
Door	The door the guest passed through when scanned
Check-in time	When the guest entered

Note

If the Export button is greyed out, no check-in has been recorded yet. Make sure at least one scanner has successfully scanned a ticket before exporting.

Next steps

Event dashboard

View real-time check-in numbers on the dashboard. See /en/check-in/dashboard/.

Scan states

Understand the check-in states (green/yellow/red/blue). See /en/check-in/reference/scan-states/.