{"id":5010,"date":"2026-08-14T04:20:22","date_gmt":"2026-08-14T04:20:22","guid":{"rendered":"https:\/\/dev.opendesignsin.com\/insillion\/?p=5010"},"modified":"2026-08-14T08:52:31","modified_gmt":"2026-08-14T08:52:31","slug":"insillion-excel-to-api","status":"publish","type":"post","link":"https:\/\/dev.opendesignsin.com\/insillion\/blog\/insillion-excel-to-api","title":{"rendered":"Insillion Excel to API: How Commercial and Specialty MGAs Modernize Excel Raters"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:1339.52px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\" data-scroll-devices=\"small-visibility,medium-visibility,large-visibility\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-1 fusion-text-no-margin\" style=\"--awb-line-height:1.5;--awb-margin-bottom:16px;\"><h2>Why Excel Still Powers Many Commercial & Specialty Insurance Products<\/h2>\n<p><span data-contrast=\"auto\">For<strong>\u00a0<\/strong><\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/best-policy-administration-systems-for-specialty-or-niche-insurance\">specialty<\/a><\/strong><span data-contrast=\"auto\">,<strong>\u00a0<\/strong><\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/surplus-lines-mga-insurance-software\">surplus<\/a><\/strong><span data-contrast=\"auto\">, and<strong>\u00a0<\/strong><\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/small-commercial-insurance-software-for-mgas\">commercial line MGAs<\/a><\/strong><span data-contrast=\"auto\"><strong>,<\/strong> Excel\u00a0isn't\u00a0a\u00a0stopgap,\u00a0it's\u00a0the tool of choice for rating logic that involves multiple inputs, intermediate calculations, and conditional tables. A single workbook can hold hundreds of formulas, lookup tables, and underwriting rules refined over\u00a0years.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Many growing MGAs also run low-volume, high-value books, where building a custom rating application for every product is hard to justify, especially when business analysts already manage changes directly in Excel. Newer MGAs start even simpler, with underwriting guidelines living in spreadsheets or internal notes and a small team relying on manual review.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">As policy volumes grow, endorsements become more frequent, and more underwriters\u00a0join,\u00a0these disconnected processes get harder to govern. For many organizations, converting\u00a0<\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/insurance-rating-software-mga-commercial-lines\">Excel-based raters into APIs<\/a><\/strong><span data-contrast=\"auto\"><strong>\u00a0<\/strong>becomes the first step toward a more structured, scalable insurance platform.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2026\/07\/InsillionApproach-2.svg\"><img decoding=\"async\" class=\"lazyload alignnone size-full wp-image-4906\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271200%27%20height%3D%27627%27%20viewBox%3D%270%200%201200%20627%27%3E%3Crect%20width%3D%271200%27%20height%3D%27627%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-orig-src=\"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2026\/07\/InsillionApproach-2.svg\" alt=\"\" \/><\/a><\/p>\n<p><b><span data-contrast=\"auto\">Why\u00a0Insillion\u00a0Excel-to-API\u00a0Fits Commercial Lines:\u00a0<\/span><\/b><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/insurance-product-builder-excel-to-api\">Commercial and specialty products<\/a><\/strong><span data-contrast=\"auto\"><strong>\u00a0<\/strong>see more frequent pricing updates, product variations, and state-specific requirements than personal lines. Rather than rewriting rating logic each time a product evolves,\u00a0<strong>I<\/strong><\/span><strong>nsillion\u00a0Excel-to-API<\/strong><span data-contrast=\"auto\">\u00a0preserves\u00a0existing business logic and makes it available through modern digital channels.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h2 aria-level=\"2\"><b><span data-contrast=\"none\">Modernizing Excel Rating Models with\u00a0Insillion\u00a0Excel-to-API<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">For many MGAs, the challenge\u00a0isn't\u00a0creating a rating\u00a0engine,\u00a0it's\u00a0making an existing one accessible to the rest of the business.\u00a0Years of actuarial and underwriting knowledge already live in Excel, and rebuilding that logic elsewhere means\u00a0additional\u00a0cost, duplicate maintenance, and the risk of inconsistencies between the spreadsheet and the production system.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/insillion-excel-to-api-insurance-rater\"><span data-contrast=\"none\"><strong>Insillion's\u00a0Excel-to-API Accelerator<\/strong><\/span><\/a><span data-contrast=\"auto\">\u00a0takes a different approach:\u00a0rather than replacing Excel, existing Excel raters become the foundation of a configurable insurance platform, where the\u00a0<\/span><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/products\/rating\"><strong>same rating model can be exposed through APIs<\/strong><\/a><span data-contrast=\"auto\"> and reused across broker portals, customer portals, embedded insurance experiences, <a href=\"https:\/\/dev.opendesignsin.com\/insillion\/carrier\/north-america\">policy administration systems<\/a>, and other digital channels.<\/span><\/p>\n<p><span data-contrast=\"auto\">A common requirement across MGAs and insurers is to retain the proven business logic already built in Excel while making it available as a secure, reusable insurance rater API that multiple applications can consume.\u00a0<\/span><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/products\/excel-to-api\"><span data-contrast=\"none\"><strong>Insillion's\u00a0Excel-to-API Accelerator<\/strong><\/span><\/a><span data-contrast=\"auto\">\u00a0is designed to achieve exactly that, without requiring the rating logic to be rewritten.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The implementation is intentionally straightforward:<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<ul>\n<li><span data-contrast=\"auto\">Upload the existing Excel rater.\u00a0<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Assign business-friendly names to input and output cells.\u00a0<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">The platform interprets the workbook, including its formulas and calculations.\u00a0<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Excel inputs become JSON request\u00a0parameters, and\u00a0calculated outputs return as JSON responses<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li data-pm-slice=\"1 1 []\">Swagger\/OpenAPI documentation is automatically generated, enabling faster, self-service integrations with downstream systems and partner applications.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2026\/07\/InsillionApproach.svg\"><img decoding=\"async\" class=\"lazyload alignnone size-full wp-image-4903\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271200%27%20height%3D%27627%27%20viewBox%3D%270%200%201200%20627%27%3E%3Crect%20width%3D%271200%27%20height%3D%27627%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-orig-src=\"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2026\/07\/InsillionApproach.svg\" alt=\"\" \/><\/a><\/p>\n<p><span data-contrast=\"auto\">Because the rating logic is obtained from Excel, and maintained as a standardized API, there is no duplicate application logic to maintain. Business analysts continue managing pricing and underwriting logic in Excel, while developers consume standardized APIs.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><span data-contrast=\"auto\">This\u00a0lets<strong>\u00a0<\/strong><\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/products\/product-launch\">insurers reduce product launch timelines<\/a><\/strong><span data-contrast=\"auto\">\u00a0and<\/span><b><span data-contrast=\"auto\">\u00a0<\/span><\/b><span data-contrast=\"auto\">removes the traditional translation gap between business and IT, allowing product teams to update rating models without waiting for lengthy development cycles.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3><b><span data-contrast=\"auto\">Choosing the right insurance rating architecture<\/span><\/b><span data-ccp-props=\"\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">The right approach depends on the product's complexity and data volume:<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<div class=\"table-1\">\n<table width=\"100%\">\n<thead>\n<tr>\n<th align=\"left\"><span class=\"TextRun SCXW75276326 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW75276326 BCX0\">Requirement<\/span><\/span><span class=\"EOP SCXW75276326 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/th>\n<th align=\"left\"><span class=\"TextRun SCXW2086270 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW2086270 BCX0\">Recommended Approach<\/span><\/span><span class=\"EOP SCXW2086270 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td align=\"left\"><span class=\"TextRun SCXW248878338 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW248878338 BCX0\">Stable rating logic managed by business users<\/span><\/span><span class=\"EOP Selected SCXW248878338 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<td align=\"left\"><span class=\"TextRun SCXW177424073 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW177424073 BCX0\">Excel-to-API<\/span><\/span><span class=\"EOP SCXW177424073 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\"><span class=\"TextRun SCXW156646335 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW156646335 BCX0\">Frequently changing rate tables<\/span><\/span><span class=\"EOP SCXW156646335 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<td align=\"left\"><span class=\"TextRun SCXW221333756 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW221333756 BCX0\">Excel + External Database<\/span><\/span><span class=\"EOP SCXW221333756 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\"><span class=\"TextRun SCXW49789267 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW49789267 BCX0\">Large rule sets and enterprise underwriting<\/span><\/span><span class=\"EOP SCXW49789267 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<td align=\"left\"><span class=\"TextRun SCXW87929664 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW87929664 BCX0\">Business Rules Engine (BRE)<\/span><\/span><span class=\"EOP SCXW87929664 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\"><span class=\"TextRun SCXW127102664 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW127102664 BCX0\">Existing enterprise rating services<\/span><\/span><span class=\"EOP SCXW127102664 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<td align=\"left\"><span class=\"TextRun SCXW112889283 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW112889283 BCX0\">External API Integration<\/span><\/span><span class=\"EOP SCXW112889283 BCX0\" data-ccp-props=\"{\">\u00a0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2><b><span data-contrast=\"none\">Beyond Rating: Turning Excel into a Complete Insurance Product<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Converting Excel into an API\u00a0is\u00a0only the first step. A complete insurance product requires much more than premium calculation.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Insillion\u00a0surrounds the\u00a0<\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/insillion-rating-engine-approaches-for-mgas\">Excel-based rating engine with configurable capabilities<\/a><\/strong><span data-contrast=\"auto\"><strong>\u00a0<\/strong>that help MGAs manage the entire quoting and policy lifecycle, from submission through endorsements and document generation.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h2 aria-level=\"3\"><b><span data-contrast=\"none\">Automatically Generated Broker and Agent Portals<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Traditionally, developers must manually recreate ACORD forms in broker or agent portals, map every field to APIs, and maintain them alongside the rating engine.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><span data-contrast=\"auto\">With\u00a0Insillion's\u00a0Excel-to-API approach,\u00a0the Excel workbook itself becomes part of the product configuration.\u00a0Using\u00a0Excel Name Manager, business analysts define input and output fields, which are automatically reused as JSON request\/response parameters and across the product.<\/span><span data-ccp-props=\"\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">This enables\u00a0Insillion\u00a0to automatically generate broker and agent portals with the required fields,\u00a0eliminating\u00a0the need to build forms from scratch.\u00a0<\/span>Insillion<span data-contrast=\"auto\">\u00a0also supports\u00a0<\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/products\/submission-automation\">AI-assisted submission intake<\/a><\/strong><span data-contrast=\"auto\"><strong>,<\/strong> automatically extracting information from ACORD\u00a0forms\u00a0and supporting documents to create draft submissions for review.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The result is a complete, <a href=\"https:\/\/dev.opendesignsin.com\/insillion\/platform\">API-driven insurance product<\/a> with portals, workflows, and integrations delivered with significantly less development effort.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Configurable Data Validation<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Maintaining consistent data is just as important as calculating the correct premium. When an Excel rater is converted into an API, existing Excel validations continue to work as expected. Additional business validations, such as mandatory fields, conditional logic, data formats, and third-party data checks, can be configured without touching the workbook, and they're enforced consistently across the UI and API, ensuring secure, consistent data regardless of how the application is accessed.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Endorsements Using the Same Rating Logic<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Business analysts define endorsement types,\u00a0determine\u00a0which policy fields are editable, and configure the required approval process.\u00a0When an endorsement changes premium-bearing information, the platform automatically\u00a0recomputes\u00a0the premium using the same Excel-derived rating API, calculates any premium adjustment, generates the required endorsement documents, and\u00a0maintains\u00a0a complete audit trail.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><span data-contrast=\"auto\"><span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\">Insillion Excel-to-API<\/span><\/span><span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\">\u00a0<\/span><\/span>ensures pricing remains consistent throughout the policy lifecycle without requiring separate rating logic for endorsements.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Rule-Based Policy Document Generation<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Many MGAs continue to maintain policy forms and endorsements as Word documents. <span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\">Insillion's Excel-to-API solution<\/span><\/span><span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\"> enables existing Word templates to be incorporated into<\/span><\/span>\u00a0the product configuration. Dynamic placeholders and configurable rules determine which forms or clauses are generated based on product, coverage, state, or underwriting conditions.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><span data-contrast=\"auto\">The result is automated document generation while preserving existing policy forms and business rules.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Open\u00a0APIs\u00a0for Connected Insurance<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">The\u00a0<\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/mga-insurance-distribution-software-api\">Excel-based rating model can be mapped to different user journeys,<\/a><\/strong><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">including the generation of Certificates of Insurance, <\/span><span data-contrast=\"auto\">without recreating the pricing logic for each one:<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<ul>\n<li><span data-contrast=\"auto\">A\u00a0<\/span><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/mga-insurance-software-broker-partnerships\"><b><span data-contrast=\"auto\">broker (B2B)<\/span><\/b><\/a><span data-contrast=\"auto\">\u00a0journey might involve a detailed, multi-step submission process.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">A\u00a0<\/span><b><span data-contrast=\"auto\">customer (B2C)<\/span><\/b><span data-contrast=\"auto\">\u00a0journey might be simplified for direct-to-consumer use.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">An<strong>\u00a0<\/strong><\/span><strong><a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/embedded-insurance\">embedded insurance<\/a><\/strong><span data-contrast=\"auto\">\u00a0journey might require only a single-page workflow.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">All three can run on the same underlying product configuration, and all of this is configured through a low-code interface, where business analysts can set up pages, sections, fields, and customer journeys. For Certificate of Insurance use cases, a master policy can support a self-service portal where clients like trucking companies issue their own certificates.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h2><b><span data-contrast=\"none\">Managing Product Changes: Governance Built for Insurance<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Rates change, guidelines evolve, and carrier requirements get updated regularly, the hard part isn't making changes, it's testing, approving, and deploying them without disrupting live business.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Draft, Compare, and Validate Before Anything Goes Live<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">When a new Excel version is uploaded,\u00a0it's\u00a0treated as a draft, not a live replacement. Business users compare it against the current production version and against historical quotes using the same input scenarios, so they can see exactly how premiums would change before anything goes live.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Regression Testing Using Real Quotes<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Instead of creating test cases manually each time a product changes, the Insillion<span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\">\u00a0Excel-to-API solution<\/span><\/span><span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\">\u00a0<\/span><\/span>allows MGAs to reuse actual quotation scenarios.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><span data-contrast=\"auto\">Business users can:<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<ul>\n<li><span data-contrast=\"auto\">Save specific input scenarios, identified by submission ID, as test cases.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Re-run those saved test cases automatically every time a new API version is uploaded.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Select from previously generated real-world quotes to serve as official regression tests going forward.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">Using real-world submission data makes regression testing faster, more reliable, and easier to repeat throughout the product lifecycle.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Maker-Checker Approval<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">A maker-checker process adds a review step before anything reaches production: a business analyst uploads and\u00a0validates\u00a0a new\u00a0version,\u00a0a senior underwriter or product owner reviews it, and only then is it published.\u00a0This ensures that product updates follow a controlled governance process rather than relying on manual coordination.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h3 aria-level=\"3\"><b><span data-contrast=\"none\">Complete Version History and Audit Trail<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Every published version is retained and linked to the quotes it generated, creating a permanent, immutable audit trail of the rating logic used for every quotation and policy. For <a href=\"https:\/\/dev.opendesignsin.com\/insillion\/blog\/mga-insurance-software-multi-carrier-capacity\">MGAs managing products across multiple carriers<\/a> or capacity providers, this level of traceability helps demonstrate pricing consistency, stronger underwriting discipline, and greater operational transparency during audits and carrier reviews.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<h2 aria-level=\"2\"><b><span data-contrast=\"none\">Why Excel-to-API\u00a0Is the Right Growth Path for MGAs and Small Carriers<\/span><\/b><span data-ccp-props=\"{\">\u00a0<\/span><\/h2>\n<ul>\n<li><span data-contrast=\"auto\"><strong>Optimized<\/strong><b> for scale<\/b><\/span><span data-contrast=\"auto\">\u00a0\u2013\u00a0Insillion's\u00a0hybrid approach\u00a0delivers fast\u00a0performance for large schedules, datasets, or complex lookup tables by storing large reference tables in a database while keeping business calculations in Excel.<\/span><span data-ccp-props=\"\">\u00a0<\/span><\/li>\n<li><b><span data-contrast=\"auto\">Faster regression testing<\/span><\/b><span data-contrast=\"auto\">\u00a0\u2013 The production API\u00a0runs the same logic\u00a0defined in Excel, enabling quicker validation, higher accuracy, and reduced testing effort before deployment.<\/span><span data-ccp-props=\"\">\u00a0<\/span><\/li>\n<li><b><span data-contrast=\"auto\">No rebuild\u00a0required<\/span><\/b><span data-contrast=\"auto\"> \u2013 Underwriters simply identify the required input and output cells (using named ranges), and c<\/span><span data-contrast=\"auto\">onverts the spreadsheets into APIs<\/span><span data-contrast=\"auto\"><strong>\u00a0<\/strong>while\u00a0<\/span><span data-contrast=\"auto\">reducing product launch timelines.<\/span><span data-ccp-props=\"\">\u00a0<\/span><\/li>\n<li><b><span data-contrast=\"auto\">SOC 2 Type II certified: <\/span><\/b>Protects<span data-contrast=\"auto\">\u00a0rating models, data, and business logic with institutional-grade security controls.<\/span><span data-ccp-props=\"\">\u00a0<\/span><\/li>\n<li><b><span data-contrast=\"auto\">Supports large Excel raters: <\/span><\/b>Insillion<span data-contrast=\"auto\"><span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\">\u00a0Excel-to-API<\/span><\/span><span class=\"TextRun SCXW64974590 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW64974590 BCX0\">\u00a0<\/span><\/span>supports workbooks\u00a0up to\u00a0<\/span><span data-contrast=\"auto\">80\u2013150 MB.\u00a0<\/span><span data-contrast=\"auto\">Large lookup tables can optionally be moved to database tables while calculations\u00a0remain\u00a0in Excel, improving performance and reducing memory usage without a complete rebuild.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<li><b><span data-contrast=\"auto\">Granular rate management: <\/span><\/b><span data-contrast=\"auto\">Supports agent, broker, territory, state, ZIP code, and program-specific rates. When these rate tables become too large or require frequent updates, they can be managed centrally in a database, while Excel continues to drive the calculation of logic.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/li>\n<\/ul>\n<h2><span data-ccp-props=\"{\">Conclusion\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Excel has been the foundation of insurance rating systems for decades because it allows business teams to build and maintain complex products quickly. The challenge has never been creating rating logic, it has been making that logic scalable, governable, and accessible across modern digital channels.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p>Insillion's\u00a0Excel-to-API Accelerator<span data-contrast=\"auto\"><strong>\u00a0<\/strong>closes that gap:\u00a0existing<strong>\u00a0<\/strong><\/span>Excel raters<span data-contrast=\"auto\"><strong>\u00a0<\/strong>become APIs,\u00a0surrounded\u00a0by\u00a0configurable workflows, portals, validations, document generation, and governance capabilities\u00a0without rebuilding years of underwriting\u00a0expertise. For MGAs and small carriers, that also means removing one of the most common causes of delayed\u00a0launches, the\u00a0manual handoff between the Excel\u00a0workbook for\u00a0the business trusts and the system IT\u00a0has to\u00a0build around it.<\/span><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{\">\u00a0<\/span><\/p>\n<\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>See how Insillion Excel-to-API transforms Excel rating models into APIs, helping MGAs accelerate product launches.<\/p>\n","protected":false},"author":1,"featured_media":776,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17],"tags":[48],"class_list":["post-5010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-managing-general-agents"],"acf":{"event_date":null,"author_name":"Insillion Team","author_image":{"ID":3134,"id":3134,"title":"","filename":"Favicon-2.png","filesize":7655,"url":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","link":"https:\/\/dev.opendesignsin.com\/insillion\/blog\/digital-insurance-mga\/attachment\/favicon-2-2","alt":"Insillion Favicon","author":"1","description":"","caption":"","name":"favicon-2-2","status":"inherit","uploaded_to":3170,"date":"2025-07-31 10:29:21","modified":"2026-05-18 08:28:34","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/dev.opendesignsin.com\/insillion\/wp-includes\/images\/media\/default.png","width":400,"height":400,"sizes":{"thumbnail":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-150x150.png","thumbnail-width":150,"thumbnail-height":150,"medium":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-300x300.png","medium-width":300,"medium-height":300,"medium_large":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","medium_large-width":400,"medium_large-height":400,"large":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","large-width":400,"large-height":400,"1536x1536":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","1536x1536-width":400,"1536x1536-height":400,"2048x2048":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","2048x2048-width":400,"2048x2048-height":400,"blog-large":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-400x272.png","blog-large-width":400,"blog-large-height":272,"blog-medium":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-320x202.png","blog-medium-width":320,"blog-medium-height":202,"recent-posts":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","recent-posts-width":400,"recent-posts-height":400,"recent-works-thumbnail":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-66x66.png","recent-works-thumbnail-width":66,"recent-works-thumbnail-height":66,"fusion-200":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-200x200.png","fusion-200-width":200,"fusion-200-height":200,"fusion-400":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","fusion-400-width":400,"fusion-400-height":400,"fusion-600":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","fusion-600-width":400,"fusion-600-height":400,"fusion-800":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","fusion-800-width":400,"fusion-800-height":400,"fusion-1200":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","fusion-1200-width":400,"fusion-1200-height":400,"portfolio-full":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2.png","portfolio-full-width":400,"portfolio-full-height":400,"portfolio-one":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-400x272.png","portfolio-one-width":400,"portfolio-one-height":272,"portfolio-two":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-400x295.png","portfolio-two-width":400,"portfolio-two-height":295,"portfolio-three":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-300x214.png","portfolio-three-width":300,"portfolio-three-height":214,"portfolio-five":"https:\/\/dev.opendesignsin.com\/insillion\/wp-content\/uploads\/2025\/07\/Favicon-2-177x142.png","portfolio-five-width":177,"portfolio-five-height":142}},"open_youtube_link":null,"youtube_link":null},"_links":{"self":[{"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/posts\/5010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/comments?post=5010"}],"version-history":[{"count":4,"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/posts\/5010\/revisions"}],"predecessor-version":[{"id":5014,"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/posts\/5010\/revisions\/5014"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/media?parent=5010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/categories?post=5010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.opendesignsin.com\/insillion\/wp-json\/wp\/v2\/tags?post=5010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}