How to Export QR Code Leads to CSV for Excel, Google Sheets, and Your CRM
Looking to build this now? Try our Lead Capture QR Code Generator
Export structured lead submission records to CSV from your TryQRMint dashboard for spreadsheet and CRM management.
1. Step-by-Step: Download Your Lead Submissions
Exports are made one QR code at a time from that code's Leads page:
- Step 1: Sign in and open Dashboard > QR Codes.
- Step 2: Find your lead capture QR code and click the Leads button on its card.
- Step 3: Review your leads. You can search by name, email, or phone and filter by status on screen.
- Step 4: Click Export to CSV. Your browser saves a file named after the QR code's title, for example a code called 'Spring Flyer' downloads as spring-flyer-submissions.csv.
2. Exactly What Is Inside the CSV
The file always starts with four fixed columns. After those, there is one column for every field key that appears in your submissions, sorted alphabetically:
| Column | Example Value | Notes |
|---|---|---|
| submission_id | 3f2c9a1e-... | Unique ID for each submission. Useful for spotting duplicates when re-importing. |
| status | new | The lead's pipeline status (see the next section). |
| submitted_at | 2026-10-12T14:05:33Z | When the visitor submitted the form. The time is in UTC. |
| updated_at | 2026-10-13T09:12:01Z | When the record was last changed, for example when you changed its status. |
| company, consent, email, full_name, interest, message, phone... | Respondent answers | One column per field key, named by the key, not the label. A ticked checkbox appears as true. |
Create Your Custom QR Code
Generate static and dynamic QR codes tailored for your brand, with custom colors, embedded logos, and mobile-friendly microsites.
3. How Lead Statuses Appear in the File
On the Leads page you move each enquiry through New, Contacted, Converted, and Closed. The CSV stores the underlying status values, so map them when you import:
| Shown in Dashboard | Value in CSV | Suggested CRM Stage |
|---|---|---|
| New | new | New lead / Open |
| Contacted | confirmed | Attempted contact / In progress |
| Converted | completed | Qualified / Won |
| Closed | cancelled | Unqualified / Lost |
4. Opening the CSV in Excel and Google Sheets
The file is UTF-8 encoded with a byte-order mark, so names with accents (José, Zoë, Müller) open correctly in Excel. A few clean-up steps make the data easier to use:
- Excel: double-click the file, then press Ctrl+T (Cmd+T on Mac) to format it as a table with sort and filter buttons.
- Google Sheets: File > Import > Upload, choose the CSV, then pick 'Insert new sheet' so you keep earlier campaigns on separate tabs.
- Leading apostrophes: to protect spreadsheets from formula injection, any answer that starts with =, +, - or @ is saved with a leading apostrophe. Phone numbers typed as +1 555... will therefore show as '+1 555.... Use Find and Replace to remove the apostrophe from the phone column before importing to a CRM.
- Timestamps: submitted_at is in UTC. Add a helper column if your team needs local time.
5. Importing Into HubSpot, Salesforce, or Another CRM
TryQRMint has no direct CRM integration, API, or webhooks. You move leads with your CRM's standard CSV import tool. A reliable routine:
- Map the columns: full_name to name (or split it into first and last name in your spreadsheet first), email to Email, phone to Phone, and your custom keys to custom properties.
- Map status using the table above, or ignore it and set every imported lead to your CRM's default stage.
- Tag the source: add a 'Lead Source' column in your spreadsheet (for example 'Flyer - Route A') before importing so you can report by campaign.
- Avoid duplicates on re-export: each export contains all submissions, so filter by submitted_at to keep only rows newer than your last import, or let your CRM de-duplicate on email.
6. Plans and What Happens Without Business
Viewing, searching, and updating lead statuses happens on the Leads page. Downloading the CSV file requires the Business plan ($29/month, or $23/month billed annually). On other plans, clicking Export to CSV opens an upgrade prompt instead of downloading. Lead Capture codes are dynamic, so the form itself also needs an active trial or paid plan to keep accepting new submissions.
Final Takeaway
Exporting QR code leads to CSV takes four clicks: QR Codes, Leads, review, Export to CSV. Knowing the column layout (four fixed columns, then your field keys alphabetically), the status values, and the leading-apostrophe rule lets you move a campaign's leads into Excel, Google Sheets, or a CRM in minutes.
Related Guides & Tutorials
How to Create a Lead Capture QR Code That Turns Scans Into Enquiries
Step-by-step: build a lead capture QR code, choose the form fields, test it on a phone and see every submission in your dashboard.
Best Lead Capture Form Fields for QR Codes: Which to Keep, Cut, and Require
The best lead capture form fields for QR codes: which of the 7 default fields to keep, when to require phone, and how field keys become your CSV columns.
Lead Capture QR Code Not Working? Fix Each Error Message Step by Step
Lead capture QR code not working? Match the exact message your visitors see, from 'Temporarily Unavailable' to 'Too many submissions', to the right fix.
Frequently Asked Questions
Find immediate answers regarding dynamic QR codes, analytics, formats, and commercial usage.
The Business plan ($29/month, or $23/month billed annually). Plans are prepaid and do not auto-renew. On other plans you can still view, search, and manage leads in the dashboard.
No. There is no native CRM sync, public API, or webhook. Leads are stored in your dashboard and moved to other tools by exporting a CSV file and importing it.
No. Each export covers one QR code. If you run several codes (for example one per flyer route), export each file and combine them in your spreadsheet. Adding a source column first keeps the campaigns separate.
Answers that begin with =, +, - or @ are saved with a leading apostrophe so spreadsheet apps do not treat them as formulas. Remove the apostrophe from the phone column with Find and Replace before importing into a CRM.
No. The search box and status filter affect only the on-screen list. The CSV always includes every submission for that QR code.
Ready to Supercharge Your QR Campaigns?
Create a free account to design branded QR codes, launch dynamic redirects you can edit anytime, and track scans in real time.