Path: Community Settings >> Admins/Moderators/Groups >> Bulk Upload Members Status
This section helps you to update or change the status of the existing members at one go. Member, current status could be in Pending approval, Approved or Banned, and can be changed by uploading an Excel sheet of the required member to the new status.
This setting is a part of Advanced settings.
Toggle the switch to Advanced to access the setting.
Please Note: In case there is a malicious content, virus or malware during the upload it will show an error and the upload will fail.
The excel sheet should be .xls and .xlsx format only.
The columns in the sheet are fixed first being the Email and second as Membership Status.
You would need to enable the switch "First row is column header"
While uploading the Excel sheet you would need to mention the New status as Pending for pending approval, Member for approved member and Banned to ban a member.
For instance you could upload the Excel Sheet with new status in the following format.