Insillion Excel-to-API: Accelerating MGA Product Launches with Excel-Based Rating Logic

Insillion Excel-to-API

Insurance systems are inherently complex, and many MGAs still rely on standard platform architectures that make change slow and costly. Among all system components, rating remains the most difficult to modify, driven by highly complex algorithms that vary by product and geography and are closely tied to underwriting expertise.

Generally, UW/MGA/actuaries are comfortable with Excel. Excel remains the most trusted tool for actuaries and MGA underwriting teams to design and validate pricing models. Rating rules, validations, and premium calculations are often finalized in Excel long before they are ever considered for production systems. 

Insillion Excel-to-API bridges this gap by converting existing Excel-based rating models into secure, high-performance, out-of-the-box APIs, without rewriting business logic. What used to take months now takes days. 

What makes the Insillion Excel-to-API solution unique? 

MGA underwriting and actuarial teams already rely on Excel to design, test, and refine pricing models. Insillion’s Excel-to-API solution is built around this reality, instead of rewriting rating logic in code, an API is generated directly from the Excel-based raters.  

This approach allows product teams to continue working in a familiar environment while maintaining direct control over premium logic and calculations. Any changes product teams/UW/actuary make in the Excel will automatically be reflected in the API without lengthy development cycles or dependency on IT teams to reinterpret business logic. Compared to traditional custom development, this process is significantly faster and far less error-prone. 

1. Native JavaScript Conversion: Insillion converts Excel-based rating logic into native JavaScript, removing the need to run Excel in production. Once converted, product logic can be configured and managed by business analysts with low-code configurators. This enables rapid implementations, with some integrations completed in as little as a few days.
2.  Eliminating Translation Risk: Rebuilding complex Excel raters in Java or JavaScript introduces lengthy timelines and slow development. A single missed cell reference, overlooked dependency, or misunderstood formula can create subtle rating logic that is extremely difficult to diagnose once embedded in code.  Insillion eliminates this risk by automatically converting Excel’s functional calculation logic into executable services, preserving every formula and dependency exactly as defined. If a calculation works correctly in Excel, it behaves the same way in the resulting API.
3. Flexibility for Direct Coding: Insillion offers another way to speed up what might otherwise be manual Java or JavaScript coding. If the MGA/UW/Product team still finds direct coding faster for some tasks, Insillion supports that as well (via plug-ins), giving MGAs the flexibility to choose the most efficient path without compromise.
4. Cloud-Based Scalability: The generated APIs are hosted on a secure, cloud-based SaaS infrastructure designed for scale and performance. When broker submissions surge during renewal season or after catastrophe events, serverless architecture (AWS Lambda) scales instantly to handle thousands of concurrent rating requests. Each rating calculation process is performed independently, ensuring fast response times even under extreme load. As volumes normalize, the platform scales down automatically, allowing MGAs to maintain performance 

How does an Excel-to-API solution accelerate MGA product launches?  

MGAs benefit from rapid product creation through several features.  

1. Out-of-the-Box APIs with Auto-Generated Documentation 

The platform offers a comprehensive set of ready APIs. Once a product is created, it is mapped to specific APIs. Each API is delivered with automatically generated, standard documentation, such as Swagger/Open API files that reflect the MGA’s exact product configuration. This is especially valuable for MGAs managing numerous custom policies, where rates, rules, and associated workflows change frequently. 

These ready APIs enable MGAs to integrate new products rapidly across multiple distribution channels, including broker and agent portals, quoting platforms, and internal systems, without extensive custom development. Clear, consistent documentation significantly reduces integration effort for technical teams and shortens onboarding cycles. 

When Excel logic is updated and the API is republished, the Swagger documentation is automatically regenerated, ensuring technical teams always work with the most current and accurate API specifications. 

2. Built-In Governance and Audit Controls 

Insillion allows MGAs to maintain their existing Excel rating logic while enabling granular user permissions, role-based access, and secure API endpoints for distribution partners. 

To ensure strong governance and control, Insillion includes a built-in maker–checker model for managing rate changes.  

1. Maker: Business analyst uploads and tests new/updated Excel models 
2. Checker: Senior reviewer independently validates before publication 
3. Version Lock: Each approved version is immutable, versioned, and fully traceable 

This structured approach strengthens data integrity, reduces errors, and provides clear audit trails throughout the product lifecycle. 

Insillion manages partnerships and protects proprietary logic through granular Role-Based Access Control Lists (RBAC). MGAs can precisely define who can view, test, or consume each API by role, such as underwriters, brokers, or agents, ensuring that sensitive pricing logic, underwriting criteria, and internal calculations are visible only to authorized users. 

This ensures sensitive pricing calculations and underwriting criteria remain visible only to authorized users. 

3. Low-Code Policy Document Generation 

Beyond rating, Insillion extends Excel-to-API capabilities to speed the path from quote to submission. Once a product is created, it is automatically mapped to the relevant APIs, including APIs for PDF generation. MGAs can choose between: 

1. HTML-based, designed for more detailed and visually rich documents 
2. DOCX-based, ideal for simpler, structured proposals using familiar Word templates 

Both approaches generate professionally formatted PDFs driven by the same Excel-based calculations, ensuring consistency between pricing and issued documents. PDF generation deploys as a scalable serverless (Lambda) service, maintaining performance during peak issuance periods. By supporting both HTML-based and DOCX-based approaches, Insillion provides flexibility and efficiency to MGAs 

4. Version Control & Testing  

Insillion's built-in compare feature allows MGAs to evaluate draft versions against current live logic or historical quotes using default input, which is crucial for tracking changes, maintaining consistency, and audit trails.  

The platform also supports structured and repeatable testing. MGAs can perform structured, repeatable testing by: 

1. Saving specific input scenarios identified by quotation IDs 
2. Re-executing saved test cases against new API versions 
3. Selecting previously generated quotes whenever a new Excel version is uploaded as official regression tests 

Once a stage is finalized, it is locked and immutable, ensuring that every quote is permanently tied to the exact version of rating logic used at the time. 

Transform Your MGA Product Launch Process 

Insillion Excel-to-API solution represents a fundamental shift in how insurance product logic is built and managed. It eliminates the need to manually translate complex business rules into code, allowing MGAs to retain full ownership of pricing logic while gaining the scalability, governance, and reliability of a modern MGA insurance software. By converting insurance rater to API calculator Excel models directly into production-ready services, Insillion enables faster iteration, consistent ratings across channels, and seamless integration with existing systems. 

The result is quicker product launches, reduced development costs, and a clear path from concept to market, allowing MGAs to focus on growth and underwriting excellence, not system complexity. 

Frequently Asked Questions