With just a click, AlchemyJ could analyze the business models in Excel spreadsheets, then it generates the Java, REST or JavaScript API that implements all the business logic as well as the technical specification contained in the Excel spreadsheet. Users can start from a blank spreadsheet or a pre-defined API template with all the necessary configurations ready so they only need to put in their own logic, then have the API generated instantly.

The security of API from AlchemyJ is divided into three stages. The first stage is the authentication. AlchemyJ API supports various authentication, such as LDAP. The second stage is access control. AlchemyJ API checks the role and group of authenticated users and determines if the API access is allowed. The third stage is session management, for instance, AlchemyJ manages encrypted information exchanges between API servers and clients, as well as a session timeout.

AlchemyJ provides a debugger for real-time monitoring on the API execution. The debugger shows variables' value as well as execution formulas in different execution states of the API. AlchemyJ also provides debugging commands for interactive troubleshooting. Based on the commands specified, AlchemyJ will extract or execute corresponding information or operations during the API execution. While security is AlchemyJ's top priority, all debugging functions could be removed in the production environment.

AlchemyJ supports multi-developers (multi-analysts) API development projects. This maximizes the efficiency of complex API model. The idea of the multi-developers project in AlchemyJ is similar to the Divided-and-Conquer approach. Users can break down a complex model into a number of simple models. Each of the simple models is contained in a separate workbook and handled by an individual developer. AlchemyJ will combine all simple models into a solution for the complex model.

Despite the rich functions provided by AlchemyJ in Excel, there are circumstances that users need to build their own functions to extend the functionality of their business model and API. AlchemyJ provides a Framework for building AlchemyJ User Defined Function (AJUDF) in VBA and Java. While users could use VBA based AJUDF in their Excel models, AlchemyJ will call the corresponding Java-based AJUDF in the API. Transformation of AJUDF call, control and handling of return and error will automatically be done by AlchemyJ.