How to extend memberships with an Excel file

Click to export an excel file over the memberships.

Do not forget to use the filter Only active if you want to include inactive memberships.

Open the excel file.

Change the date at the To Date column.

Make sure you use the cell format “Date”.

It is also important not to change the member id and date of birth – otherwise the existing members will not be updated but they will be duplicates instead.

Save the excel file on your computer.

Go to Member > Import and select which role you want to import to. Choose the saved excel file and click Upload and import.

The historical imports tell you how many memberships that was created/updated. If you have filled in a member’s data incorrectly it will alert you. Just click and change the data in the excel file en reimport the file.