To see who has RSVP'd, Registered, or Purchased tickets to an event, select the event, then Guest List > Who's Coming. This view will show all guests, and can be sorted by Name/Type, Last Action, or Last Notified. Guests can also be searched by name or email address, using the Search bar above the Guest List.
To view guest information in a spreadsheet, go to Reports > Guest Summary > Generate Report. Specific fields can be excluded before generating the report. By default, all guest questions and responses will be included in the report.