'%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 Upload CSV or Excel Files to Azure Purview
Question details
The user wants to know if and how CSV or Excel data dictionaries can be uploaded into Microsoft Purview for a business glossary or data catalog.
- Product
- Azure Purview
- Device & OS
- not provided
- Scenario
- Importing local spreadsheet data into an Azure Purview data catalog or business glossary.
- Observed behavior
- The user is looking for the correct procedure, as the exact import method depends on the specific metadata goals and Purview configuration.
Ensure your CSV or Excel files are properly formatted with standard headers before attempting to import them into any data catalog system.
Consult the Microsoft Q&A Community for Targeted Purview Support
Because the exact procedure varies based on your specific goal (glossary terms vs. metadata), posting in the official Microsoft Q&A forum is the best approach to get accurate Azure guidance.
Azure Purview supports multiple ways to handle CSV and Excel files. The correct approach changes drastically depending on whether you are bulk-importing business glossary terms, mapping catalog metadata, or simply scanning a spreadsheet as a raw data source. By consulting the official community, you can get step-by-step instructions tailored to your exact file structure and Purview environment.
Open your web browser and go to the official Microsoft Q&A website.
Click the button to ask a new question and ensure you add the 'Microsoft Purview' tag so that Azure data governance experts will see it.
Clearly state in your post whether you want to import glossary terms, load catalog metadata, or scan the spreadsheet as a data source.
Include your current Purview version, your intended destination within the catalog, and a brief description of your CSV or Excel file structure.
Prepare Your Data Dictionaries with WPS Office
Before uploading your metadata to Azure Purview, use WPS Spreadsheet to seamlessly organize, format, and save your CSV or Excel files. WPS Office is a free, lightweight suite that offers full compatibility with Microsoft formats, ensuring your data is properly structured for complex data catalog imports.
- 1. Download and Install: Visit the official WPS Office website to download and install the free suite.
- 2. Open Your Data Dictionary: Launch WPS Spreadsheet and open your existing CSV or Excel file, or start a new blank template.
- 3. Format and Save: Organize your column headers to match Purview's schema, remove any unsupported special characters, and save the file in .csv or .xlsx format.
Frequently Asked Questions
Can I import a business glossary into Azure Purview using a CSV file?
Yes, Microsoft Purview allows you to bulk import business glossary terms. To do this successfully, you must use the specific CSV template provided within the Purview Governance Portal to ensure your columns map correctly.
Why is my CSV file failing to upload to Microsoft Purview?
Upload failures typically occur if the CSV file does not strictly match the required template headers, contains empty mandatory fields, or includes invalid characters that Purview's parsing engine cannot read.
Does Microsoft Purview support scanning Excel (.xlsx) files?
Yes, Purview can scan Excel files as data sources if they are stored in supported connected storage locations, such as Azure Data Lake Storage or Azure Blob Storage, allowing it to extract schema metadata automatically.
