From the Participant record: 
  1. In Records, open the Event record. 
  2. Select the Participants tab.
  3. Open the list of Registrants 
  4. Right-click on the Participants list and select Columns
  5. Add the column for 'No. of Guests' or 'Guest Of' column to the Columns to Display frame and click OK.
  6. Right-click in the right frame and select Export Participants Grid to Excel.
If all registrants have guests and you want a list of the guests grouped by registrant: 
  1. Create a participant query. On the Criteria tab, select:
    Events, Event Name equals [name of event]
    AND Participation Type equals Guests 
  2. Create a participant export using the query created in step 1. Export in comma-Separated Values format or in an Excel format. On the General tab under Include these Participants, select Guests. On the Output tab, select:
    Name
    Host Name
  3. Open the file in Excel and sort first by Column B (host name), then by Column A (registrant name). For instructions on how to sort in Excel, refer to BB63566.

If not all registrants have guests and you want a list of the guests grouped by registrant and include the registrants with no guests:

  1. Create a participant query. On the Criteria tab, select:
    Events, Event Name equals [name of event] 
  2. Create a participant export using the query created in step 1. Export in Comma-Separated Values format or in an Excel format. On the General tab under Include these Participants, select only Guests. On the Output tab, select:
    Name
    Host Name 
  3. Create a participant query. On the Criteria tab, select:
    Events, Event Name equals [name of event]
    AND Guests, Name blank 
  4. Create a participant export using the query created in step 3. Export in Comma-Separated Values format or in an Excel format. On the General tab under Include these Participants, select Registrants. On the Output tab, select:
    Name
  5. Open the file created in step 2 in Excel (File A). Open the file created in step 4 in Excel (File B). File B only has one column. Cut and paste it into Column B of File A - do not overwrite what is in File A. Start it in the first blank row. (This is to be able to alphabetize by the registrant.) Sort the spreadsheet by Column B, then by Column A. For instructions on how to sort in Excel, refer to BB63566.