In the Task Manager's candidate panel, candidates' list can be exported in either CSV (Comma Separated Value), HTML, or JSON file format.
Despite CSV being an acronym for "Comma Separated Values," the user can choose their preferred delimiter from the available options, including comma, tab, and semicolon. While a CSV file can be opened with a basic text editor, spreadsheet software such as Microsoft Excel or comparable applications can arrange the values into columns based on the delimiter used in the CSV.
To export a list of candidates, please follow the steps below:
Utilize the search panel located at the top to refine and retrieve the list of candidates that you wish to export. The Dates, Group, Label, Stage, and Rating filters can be used to narrow down your selection.
Once the candidates have been retrieved, they will be displayed in a table below. If desired, you may choose to selectively export certain candidates. Otherwise, if no selections are made, all of the retrieved candidates will be exported.
Select the Export button located at the top of the table. Several options will appear that determine the file format.
File format options
After selecting the Export button, you will be presented with several file format options, including:
JSON: A file format that can easily be consumed by other software.
CSV: This option provides three alternatives for specifying the delimiter used between values.
HTML: A file format that can be accessed using any web browser.
Dividing the data into multiple columns using Microsoft Excel
If you have selected the CSV file format option, you may use spreadsheet software to split the CSV file into multiple columns by utilizing the "Text to Columns" function and specifying the correct delimiter.
Select the First column of the sheet.
Choose the Data tab located at the top.
Select the "Text to Columns" button displayed underneath.
Select the delimiter that corresponds to your choice during the export process.
Upon selecting the Finish button, the list of candidates will be displayed in a table view.
Author
Mustafa Ekim
Mustafa Ekim, founder of TestInvite and QuizCV, brings nearly a decade of expertise in building online assessment platforms for custom, secure tests.
