Exporting test results to Excel

Exporting test results to Excel

In Evalart, it is possible to export test results to a CSV file (which can be opened with Excel).

To export results of all tests to CSV:

1. Go to the "Reports" option in the main toolbar and select "View Sent Tests" to access the list of reports.
2. Click on the "Export to CSV" button located in the upper right corner of the screen.

To export results of a selection process to CSV:

1. Go to the "Reports" option in the main toolbar and select "Selection Process Reports" to access the process summaries.
2. Select the summary of the process you want to export to CSV.
3. Click on the "Export to CSV" button located in the upper right corner of the screen and select one of the two options: "Simple CSV" and "Detailed CSV". The Simple CSV includes the scores obtained by candidates per test and, as a reference, the maximum possible score for the test, while the Detailed CSV includes the scores obtained by candidates in each category and, as a reference, the maximum possible score in each category.

To correctly visualize the CSV data in Excel, follow these steps:

1. Open Excel and create a new workbook.
2. Go to the "Data" tab and click on "Get External Data".
3. Click on "From Text" option.
4. A window will open where you can browse and choose the CSV file you want to open. Select the file and click "Open".
5. Select the "Delimited" option and choose the delimiter that corresponds (usually a comma).

    • Related Articles

    • How to test a test created by me.

      This is possible by using the preview option, which is represented by an eye icon button. Using this option, you can view the test as a candidate would. You can find the preview option in two places: in the test builder and in the test list. To ...

    • How to share tests and results with other accounts.

      In Evalart, it is possible to share tests and results with other accounts. This functionality is ideal for business groups that want to share tests (or questions) among companies within the group, allowing the reuse of materials produced by one unit ...

    • Viewing the results of the tests answered by the candidates.

      As candidates respond to the tests, you will be able to view the result reports. To access specific reports for a process, go to the "Reports" menu and select "Selection Process Reports." This will open the report view, where you can choose the ...

    • How to access the information of my candidates and their results?

      Only account users have access to candidate information and candidate results on the account, unless the "Show Score at the End" option is checked when setting up the process, which is always set to "no" by default. If the "Show Score at the End" ...

    • How to obtain a report that combines the results of all tests for a candidate in a process.

      Evalart offers both individual reports for each test completed by the candidate and a summary report that combines the results of all tests for a candidate in a process. To access this report: 1. Go to the Reports menu => Selection Process Reports. ...