How to Create Shortlists from Candidate Data

A large candidate table may contain more records and more information than you need for a particular task. Creating a focused shortlist means selecting the relevant candidates and displaying only the fields needed for review, administration or the next stage of a process.

Start with the complete candidate table

Candidate information is often stored in a spreadsheet or another structured table. Each row can represent a candidate, while the columns contain different types of information collected during the application process.

Instead of creating a separate copy of the entire table every time a smaller list is required, the original table can remain the source. The shortlist can then be built from selected records and selected fields.

Four steps for creating a focused shortlist

Why use different shortlists?

The same candidate data can support several different outputs. A working list for one task may require one combination of fields, while another stage may require a different selection from the same source data.

Using the original table as a common source makes it possible to prepare these different outputs without maintaining several manually edited copies of the complete dataset.

Keep the shortlist relevant to its purpose

A useful shortlist does not need to reproduce every field available in the source table. Including only the information needed for the specific task can make the output easier to read and reduces unnecessary duplication of candidate data.

The fields selected should therefore follow the purpose of the document rather than simply copying every available column.

Avoid rebuilding lists manually

When a shortlist is created by copying individual cells into a new document, repeated changes can require the same work again. A selection-based workflow allows you to return to the source table and prepare another output from the relevant records and fields.

This approach is useful when candidate lists need to be prepared repeatedly or when several different lists are created from the same application data.

Using Candidates Lists for shortlist preparation

Candidates Lists is Windows desktop software designed for selecting, processing and exporting candidate information from tables. It can be used to create focused outputs from larger candidate datasets without rebuilding each list manually.

1. Open or prepare the table containing candidate information.
2. Select the candidate records required for the shortlist.
3. Choose the data fields that belong in the output.
4. Process the selected information.
5. Export the shortlist to Word, Excel or PDF.

Local candidate-data processing

Candidates Lists processes candidate data locally on the user's computer rather than sending the information to a remote server by the application. Exported documents remain under the user's control on the device.

Create reusable candidate-data workflows

A structured shortlist workflow makes it easier to use the same source data for different tasks. Instead of repeatedly reorganizing the complete table, you can focus on selecting the candidates and information required for each output.