Microsoft Office 365
Computeropleidingen &

Consultancy

Microsoft Office oplossingen

How to clean up your Ex Libris Alma data using Excel and get insight quickly

Ex Libris Alma is the only unified library services platform in the world, managing print, electronic, and digital materials in a single interface. As a completely cloud-based service, Alma provides libraries with the most cost-effective library management solution in the industry.

Universities around the world are using Ex Libris Alma to exchange information on books, maps and other materials universities have in their library. As a cloud based system, Ex Libris Alma provides a hub between the various Universities around the world using the software.

In The Netherlands the Leiden University is using Ex Libris Alma since 2016. Leiden University, a leader in innovation, is the first university in the Netherlands who has chosen for Ex Libris Alma as a library management service.

Exporting data to Microsoft Excel
Data form Excel Libris Alma can be exported to Microsoft Excel. However the data is not formated in such a way that it can be used easily to get direct insight, using Pivot Tables. First the Ex Libris Alma data needs to be cleaned from formating codes. To do this by hand is not an option.

Our organisation has therefore created an simple Excel template which can be used to clean up the Ex Libris Alma data quickly. Without any manual interference the data is cleaning in a matter of seconds. With the clean data set it is possible to quickly create advanced reports using Excel's Pivot Table feature.

Whenever you are interested how we can help you with getting insights from your Ex Libris Alma data using Excel, please do not hesitate to contact us directly.
You can reach us by phone: +31 182 62 00 52.

Click here for the full press article in Dutch of the Leiden University announcing the use of Ex Libris Alma