How to Turn Microsoft Forms Responses into Candidate Lists

Online forms can collect a large amount of candidate information quickly. Once those responses are available as structured table data, the next challenge is turning them into focused lists and documents that contain only the information needed for a particular task.

From form responses to structured candidate data

Microsoft Forms can be used to collect information through an online form. When response data is available in Excel, each response can be represented as a row while the questions or data fields form the columns. This creates a practical starting point for further candidate-data processing.

The complete response table may contain far more information than a particular list requires. Instead of manually copying individual values into new documents, a selection-based workflow can help you work with the relevant rows and columns.

A four-step workflow

Why avoid copying responses manually?

A form can collect many fields for each candidate, but different tasks often require different subsets of that information. One document may need names and contact information, while another may require a different combination of fields.

If each new list is created by manually copying cells from the source table, the same information may need to be searched, selected and rearranged repeatedly. Keeping the response table as the source and creating task-specific selections can make the workflow easier to repeat.

Use one response table for multiple outputs

The same source table can support different candidate lists. You do not need every column in every output. Selecting only the fields relevant to the current purpose keeps the resulting document more focused and avoids unnecessary duplication.

For example, one list can contain a limited set of administrative fields, while another can use different information from the same source table. The exact fields depend on the purpose of the document and the data collected in the form.

Using Candidates Lists with table data

Candidates Lists is Windows desktop software designed to select, process and export candidate information from tables. After candidate response data is available in a suitable table, the application can be used to work with the information needed for a particular output.

1. Prepare the candidate response data as a table.
2. Use the table as the source for candidate information.
3. Select the candidate records and fields needed for the current task.
4. Process the selected data.
5. Export the result to Word, Excel or PDF.

Keep the workflow focused

The purpose of this approach is not to replace the form used to collect information. Microsoft Forms handles data collection, while the next stage is organizing and using the resulting table data efficiently.

Separating collection from processing creates a clear workflow: the form gathers responses, the table holds the structured data, and Candidates Lists helps prepare selected information for the final document.

Local processing after the data is prepared

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