Create a custom assessment template

To create your own new template for custom assessments in Compliance Manager, you'll use a specially formatted Excel spreadsheet to assemble the necessary control data. After completing the spreadsheet, you will import it into Compliance Manager.


If you're not an E5 customer, use the 90-day Microsoft Purview solutions trial to explore how additional Purview capabilities can help your organization manage data security and compliance needs. Start now at the Microsoft Purview compliance portal trials hub. Learn details about signing up and trial terms.

Required roles

Only users who hold a Global Administrator or Compliance Manager Administration role can create and modify templates. Learn more about roles and permissions.

Create new template in Compliance Manager

  1. Start by creating a formatted Excel file that contains your template's data. Get detailed instructions at Format assessment template data with Excel.
  2. When your Excel file is ready, go to your assessment templates page in Compliance Manager and select Create new template. A template creation wizard will open.
  3. Choose the type of template you want to create. In this case, select Create a custom template, then select Next.
  4. At the Upload file screen, select Browse to find and upload your formatted Excel file containing all the required template data.
  5. If there are no problems with your file, the name of the file uploaded will be displayed. Select Next to continue. (If you need to change the file, select Upload a different file).
    • If there’s an error with your file, an error message at the top explains what’s wrong. You’ll need to fix your file and upload it again. Errors will result if your spreadsheet is formatted improperly, or if there’s invalid information in certain fields.
  6. The Review and finish screen shows the number of improvement actions and controls and the maximum score for the template. When ready to approve, select Create template. (If you need to make changes, select Back.)
  7. The last screen confirms a new template has been created. Select Done to exit the wizard.
  8. You’ll arrive at your new template’s details page, where you can create your assessment.

Modifying your templates

You can make changes to a template after you create it; for example, to add or remove an improvement action, or to change an action's name or other information. Visit Modify assessment templates for detailed instructions.