Our Import answers feature allows Answer coordinators to import answers from an Excel file, saving time from copying and pasting them manually into the project.
To get started, go to the Q&A tab of your project and click Import – Import answers.
Step 1 – exporting questions
First, you need to download the list of questions that need to be answered:
All unanswered.
Filtered and selected.
If this option is unavailable, and you need to choose specific questions, close the window, apply any required filters and select relevant questions, and start the process again.
Once you have the relevant questions selected, click Download. This creates an automatic download of an Excel file containing all questions, ready for answering.
Step 2 – answering questions
Follow the tips in the exported Excel file to ensure there are no errors within the file for uploading.
Editing your Excel
In order for your import to be successful, the following columns must be present and filled:
#: question number or ID – do not edit or remove.
Question text: can be edited if needed, but it will not be updated upon import to the project.
Answer: can contain up to 5000 symbols only.
💡 For follow-up questions, you will notice the original question of the thread is presented in the Excel file in gray.
Once you're ready, save your file and return to the Import answers window.
Step 3 – importing questions
Choose file or drag and drop the prepared Excel file. A pop-up window will appear and confirm the status of your import.
Errors while importing answers
Occasionally, something in the Excel file formatting will not be aligned appropriately and only questions correctly answered and formatted will be accepted. With every import, you will see a pop-up that explains the status and any issues that have occurred.
For ease of editing, you can simply Export skipped rows and edit the file accordingly. Then try to import your answers again using step 3 above.