Sonder Portal: Deleting Member Data

Deleting Members (individual)

To delete a single member, navigate to the member area and click on the icon in the row that corresponds with that member. The following screen will then be displayed:

• Cancel: Selecting this option will close the dialog and allow you to return to the member list without deleting this member.

• Delete Member: Selecting this option will remove this member from the list, and update your organisations Available and Used Seats accordingly.

Editing multiple members at once (bulk upload)

To delete multiple members through a file upload, select the ‘Bulk Delete Member’ option from the Manage Members dropdown menu in the Member area. 

Step 1: Preparing your file

Start by considering which members you would like to delete and prepare a file with a single column that contains a list of email addresses that correspond to these members.

You may prefer to export your member data from another platform (i.e. HRIS System) into a file that you can use to upload into the Portal. In this instance, please ensure that the file to be uploaded is in CSV or XLSX format.

Step 2. Upload your member data

1. Go to Members > Manage Members > Bulk Delete Member button
2. Drag and drop your file into the upload area, or click Upload file to select it
3. Wait for the upload to complete (takes several seconds)

Step 3. Map your columns

This step in the data upload process confirms alignment between the columns in your uploaded file with the fields that exist within the Portal. When deleting members in bulk, only a single field is required to be mapped and this is the member’s 'Email Address'.

In order to proceed, ensure that the field that includes member Email Addresses in ‘Columns in Your File’ on the left corresponds with the Email field in the ‘Sonder Columns’ on the right. If you observe an incorrect mapping or manual input is required, you can select the correct field mapping by accessing the dropdown menu shown beside the destination fields.

Once you are confident that the Email field in your file is successfully mapped, you can click on the Continue button to proceed.

Step 4: Review and fix errors

The Portal will check your data for common errors. Any problems will be highlighted in red.

Common errors:

• Missing mandatory fields: Make sure every member has a first name, last name, and email address
• Invalid email: Check the format (example@company.com)
• Duplicate email addresses: Each member needs a unique email

You can edit records directly in the table. When you fix an error, the row will turn green.

Click Submit when all errors are resolved.

Step 5: Confirm and submit

A dialog will show:

• Total records in your file
• Number of records with errors (if any)
• Number of valid records that will be submitted for deletion
• Whether you're exceeding your seat count
• If any records were rejected, you'll see a dialog offering to download disregarded records. Download this file. It's the only time you'll have access to it, and it explains why each record was rejected for you to fix and re-upload later.

Review the summary. If everything looks right, click Confirm to submit.