Originally, this tool was made to eliminate the different Excel sheets that our customers were using to maintain or enhance master and meta data. Almost every data warehouse solution uses one or many EXCEL or CSV sheets as a source of data where no source system is available.
All experienced data warehouse professionals know that using EXCEL or CSV files as a data source can be a big pain because of the limitation of non-validated data, formatting issues and locking issues. Even the best data warehouse can be limited by non-valid or non-existing meta data or by update errors caused by locked excel sheets. Hence, all organizations need this tool.
This is the free edition of accoADE. To take advantage of additional features, such as the ability to open child data sets and using more than one configuration, you should install "accoADE" from https://appsource.microsoft.com/da-dk/product/office/WA104381440.