Help Center > Working with tables
Working with tables
Most results in Skymem are shown in tables: email lists, verified email lists, companies, tasks and usage. This page explains how to scroll, filter, sort and select rows, and how to copy or download them.
Tables show your data. You cannot edit a value in a cell.
Two kinds of tables
Skymem has two kinds of tables. They look similar, but they load rows in different ways.
| Continuous tables | Paged tables | |
|---|---|---|
| Where | Companies, Company tasks, Domain lookup, Usage Activity, Usage Events | Email lists, verified email lists, the page of a domain |
| More rows | Scroll down. The next rows load as you scroll. | Use the page controls below the table. |
| Total number of rows | Not always known in advance. A counter or a message tells you when everything is loaded. | Shown in the page controls. |
Filter rows
- Many columns have a filter field directly under the column name. Type a value and the table updates after a short pause. There is no apply button.
- To change how a column is compared, for example from contains to equals, open the filter icon next to the field or in the column header.
- On some tables you open the filter only from the icon in the column header.
- A verified email list also has a Quick Filter: box above the table. It searches all columns at once.
- To remove a filter, clear its field.
Column filters narrow the rows that the table shows. They do not change your search, your list or your limits. On the Companies page, the Filters panel defines the search itself. See search companies.
On Usage pages and on Company tasks, Refresh loads the newest data and keeps your filters. On Usage pages, Reset removes the filters.
Sort rows
Click a column name to sort by that column. Click again to reverse the order.
Not every column can be sorted. In continuous tables, most columns keep the order that the page defines, for example newest first.
Resize columns
Drag the right edge of a column header to change the width of the column. Long values are cut off with an ellipsis until you widen the column. On a small screen, scroll sideways inside the table.
Select rows
Tables that have actions for selected rows show a checkbox at the start of each row.
- Tick the checkbox to select the row.
- Hold Shift and tick another checkbox to select all rows between the two.
- The checkbox in the table header, where there is one, selects many rows at once. In Companies it selects only the rows that are already loaded, not every company that matches your search.
- On the page of a domain, Select selects all rows on the current page.
Full screen
Tables with a full screen icon above them can fill the whole window.
- Click the full screen icon, or click a cell and press Enter.
- Work in the table as usual.
- Press Escape to return to the page.
Enter opens full screen only when an ordinary cell has the focus. On a link, a button or a filter field, Enter does what that control normally does. If a filter menu is open, the first Escape closes the menu.
Keyboard
| Key | What it does |
|---|---|
| Arrow keys | Move to the next cell. |
| Page Up, Page Down | Move one screen up or down. |
| Ctrl+Home, Ctrl+End | Go to the first or the last loaded row. |
| Tab, Shift+Tab | Move to the next or the previous cell or control. |
| Enter | In a cell: open full screen, on tables that support it. On a link or button: activate it. |
| Escape | Leave full screen. |
Copy and download
What you get depends on the page. Check whether an action uses your selection or the whole result.
| Page | Action | What it includes |
|---|---|---|
| Page of a domain | Copy Selected Emails, Download Selected Emails (TXT), Copy selected (CSV), Download selected (CSV) | Only the rows you selected. |
| Email list | Download | The whole email list, as a zip file. |
| Verified email list | Copy to Clipboard, Download CSV | The rows you selected. If no row is selected, all rows in the table. |
| Companies, Domain lookup | Export, Export matched, Download unmatched | You choose the scope in the dialog, or the button name states it. Exports run as tasks. |
For company exports, see export company results and company tasks. For email lists, see manage your email lists. For verified email lists, see manage verified email lists.
Troubleshooting
The table shows fewer rows than you expect
Check for a value in a column filter or in Quick Filter:. Clear it to see all rows.
The header checkbox did not select everything
In a continuous table it selects only the rows that are loaded. To work with every company in a search, choose the All filtered companies scope in the export or email list dialog.
Enter does not open full screen
Click an ordinary cell first. Not every table has full screen. Look for the full screen icon above the table.