webMOBI Help Center
All Categories Event Attendee List Adding through XLS file

Adding through XLS file

Attendee updates with excel templates

By Meg
February 24, 2022
  1. On the attendees’ page, click on “Download Template” to download the template for the Excel file.



  1. The following fields are mandatory

  • User Id

  • First Name

  • Last Name

  • Email

  • Company

  1. Click on the “Browse” button to browse for the attendees’ file on your device and select that device to open the file.

  2. Now the attendees are uploaded successfully.

  3. Now the Information is visible and you can edit accordingly.

  4. To delete the attendees select the attendees from the selection box and delete the attendee manually


Make sure that the required fields are added for each row of the attendee.

Additionally, sometimes the attendee names come together and the below steps can be used for separating first and last names in Excel with a Single-Name Contingency


Separate first and last names in Excel, ensuring that entries with only a single name are duplicated for both first and last name columns.


Microsoft Excel with a list of names in a column.


1. Prepare Your Excel Sheet:

- Ensure that your list of names is in a single column, say column A, starting from A1.

2. Separate the First Name:

- Click on cell B1 (or any other empty cell in the same row as the first name).

- Enter the following formula:


=IF(ISERROR(SEARCH(" ",A1)), A1, LEFT(A1,SEARCH(" ",A1)-1))


- This formula checks if there's a space in the name. If not, it uses the entire name as the first name. If there's a space, it extracts the portion before the space as the first name.

3. Separate the Last Name:

- Click on cell C1 (or any other empty cell in the same row as the first name).

- Enter the following formula:


=IF(ISERROR(SEARCH(" ",A1)), A1, MID(A1,SEARCH(" ",A1)+1,LEN(A1)))


- Similar to the first name formula, this checks for a space. If there's no space, it uses the entire name as the last name. If there's a space, it extracts the portion after the space as the last name.

4. Apply the Formulas to All Names:

- After entering the formulas in B1 and C1, drag the bottom-right corner of these cells down to fill the formulas for all the names in column A.

5. Review and Verify:

- Check the separated names in columns B and C to ensure accuracy. Names without spaces should appear in both columns, while names with spaces should be separated appropriately.


- This method assumes that each name consists of only a first name and a last name separated by a single space. If there are middle names or multiple spaces, additional steps or modifications to the formulas will be required.

Was this article helpful?

Thanks for your feedback!