The latest articles on DEV Community by Alex Bermudo Jr. (@alexjrb0226a11y). https://dev.to/alexjrb0226a11y https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4094641%2Fa73bbd5a-acb4-430f-824f-1deea5767659.png https://dev.to/alexjrb0226a11y en Alex Bermudo Jr. Tue, 25 Aug 2026 18:44:30 +0000 https://dev.to/alexjrb0226a11y/introducing-bermudogreenjs-a-free-zero-dependency-excel-spreadsheet-formula-engine-for-vanilla-47c https://dev.to/alexjrb0226a11y/introducing-bermudogreenjs-a-free-zero-dependency-excel-spreadsheet-formula-engine-for-vanilla-47c <p>Hey everyone! 👋</p> <p>I'm excited to introduce <strong>BermudoGreen.js</strong>, a lightweight, completely free, and open-source Excel spreadsheet and formula calculation engine built for Vanilla JavaScript.</p> <p>Many modern spreadsheet solutions for the web come with expensive licensing fees that can cost developers thousands of dollars. I wanted to create a simple, reliable, zero-dependency alternative that anyone can integrate into their web applications without worrying about enterprise-level pricing or restrictive licensing.</p> <p>The goal is straightforward: make spreadsheet functionality accessible, affordable, and easy to use for students, indie builders, and new developers.</p> <h3> 🚀 Key Features </h3> <ul> <li>🧮 <strong>Built-in Formula Engine:</strong> Full support for <code>SUM</code>, <code>AVERAGE</code>, <code>COUNT</code>, <code>COUNTA</code>, <code>COUNTIF</code>, <code>SUMIF</code>, <code>ROUND</code>, <code>ABS</code>, <code>IF</code>, <code>IFS</code>, <code>CONCAT</code>, <code>TEXTJOIN</code>, <code>VLOOKUP</code>, <code>HLOOKUP</code>, <code>INDEX</code>, <code>MATCH</code>, and standard math <code>(+ - * / ^ %)</code>.</li> <li>🪄 <strong>Formula Bar (<code>fx</code>):</strong> Interactive formula bar with dynamic multi-color range highlighting and IntelliSense auto-complete tooltips.</li> <li>📊 <strong>Excel Layout:</strong> Automatic column letters (<code>A, B, C, D...</code>), row numbers (<code>1, 2, 3...</code>), double-click auto-fit, and drag-to-resize columns.</li> <li>🔢 <strong>1-Click Number Formatting:</strong> Right-click column headers or cells to format as Currency (<code>$1,234.56</code>), Percentage (<code>12.5%</code>), Integers, Decimals, or Dates.</li> <li>📋 <strong>Excel Clipboard Support:</strong> Seamless copy/paste (<code>Ctrl+C</code> / <code>Ctrl+V</code>) directly to and from Microsoft Excel or Google Sheets.</li> <li>⏪ <strong>Global Undo / Redo:</strong> Full history management via <code>Ctrl+Z</code> and <code>Ctrl+Y</code>.</li> <li>⚡ <strong>Zero Dependencies:</strong> Pure Vanilla JavaScript, HTML5, and CSS. No heavy framework required.</li> </ul> <h3> 💻 Quick Start </h3> <p>You can try the live demo or clone the repository directly from GitHub:</p> <ul> <li> <strong>GitHub Repository:</strong> <a href="https://github.com/alexjrb0226-a11y/BermudoGreen" rel="noopener noreferrer">https://github.com/alexjrb0226-a11y/BermudoGreen</a> </li> <li> <strong>Live Demo:</strong> <a href="https://alexjrb0226-a11y.github.io/BermudoGreen/" rel="noopener noreferrer">https://alexjrb0226-a11y.github.io/BermudoGreen/</a> </li> </ul> <h4> Drop into your HTML: </h4> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code> html &lt;link rel="stylesheet" href="css/Custom.css"&gt; &lt;script src="js/bermudoGreen.js"&gt;&lt;/script&gt; &lt;div id="spreadsheet"&gt;&lt;/div&gt; </code></pre> </div> javascript webdev opensource showdev