How to upload metadata in excel files to purview?
How to upload metadata in excel files to purview?
Hello @PedroGutierrez-8396,
Welcome to the Microsoft Q&A platform.
UPADTE (2/6/2021):
Unfortunately, you cannot upload Metadata to Azure Purview from files like excel.
Make sure the data is available in the Azure Purview supported data sources.
May I know, where does the metadata excel files are located?
Azure Purview supports metadata extraction from the supported data sources shown below.

For more details, refer to Supported data sources and file types in Azure Purview.
Hope this helps. Do let us know if you any further queries.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
Pradeep,
Thanks for your answer. We have a problem that we don't have access to the databases then we won't be able to explore the data dictionary to feed PurView. Then, we will need to ask the DBA's to dump the data dictionary in a csv or excel file that will contain the name of the tables and columns and the type of the columns; then we want to upload all the excel files into PurView. The location of the csv or excel files with the metadata could be stored in any reachable directory. The structure of all the csv or excel files will be like DBName, Table_name, Column_name, Column_type. Is this feasible? How?
Best Regards,
Pedro E. Gutierrez
Hello @PedroGutierrez-8396,
Thanks for the details.
Unfortunately, you cannot upload Metadata to Azure Purview from files like excel.
Make sure the data is available in the Azure Purview supported data sources.
Hope this helps. Do let us know if you any further queries.
Please Accept the answer if the information helped you. This will help us and others in the community as well.
Hello @PedroGutierrez-8396,
Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
3 people are following this question.