Can I import all members from an Excel file?

Why is it a good idea to import members from an Excel file?

- Get started quickly with SportMember if you already have all your membership data in a spreadsheet

- No need to invite them one by one and wait for them to sign up

- Quickly add new teams with all members along the way if you become the coach of multiple teams

- Send welcome email to each member as soon as you import

Open Members and Import Members

  1. Click on top left
  2. Click on MEMBERS
  3. Click on the green Create Member button on the right of the screen
  4. Click on Import members
  5. Click Select file and start the import by clicking Import

Before clicking Select file, you can download templates that specifically show how your Excel sheet should look like for the import to work properly.

Please note that the file type must be in either xls or xlsx format. We recommend following the templates strictly and calling the columns the exact titles to avoid errors.

The system needs at least these 3 pieces of information in order to make a member import:

  • First name
  • Last name
  • Email

If you want more information, you can easily choose to add:

  • Birthday (in date format, e.g. 25.04.2002)
  • Address
  • Postal code
  • City
  • Telephone
  • Phone2
  • Mobile
  • Mobile2
  • Extra email
  • Member number

  • TIP: We recommend unchecking the Send welcome email box. This way you can import the members' data and then check that the system has got it all. Then you can choose to send welcome emails directly from the member list.

Was this article helpfull?
0 of 0 thought this was helpfull
Do like 1258000 others