The employee list
Open and read the HR employee table, customize and reorder its columns, search, filter and sort, export to Excel, and open an employee's detail view.
The employee list is where your HR team sees everyone in the company at a glance, with each person's benefit allowance, expenses, and remaining balance on a single row. This article covers reading the table, choosing which columns appear, searching, filtering and sorting, exporting to Excel, and opening an employee's full detail view.
Open the employee list
In the webapp, open the HR section and select Employees. CLVR takes you straight to the full table, sorted by name. Every employee in your company appears as one row.
What each column shows
The table opens with six columns:
- Employee: the person's avatar (or their initial), full name, and work email. The name is a link.
- Role: their job title.
- Benefit Allowance: the total allowance for the period, shown as (base + adjusted).
- Expenses: how much they have claimed so far.
- Remaining balance: what is left of their allowance.
- Termination date: their offboarding date, with a status badge when one is set.
All amounts are shown in kronor, and dates use the Swedish format (for example, 2026-05-29).
The first line of Benefit Allowance is the total. If you have manually adjusted someone's allowance, a second line shows the breakdown: the base amount followed by the adjustment in parentheses (an increase in green with a plus sign, a reduction in red). In the Termination date column, a red Terminated badge means the date has passed and offboarding is complete, an orange Scheduled badge means the date is in the future, and rows for already-terminated employees appear dimmed. Employees with no termination date show a dash.
Customize the columns
The list carries far more about each person than it shows by default. Above the table, on the left of the toolbar, is a small adjustments icon (the sliders button). Select it to open the Filter Columns popover, which lists every available column with a checkbox:
- Tick a column to show it, untick it to hide it.
- Show all columns turns everything on at once.
- None hides everything.
Six columns are visible to begin with (Employee, Role, Benefit Allowance, Expenses, Remaining balance, Termination date). Everything else starts hidden:
- Employee Number, Personnummer, Date of Birth, Gender
- Annual Salary, Pensionable Salary, Tax Table, Employment Rate (%), Start Date
- Address, Postal Code, City, Country
Personnummer, Pensionable Salary, and Tax Table are Swedish fields. For companies based in other countries these columns stay empty, since the data lives only on Swedish employee profiles.
Custom fields you add to employees become columns in the same list. A custom field shows up in the Filter Columns popover automatically once at least one employee has a value for it, and it starts hidden. For more, see managing custom employee fields.
Once the columns you want are visible, drag a column header sideways to move it. The order changes immediately.
Your column choices and order live in the page address, so they survive a refresh and you can bookmark or share that link to reopen the same view. They are not saved as a permanent personal setting, so a fresh visit to Employees starts from the defaults again. The circular Reset arrow in the toolbar returns the table to its starting state and is only active once you have changed something.
Search, filter, and sort
The toolbar gives you three ways to narrow things down. None of this changes any employee data; it only changes what you see (and what an export captures).
Search by text. The search box narrows the table as you type. It is a case-insensitive, partial match across first and last name, email, job title, employee number, personnummer, and any custom field value. It does not look at dates or money columns; use a column filter for those.
Filter by column. Select Filter Rows to open a panel where you build one condition at a time:
Choose a Column from the dropdown. Built-in columns and any custom fields are all listed.
Choose an Operator. The options depend on the column type:
- Text columns offer contains, equals, starts with, ends with, is empty, and is not empty.
- Number columns (Benefit Allowance, Expenses, Remaining balance, Annual Salary, Pensionable Salary) offer equals, is not equal to, greater than, less than, greater than or equal, and less than or equal.
- Date columns (Termination date, Date of Birth, Start Date) offer equals, before, after, is empty, and is not empty.
Enter a Value if the operator needs one ("is empty" and "is not empty" do not), then select Add filter.
Each filter appears as a chip at the top of the panel. Once you have two or more filters, an AND / OR toggle appears: AND shows employees that match every filter (the default), OR shows employees that match any one of them.
Sort by a column. Select any sortable column header to sort by it; select it again to flip between ascending and descending. The table opens sorted by Employee name, A to Z. Sorting respects the column type, so number columns sort numerically and date columns sort by date.
The Reset arrow clears everything at once: search emptied, filters removed, sort back to Employee ascending, columns and order back to default, AND logic, and page 1.
Export to Excel
The toolbar has an Export button (the spreadsheet icon) that downloads an Excel (.xlsx) file of your current view.
Set up the view you want to export first. Show or hide columns, reorder them, type in the search box, and apply any filters. The export captures the table as it stands at the moment you click.
Select Export. The file downloads straight to your browser, named employees- followed by today's date, for example employees-2026-05-30.xlsx. It contains a single sheet.
The file mirrors what you see on screen:
- Columns: exactly the columns you have visible, in your current left-to-right order. The header row uses the same column names shown in the table.
- Rows: every row that matches your active search and filters, in the current sort order. This is the full filtered set across all pages, not just the page you are looking at.
- Dates: written in Swedish format. Empty values: written as blank cells.
To include hidden HR fields or custom fields, turn their columns on before exporting.
To get a full data set in one file, show every column you care about, clear any search and filters so all employees are included, then click Export. To pull a narrow slice (say, one department or only scheduled leavers), filter first and the export follows your filter.
Open an employee's detail view
Select any row, or the person's name, to open their detail view on top of the table. The web address gains an employeeId value, so you can copy the link, reload, or bookmark it and land back on the same person. To close it, select the close control or click outside the panel.
The top of the view shows the employee's photo (or a circle with the first letter of their first name), their full name, and their internal ID. Just under the header are Previous and Next buttons that step through the list in its current order; they wrap around and follow whatever sorting or filtering you applied.
On a computer you can switch without the mouse: hold Ctrl and press the left or right arrow to go to the previous or next person (on a Mac, Cmd with the arrows). The shortcuts are shown on the buttons and hidden on smaller screens.
The main column holds the person's record and history (Employee Data, Allowance details, and an Adjustments table when there is something to show). The side panel holds the two things you do most from here: Add/Deduct Allowance for a quick top-up or deduction, and the termination card. See adding and editing an employee for the edit and allowance flows, and terminating and offboarding employees for the offboarding flow.
Moving through a long list
The table shows 50 employees per page. For larger companies, a footer appears with page navigation, a "Showing X to Y of Z" count, and a control to change how many rows appear per page.
Troubleshooting
- An employee is not showing up. A search or filter is probably still active. Clear the search box, drop any filter chips, or select Reset.
- The AND / OR toggle is missing. It only appears once you have two or more filters.
- A custom field is missing from the column or filter list. It only appears once at least one employee has a value for it. Set the field on someone, then reopen the popover.
- A Swedish column looks empty. Personnummer, Pensionable Salary, and Tax Table only hold data for Swedish employees.
- My columns or view went back to the defaults. The layout lives in the page link, not as a saved preference. Bookmark the link to return to a particular view.
- A column is missing from the exported file. It was hidden when you exported. Show it via the column controls, then export again.
- I expected more rows in the export. A search or filter was still active. Clear the search and remove filters (or use Reset), then export.
- The detail view says the employee was not found. The link points to an
employeeIdno longer in your current list (for example after a filter narrowed it). Clear your filters and reopen from the list. - Previous and Next skip people I expected. They follow the list's current order and any active filter. Reset the filters to step through everyone.
- The keyboard shortcuts do nothing. They are a computer feature, hidden on small screens. On a Mac use Cmd with the arrows.