Skip to main content
All CollectionsPunchpass BasicsSwitch to Punchpass
Preparing Your Data for Import to Punchpass
Preparing Your Data for Import to Punchpass

Let us help make the switch in your software!

Leah avatar
Written by Leah
Updated over a month ago

Ready to switch to Punchpass? To ensure a smooth transition, we’ll handle the data import for you. Here’s a step-by-step guide on how to prepare your information so our team can get you up and running quickly.


The Information We Can Import for You

We can import the following types of data:

  1. Customer Information

    • Names

    • Email addresses

    • Phone numbers

    • Addresses (optional)

  2. Current Passes

    • Types of passes they might have (e.g., a punchcard pass vs an unlimited pass)

    • The remaining number of credits

    • Expiration dates

This information can be entered together, or separately - it depends on your current situation. But this is the information we're able to import for you.


How to Export Your Data From Your Existing Software

Most software platforms allow you to export data in CSV or Excel format. Check your current system for these options:

  • Customer Lists: Usually found in the "Customers" or "Clients" section.

  • Passes & Memberships: Look for an option to export passes or memberships.

  • Reservations & Attendance: Check for booking or attendance reports.

If you’re unsure how to export your data, reach out to your current software provider’s support team for assistance.


How to Organize Your Files

To help us import your data accurately, you'll want to organize your export files clearly.

You can create separate spreadsheets, CSV or Excel files for each type of data:

Creating a Spreadsheet of Your Customer List

  • Each spreadsheet file should have clear headers for each column.

  • At a minimum, we require the following customer information:

    • First name

    • Last name

    • Email address

  • We're also able to import columns containing the following information:

    • Phone number

    • Street Address

    • City

    • State/ Province

    • Country

    • Birthday (in MM/DD/YYYY or DD/MM/YYYY format)

    • Emergency contact name

    • Health status

    • Referral source

Please make sure any dates included are formatted as MM/DD/YYYY or DD/MM/YYYY.


Here's an example of what a spreadsheet for a customer list might look like:

Screenshot of a spreadsheet with a list of customers.

Creating a Spreadsheet with Your Active Customer Pass Information

  • Each spreadsheet file should have clear headers for each column.

  • To upload pass information into Punchpass, we're looking for columns that contain the following information. Any items that aren't required are optional, so if you don't have that information, that's okay!

    • First name (required)

    • Last name (required)

    • Email address (required)

    • Pass name (required)

    • Pass start date (required)

    • Pass expiration date

    • Price

    • Number of visits remaining (required if the pass is not an unlimited pass)

Please make sure any dates included are formatted as MM/DD/YYYY or DD/MM/YYYY.

Here's an example of what a spreadsheet with active customer pass information might look like:

Here's an example of how this information might look:

First Name

Last Name

Email

Pass Name

Pass Start Date

Visits Remaining

Pass Type

Expiration Date

Price

Jane

Doe

10-Class Pack

01/15/2024

5

Pass

06/15/2024

$100

Bugs

Bunny

1-Year Unlimited Pass

12/19/2024

Unlimited

12/18/2025



How to Send Us Your Data For Upload

Once your files are ready:

  1. Review the Files: Double-check that the data is accurate and complete.

  2. Send Your Files to Us: Email your files to [email protected] with the subject line "Data Import Request" or log into Punchpass and attach the files through the chat.

  3. Let Us Know About Any Special Requirements: If there’s anything unique about your data or how you’d like it imported, let us know!



What Happens Next?

  • We’ll Review Your Data: Our team will check your files and confirm everything looks good.

  • We Import the Data: We’ll handle the import process and let you know once it’s done. We aim to complete all data import requests within 2 business days.

  • You Review the Import: Once completed, we’ll let you know and ask you to review your data in Punchpass to make sure everything looks right.

  • Have memberships to migrate? You'll want to follow these steps.

  • And continue your launch preparations!


Need Help?

If you have any questions or need assistance, our support team is here to help! We strongly encourage you to book a call with our team to review your business needs and you're welcome to email us at [email protected] too.

We’re excited to help you make the move to Punchpass!


Did this answer your question?