--- title: Preparing a CSV of User Data from Microsoft Azure Active Directory description: Preparing a CSV of User Data from Microsoft Azure Active Directory --- [Skip to content](https://knowledgebase.cybernut.com/cybernut-knowledge-base/preparing-a-csv-of-user-data-from-microsoft-azure-active-directory#main-content) English Show submenu for translations [![Help Center Banner-2](https://knowledgebase.cybernut.com/hs-fs/hubfs/Help%20Center%20Banner-2.png?width=400&height=150&name=Help%20Center%20Banner-2.png)](https://knowledgebase.cybernut.com/cybernut-knowledge-base?hsLang=en) - [Home](https://www.cybernut.com/) - [Platform](https://www.cybernut.com/platform) - [Resources](https://www.cybernut.com/resources) Open main navigation Close main navigation - [Home](https://www.cybernut.com/) - [Platform](https://www.cybernut.com/platform) - [Resources](https://www.cybernut.com/resources) - English Show submenu for translations - [Contact Us](https://www.cybernut.com/contact) [Contact Us](https://www.cybernut.com/contact?hsLang=en) How can we help you? - There are no suggestions because the search field is empty. 1. [CyberNut Knowledge Base](https://knowledgebase.cybernut.com/cybernut-knowledge-base?hsLang=en) 2. [Troubleshooting/FAQs](https://knowledgebase.cybernut.com/cybernut-knowledge-base/troubleshooting-faqs?hsLang=en) 3. [Microsoft](https://knowledgebase.cybernut.com/cybernut-knowledge-base/troubleshooting-faqs?hsLang=en#microsoft) October 30, 2025 # Preparing a CSV of User Data from Microsoft Azure Active Directory ## In this article you will learn how to prepare a .csv of user data from Microsoft Azure Active Directory to use in CyberNut. Caution: If Direct Mail Injection is setup this is not a necessary step. Click below for a full screen walkthrough video.[▶️](https://cybernut.storylane.io/share/0qq1sgazmcd7)[Preparing a CSV of User Data from Microsoft Azure Active Directory](https://cybernut.storylane.io/share/rqtmbnui5kse) **Step 1:** Log in to the Azure portal and click on **View** for **Microsoft Entra ID**. ![](https://clueso-guides-us-west.s3.amazonaws.com/72a25761-71a5-443e-986e-715afae60830/e8019ca3-77a7-4eba-9e77-665f97261646/images/a3291ee5-9c62-49ff-b9b8-5632dde6dc4f.gif?AWSAccessKeyId=ASIAR5BT7ATNQGD5VS5Y&Signature=xbLmYSr%2FYACIkPfDEhDZ6xQGDFg%3D&x-amz-security-token=IQoJb3JpZ2luX2VjEDcaCXVzLXdlc3QtMSJIMEYCIQCOv%2FjfvVNNvZYDyAnvEHKp7flcb%2Fi6F25cSrJmcX5PVAIhAIyI%2BIaJlHaZIsv0Li2URYMPehro3bdOnNlb%2BIpezMPbKoYECPD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQAxoMMTMxMTA1NDkwMTM5IgxCl0DJkeqj61DhYs0q2gM6uW%2B%2F5KgSEw3lkej0fMQOiLDpp2rGapqoa9GHW7Y%2BD3N03bKU24D7lArXCCEVwvQ3A%2FuFC46MdKIA%2BTUQDFK4v6cqnUBEBZD%2BQhfTBNKKByIggWp1lDgsXvmPbbLuqr0%2F1NoQDXG6enph8AXkkkTxjDtrLDasVftI8tI5jk33caN96PBULwxtULGUVLajRNcKGvOxRc42fEVZ9Vg%2BzXacZK%2FxW0LfOXrhD1Ha9WclAJU2v993sMzKYZ5D7fOnQzjPYbw0aG9jhmMV2ClP4NKIDqsURKfdhT1vC8JqREq4QOGWZblxaJFRyBrNI8%2BN948v9XUwjsWJFLo4INGa2PtwRQi%2BwC9W%2FNeIlwC1BBH8EieApeOfQOcSi5m2dmF1g3akcspERU9QsqndphZRxC1X%2Fj0HEOJnAPqrN2vxSMa0rkJGmb0FFaqAtlGsYyW1%2BCc6easLdBgYo0JHpleLy7ebwO2urh%2B9qZ9VgyWTJskbvU%2FwTp6PR7Dyeb4NU4dLXE6UxxNMEMXdxBTiQqwAlF%2BWmeziW69DbSiJSSJfXpmkwMS78UCihIRwrXFOFdhvhl%2BWXNwcHr1bCNJ9SLI%2B4odtmY1kCQoGsMNxhziFtloGAV0h%2FDuRqz29UY4wqOqNyAY6pAE3VPi3RVjc%2FjmqFy10%2BID%2FCZKMmFtWOjY10j7WCRmyYJEuU9X0ZBcd2EdJ42MjneiDBq4Ow0FZbTSq0nV8tvWlm1%2FES966Rb44hjl7cP6NDJAgSqRJo3QAvbi7%2F83Cmt9IbVtGKH%2BxxFHm36YrrqMLOvHP3RksZ8K82hbffCmtgJeqsv2AzMK%2F0h%2B5TSEvrHOMQd5LNImNrpMsUo0irCprCL9IUg%3D%3D&Expires=1761886709) **Step 2:** Click on **groups**. Select the group to use and click on **members**. ![](https://clueso-guides-us-west.s3.amazonaws.com/72a25761-71a5-443e-986e-715afae60830/e8019ca3-77a7-4eba-9e77-665f97261646/images/f8a6aec6-70d6-43c8-98da-1279b503d491.gif?AWSAccessKeyId=ASIAR5BT7ATNQGD5VS5Y&Signature=TZRi3j3cOGnKe7Ub7MAUdkeiuUM%3D&x-amz-security-token=IQoJb3JpZ2luX2VjEDcaCXVzLXdlc3QtMSJIMEYCIQCOv%2FjfvVNNvZYDyAnvEHKp7flcb%2Fi6F25cSrJmcX5PVAIhAIyI%2BIaJlHaZIsv0Li2URYMPehro3bdOnNlb%2BIpezMPbKoYECPD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQAxoMMTMxMTA1NDkwMTM5IgxCl0DJkeqj61DhYs0q2gM6uW%2B%2F5KgSEw3lkej0fMQOiLDpp2rGapqoa9GHW7Y%2BD3N03bKU24D7lArXCCEVwvQ3A%2FuFC46MdKIA%2BTUQDFK4v6cqnUBEBZD%2BQhfTBNKKByIggWp1lDgsXvmPbbLuqr0%2F1NoQDXG6enph8AXkkkTxjDtrLDasVftI8tI5jk33caN96PBULwxtULGUVLajRNcKGvOxRc42fEVZ9Vg%2BzXacZK%2FxW0LfOXrhD1Ha9WclAJU2v993sMzKYZ5D7fOnQzjPYbw0aG9jhmMV2ClP4NKIDqsURKfdhT1vC8JqREq4QOGWZblxaJFRyBrNI8%2BN948v9XUwjsWJFLo4INGa2PtwRQi%2BwC9W%2FNeIlwC1BBH8EieApeOfQOcSi5m2dmF1g3akcspERU9QsqndphZRxC1X%2Fj0HEOJnAPqrN2vxSMa0rkJGmb0FFaqAtlGsYyW1%2BCc6easLdBgYo0JHpleLy7ebwO2urh%2B9qZ9VgyWTJskbvU%2FwTp6PR7Dyeb4NU4dLXE6UxxNMEMXdxBTiQqwAlF%2BWmeziW69DbSiJSSJfXpmkwMS78UCihIRwrXFOFdhvhl%2BWXNwcHr1bCNJ9SLI%2B4odtmY1kCQoGsMNxhziFtloGAV0h%2FDuRqz29UY4wqOqNyAY6pAE3VPi3RVjc%2FjmqFy10%2BID%2FCZKMmFtWOjY10j7WCRmyYJEuU9X0ZBcd2EdJ42MjneiDBq4Ow0FZbTSq0nV8tvWlm1%2FES966Rb44hjl7cP6NDJAgSqRJo3QAvbi7%2F83Cmt9IbVtGKH%2BxxFHm36YrrqMLOvHP3RksZ8K82hbffCmtgJeqsv2AzMK%2F0h%2B5TSEvrHOMQd5LNImNrpMsUo0irCprCL9IUg%3D%3D&Expires=1761886709) **Step 3:** Click on **bulk operations** and then click on **download members**. ![Image](https://knowledgebase.cybernut.com/hs-fs/hubfs/undefined-Oct-18-2024-02-51-32-9576-PM.png?width=653&height=389&name=undefined-Oct-18-2024-02-51-32-9576-PM.png) **Step 4:** Name the file **Cybernut campaign users** and click **start download**. ![Image](https://knowledgebase.cybernut.com/hs-fs/hubfs/undefined-Oct-18-2024-02-51-34-7843-PM.png?width=651&height=388&name=undefined-Oct-18-2024-02-51-34-7843-PM.png) **Step 5:** Once ready, click on the **click here to download** link. ![Image](https://knowledgebase.cybernut.com/hs-fs/hubfs/undefined-Oct-18-2024-02-51-33-4020-PM.png?width=650&height=389&name=undefined-Oct-18-2024-02-51-33-4020-PM.png) **Step 6:** Open the data in Google Sheet or Microsoft Excel. ![Image](https://knowledgebase.cybernut.com/hs-fs/hubfs/undefined-Oct-18-2024-02-51-34-2169-PM.png?width=649&height=420&name=undefined-Oct-18-2024-02-51-34-2169-PM.png) **Step 7:** Adjust the data to match this structure: Column A: GROUP NAME Column B: FIRST NAME Column C: LAST NAME Column D: USER EMAIL ![](https://knowledgebase.cybernut.com/hs-fs/hubfs/image-png-Oct-28-2025-07-09-35-5852-PM.png?width=624&height=314&name=image-png-Oct-28-2025-07-09-35-5852-PM.png) **Step 8:** Change the **Group name** for each user to either **Staff** or **Student**. ![](https://knowledgebase.cybernut.com/hs-fs/hubfs/image-png-Oct-28-2025-07-10-43-4876-PM.png?width=628&height=316&name=image-png-Oct-28-2025-07-10-43-4876-PM.png) **Step 8:** Download the file as a CSV. (Ex. CyberNut Users) - [Getting Started for IT Admins (Google)](https://knowledgebase.cybernut.com/cybernut-knowledge-base/getting-started-for-it-admins-google?hsLang=en#main-content) - [Getting Started for IT Administrators](https://knowledgebase.cybernut.com/cybernut-knowledge-base/getting-started-for-it-admins-google?hsLang=en#getting-started-for-it-administrators) - [Getting Started for IT Admins (Microsoft)](https://knowledgebase.cybernut.com/cybernut-knowledge-base/getting-started-for-it-admins-microsoft?hsLang=en#main-content) - [Getting Started for IT Administrators](https://knowledgebase.cybernut.com/cybernut-knowledge-base/getting-started-for-it-admins-microsoft?hsLang=en#getting-started-for-it-administrators) - [New & Updated Features](https://knowledgebase.cybernut.com/cybernut-knowledge-base/new-updated-features?hsLang=en) - [Admin Portal](https://knowledgebase.cybernut.com/cybernut-knowledge-base/admin-portal?hsLang=en#main-content) - [Creating Campaigns](https://knowledgebase.cybernut.com/cybernut-knowledge-base/admin-portal?hsLang=en#creating-campaigns) - [Analyzing Campaigns](https://knowledgebase.cybernut.com/cybernut-knowledge-base/admin-portal?hsLang=en#analyzing-campaigns) - [Reported Threats](https://knowledgebase.cybernut.com/cybernut-knowledge-base/admin-portal?hsLang=en#reported-threats) - [Troubleshooting/FAQs](https://knowledgebase.cybernut.com/cybernut-knowledge-base/troubleshooting-faqs?hsLang=en#main-content) - [General Questions](https://knowledgebase.cybernut.com/cybernut-knowledge-base/troubleshooting-faqs?hsLang=en#general-questions) - [Google](https://knowledgebase.cybernut.com/cybernut-knowledge-base/troubleshooting-faqs?hsLang=en#google) - [Microsoft](https://knowledgebase.cybernut.com/cybernut-knowledge-base/troubleshooting-faqs?hsLang=en#microsoft) - [Admin Portal](https://knowledgebase.cybernut.com/cybernut-knowledge-base/troubleshooting-faqs?hsLang=en#admin-portal) - [Faculty and Staff User Guides](https://knowledgebase.cybernut.com/cybernut-knowledge-base/faculty-and-staff-user-guides?hsLang=en#main-content) - [Faculty & Staff Guides](https://knowledgebase.cybernut.com/cybernut-knowledge-base/faculty-and-staff-user-guides?hsLang=en#faculty-staff-guides) - [Technical Support](https://knowledgebase.cybernut.com/cybernut-knowledge-base/technical-support?hsLang=en) [![Logotype Main@4x-1](https://knowledgebase.cybernut.com/hs-fs/hubfs/Logotype%20Main@4x-1.png?width=100&height=27&name=Logotype%20Main@4x-1.png "Logotype Main@4x-1")](http://cybernut.com?hsLang=en) Copyright © 2025, cybernut.com