Import Offline Answers in an Assessment

When answering an assessment, you can answer directly on the platform, answer offline through an editable PDF or Excel, or import answers from a prior assessment. 

This article covers the following topics: 

Navigating to Active Assessments 

From the Partner Space

1. Once navigated to the intended partner from the Partners Module, navigate to the Assessments Screen, Active Assessments tab, and select an assessment as shown below.

2024-05-10_10-19-24.png

From Email

1. Navigate to the assessment from the email notification by clicking on Get Started.

GetStarted.png

Export Assessment

1. From the Answering Screen, click on Export on the top right of the assessment.

Export.png

For full details on exporting assessment, please see our help article Export an Assessment.

Answer and Import Offline Assessment Answers

Once the download is complete, users can add their answers offline into the PDF or Excel file.

Adding Offline Answers in Excel

1. In the Question Level Data tab, add answers in the Answer column as shown below. 

2024-04-25_11-25-11.png

2. If applicable, open clarifications can be answered from the Clarifications tab as shown below.

2024-04-25_11-27-21.png

Please Note: Answering clarifications offline is only available through the Excel option.

Adding Offline Answers in PDF

1. Add answers in each applicable answer box as shown below.

2024-04-25_11-33-06.png

Importing Offline Answers

1. Save the PDF or Excel file with your changes/answers added. Then, navigate back to the platform to import the assessment by clicking Import as shown below.

Import.png

2. In the Import Answers Window, select File.

2024-04-25_11-46-49.png

3. Select the intended file and click Next as shown below.

2024-04-25_11-47-58.png

4. In the Review & Import Window, review the uploaded file and click Import to confirm.

2024-04-25_11-48-55.png

Important Notes

  • When adding answers to an Excel/PDF file offline, only the rows/boxes that contain new data are required for import. Deleted or blank rows/boxes will be "ignored" upon re-import.
  • Only the first 250 answer options on a single question are available for export and import.
  • The same PDF or XLSX template can be used for multiple assessments if the questionnaires are the same. 
  • When files are required for questions, please note that attaching files is only available in editable PDF format, NOT Excel.
  • Tip: It is recommended to use PDF format for answering multiple choice questions as Excel is case sensitive and answers would need to be written in an exact match. PDF format is also needed for attaching files as Excel does not support file attachments. 

Please note: PDFs may default to open by the browser's PDF Viewer, however some answer types and features are not available for answering in this view. We recommend opening and answering assessments offline using Adobe Acrobat Reader which will have most answering capabilities available. 

Import Related Answers to an Assessment

1. Within the Answering Screen, click Import on the top right of the assessment as shown below.

Import.png

2. In the Import Answers Window, select Assessment to choose a related assessment to import answers to your current assessment.

ImportAnswers.png

3. Select the desired assessment to import from and click Next.

AssessmentSelection.png

4. The Review & Import Window displayed below shows the details of the answers that have been processed and are ready to be imported. Click on the Import button to proceed and finish the import process.

ReviewandImport.png

Viewing Import Logs

1. To view assessment Import Logs, navigate to the Active Assessments tab, click on the 3 dots under the Actions column, and select Go to Overview as shown below.

2024-05-10_10-20-10.png

2. In the Overview Screen, select the Import Log tab and here you can view the status, metadata, and results of each import.

ImportLog.png