Automation of capturing licence information

Each month, an employee collects information about licenses from various sources and enters it step by step into a multi-page Excel document that consolidates this information and uses macros for additional checks and calculations. Once all the data has been collected and processed, the service manager places a license order for the coming month via a special web application. As everything is done manually and data has to be entered into multiple Excel spreadsheets, errors can occur that only become visible in the controlling phase and can lead to high costs. In order to reduce manual input errors, it was decided to automate part of the license capturing process. For this purpose, two options – UiPath and Robot Framework – were compared as part of a proof of concept. In the end, Robot Framework was selected and the automation was implemented within it.