The Worksheet view offers a complete grid view of all registrants and their registration answers for a given Registrant Type.

The worksheet view provides an efficient way to sort, filter and display your registrant data. You can also save custom views of your registrant data and switch between those views instantly. You can also export any view to a .CSV file of exactly what's on screen when you use the Export Filtered button.

The Worksheet grid allows you to view registration data for only one Registrant Type at time. To choose which Registrant Type to view, click on the Show drop-down and select the desired Registrant Type from the list.
​
​NOTE: You must first add registration forms and have received registrations before data will appear in the Worksheet grid.

The worksheet is a tabular view of your event's registration data. Based on how you have set up your registration form, the following information may be displayed in the worksheet grid:

​Worksheet Header - like with most common spreadsheet tools, the header row is where you can control the view/display parameters. The header label for each column uses the Short Field Name value that you entered when you added the field to your form.

Locked Columns - you can lock/freeze columns so that important columns are always visible on the screen. In the example below, all columns to the left of the vertical lock-line will remain on the screen.

To lock/unlock a column, click on the down arrow (1) in the header for the column and select the Lock or Unlock option (2) in the drop-down.

The newly locked column will automatically be moved to the left the Lock Line.
If a column is unlocked, then it will automatically be moved to the right of the Lock Line.

​Reorder Columns - to change the order the columns are displayed, use your mouse and simply select the column header you want to move and drag-and-drop the column to where you would like it to appear. If you move it to a location left of the Lock Line then the column will automatically become locked/frozen.
​

Resize Columns - to change the width of a column, from within the header row, select the column's right edge and adjust the width. Once you have selected the edge the mouse pointer will change the resize pointer.

Selecting a Row - to view the details of any registrant, select the row for the desired registrant and click on the "pencil" icon in the Edit column. This will open the Registrant Detail screen and allow you to edit the associated registration.

To control which columns are being displayed, follow these three steps

The worksheet grid can be sorted by any single column, in ascending or descending order.

Note: you can sort using any visible column, both locked and unlocked.

Default Sort Order - when first loaded the grid is sorted by the date/time the registration was received, with the most recent registrations on top. Click on the column header of the column you wish to use to sort the grid. The grid will be sorted in ascending order, as shown by the triangle indicator.

Clicking on a column header a second time will change the sort order of that column to Descending.

Clicking on the column header a third time will turn off the sort for the selected column and the sort order will return to the default sort order.

It's possible to filter the grid by contents of one or multiple columns.

3. Choose the filter criteria.

4. Enter the desired value.
5. And click Filter

Once set the filtered column(s) will be highlighted in orange, in addition to the "Filtered" tag.

To reset the filter for a single column, follow these three steps:

To remove all existing filters, click on the " X " in the Filtered tag

Once you've set up filters, a sort order, custom column widths, and a column layout the way you like, you can save that configuration as a named View so you (and your team) can switch back to it instantly, instead of rebuilding it each time.

A View selector appears in the worksheet header, next to the Registrant Type selector, whenever registrant data is loaded.

If a saved view references a column for a form field that has since been deleted in the Form Designer, that stale reference is silently ignored when the view is applied. The rest of the view's filters, sort, and columns still apply as expected.

A right-aligned Export Filtered button is displayed in the worksheet header whenever registrant data is loaded. Clicking it immediately downloads a CSV file containing exactly what's currently on screen: only the rows that pass your active filters, only the columns currently visible, and in the same sort order and column order shown in the grid.

The file downloads instantly from your browser, so it reflects whatever view of the data you're currently looking at. The filename includes the Registrant Type and the active view name, plus a timestamp, e.g. Competitor_Dallas Only_2026-07-09-14-30-00.csv

The ClearEvent app remembers your Worksheet settings so you don't have to rebuild them every time you come back. Once you have configured your view parameters, or selected a saved View, the current state of the Worksheet is automatically saved for the current user in the current browser. So, the next time you open the Worksheet for a given Registrant Type, your last-selected View (or ad hoc filters, sort, and column layout) is automatically re-applied.

This "last selected view" memory is device-specific: other members of your team will see their own last-selected view on their own browser. Saved Views themselves, however, are not device-specific. Once you save a View, it's stored for the event and any event manager on your team can see, select, or delete it.

Still have questions?

Chat with us!