Unlock the power of dynamic what if ("what-if") analysis directly in Google™ Sheets™ — no coding or complex formulas required.

The Data Table Add-on brings the familiar functionality of Excel’s What-if one-variable and two-variable data tables into Google™ Sheets™, making it easier than ever to analyze how different input values affect your results.

✅ Key Benefits
Save time by automating repetitive calculations across input variations

Visualize scenarios instantly without re-writing formulas

Test outcomes across different pricing, quantity, cost, or rate changes

No technical skills needed — simple UI with point-and-click cell selection

Works seamlessly in your existing Sheets™ — no special setup required

🔍 What It Does
With just a few clicks, the add-on allows you to:

Create One-Variable Data Tables — see how changing one input affects a calculation

Create Two-Variable Data Tables — analyze combinations of two variables on a result

Reuse existing formulas — just point to your input and formula cells

Automatically fill in calculated results for each scenario

💡 Example Use Cases
Financial modelling: Test how profit changes as you vary unit cost or sales volume

Loan calculators: Analyze monthly payments based on different interest rates and terms

Business forecasting: See how changes in price and demand affect total revenue

Education tools: Help students explore mathematical relationships between variables

Startup planning: Simulate different pricing tiers to understand revenue projections

Whether you're a business analyst, a finance student, or just a spreadsheet enthusiast, the Data Table (or DataTable) Add-on gives you the tools to explore possibilities and make data-driven decisions — right inside Google™ Sheets™.