Using an Excel Template of Categories, you will be able to build your organization’s knowledge map quickly and easily.


How to download the Excel category template?

How to fill in the Excel template of categories?

How to import the Excel template of categories?


How to download the Excel category template?

  1. In the "Questions" area of the left side menu, click on the "Category" section to access the list of categories

  2. Click on the "Upward Arrow Cloud" button at the top right

  3. In the pop-up window, click on the "Download" button 

  4. Find and open the folder on your PC where you want to download the template and click on "Save"









Back to the top of the article


How to fill in the Excel template of categories?

  1. Open the Excel template "categories_sample" that you have previously downloaded

  2. You will find a brief explanation on how to cover the Excel, read the instructions carefully, then overwrite or delete the "sample values" in the columns and follow the next steps:

    1. Name: Add the parent categories or category paths (parent category > child category > child category) you need

    2. Restricted 1/0 (1 yes/0 no): Type the number 1, if you want to enable the "Restricted" option in the category or categories. Type the number 0, otherwise











Note: In Zapiens you can set access permissions to certain categories or knowledge areas with the “Roles” functionality. Users with these permissions will be able to see in the App those categories and their associated knowledge. To do this, you must enable the “Restricted” option.


Back to the top of the article


How to import the Excel template of categories?

  1. In the "Questions" area of the left side menu, click on the "Category" section to access the list of categories

  2. Click on the "Upward Arrow Cloud" button at the top right

  3. In the pop-up window, click on the "Import" button 

  4. Click on the "Select" button

  5. Find the excel category template on your PC and click on the "Open" button

  6. Click on "Save" 

  7. If you made a mistake when selecting the file, click the "Update" or "Delete" button to reselect

  8. In the category list, you can see the new categories created

  9. Click on any area of the left side menu or via the Questions > Import Excel path at the top left to exit the import process








Back to the top of the article