How to import an Audit Questionnaire from Excel?

How to import an Audit Questionnaire from Excel?

It is possible to import Audit Questions from Excel, but you need to add your questions to our Excel template. Here are the steps to do so:

1- Create a new Questionnaire




2- Save the basic information about the questionnaire
Before you can see the Excel template in which to enter your questions, you need to save the basic information about the audit.


3- Download the Excel template
After saving the basic questionnaire information, you will be able to download the Excel template. Fill it and reimport it back into the system. Your new questions will be created.


Notes

You can also export and reimport existing audit questions.


The Excel file produced is the same as the Excel template to import new questions, with the notable difference that there are two extra columns at the end: namely the internal identifier of the existing sections and questions for the exported questions.  Do you remove those two columns, otherwise your questions are going to be treated as new questions and you will created duplicates.
    • Related Articles

    • Reuse Audit Questions or Sections in Multiple Questionnaires

      You can reuse Audit Questions and Audit Sections in multiple questionnaires to avoid creating duplicate copies of the same question. This better allows you to create variations around a questionnaire, like having a "Lite" and a "Detailed" version for ...
    • Reusing Audit Questions & Client Status

      An update to the Audit Questionnaires has been released to allow reusing the same question in multiple questionnaires. Watch the video to learn more. It is now possible to reuse audit questions and audit sections in multiple questionnaires. This ...
    • Attach file(s) to Company Audit Questions

      In a Company Audit, you can attach file(s) to an question's answer. When creating a PSA ticket from Propel during the Audit's review, the attachments can also be sent to the PSA and attached to the created ticket. PSA Security Permissions ConnectWise ...
    • Autotask PSA: Import Manufacturer and Model Number from the Autotask Product

      Autotask PSA Propel Your MSP, if no User Defined Field has been set in PSA Integration / Asset Mapping , will now import the Manufacturer and Model Number from the Autotask Product assigned to the Configuration Item. This often has more ...
    • Changelog - Release notes

      Propel Your MSP is updated frequently. When updates are deployed, a new entry is added to this changelog here. You can subscribe to the RSS feed to receive using your preferred RSS reader to receive notifications: ...