'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Format CSV to Import Teams Mailboxes and SharePoint URLs into Microsoft Purview
Question details
The user needs to know how to properly format a CSV file to bulk import Teams mailboxes and associated SharePoint site URLs into a Microsoft Purview Premium case.
- Product
- Microsoft Purview Premium
- Device & OS
- not provided
- Scenario
- Bulk importing compliance data, including standard Teams mailboxes and private-channel SharePoint URLs, into Microsoft Purview using a CSV file.
- Observed behavior
- The user is uncertain about the correct CSV structure, workload mapping rules, and whether private-channel SharePoint URLs can be mapped to the same entry as standard mailboxes.
Ensure you have the necessary administrative privileges in Microsoft Purview Premium and a reliable spreadsheet application installed to create and edit your CSV file.
Consult Microsoft Purview Support for Exact CSV Mapping
Because Purview Premium has strict compliance requirements and unique workload mapping rules, reaching out to official Microsoft engineers ensures your CSV headers are perfectly accurate for import.
This scenario requires Microsoft Purview Premium-specific guidance, which falls outside the scope of general SharePoint Online troubleshooting. Support engineers can confirm the necessary fields and the supported CSV import structures for private-channel SharePoint URLs.
Open your web browser and navigate to the official Microsoft Purview Q&A forum at https://learn.microsoft.com/en-us/answers/tags/284/microsoft-purview.
Click the 'Sign in' button in the upper right corner and log in using your Microsoft 365 administrator credentials.
Click 'Ask a question' and provide details regarding your specific CSV structure query for Teams mailboxes and private-channel SharePoint URLs to receive an exact mapping template.
Prepare Your CSV File Using Spreadsheet Software
Once you have the required header fields from Microsoft support, you will need to construct the CSV file using a standard spreadsheet tool before uploading it.
Use WPS Office to Prepare CSV Imports Seamlessly
While Microsoft Purview handles complex backend compliance data, preparing the required bulk import lists requires a reliable and fast spreadsheet tool. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, making it easy to format, edit, and save your CSV files with zero learning curve.
- 1. Download the software: Visit the official WPS Office website to download the free installation package.
- 2. Install WPS Office: Run the lightweight installer and follow the quick on-screen prompts to set up the software on your desktop.
- 3. Format your CSV: Launch WPS Spreadsheet to effortlessly construct, format, and export your compliance lists directly to CSV format.
Frequently Asked Questions
What file format is required for bulk importing sites into Microsoft Purview Premium?
You must use a properly formatted CSV (Comma Separated Values) file. The file needs to contain specific headers exactly mapped to Purview's required fields, such as Teams mailbox addresses and corresponding SharePoint URLs.
Can I link private-channel SharePoint URLs in the same CSV entry as standard Teams mailboxes?
Mapping private-channel SharePoint URLs alongside standard Teams mailboxes often requires specific Purview Premium case configurations. It is highly recommended to consult Microsoft Purview support engineers on the official Q&A forum for the exact CSV mapping logic to prevent import errors.
How do I ensure my spreadsheet saves correctly as a CSV?
In your spreadsheet application (such as WPS Spreadsheet or Excel), navigate to the 'File' menu, select 'Save As', and ensure that 'CSV (Comma delimited) (*.csv)' is selected in the file format drop-down menu before clicking 'Save'.
