Statistical analysis
Descriptive statistics, regression, ANOVA, correlation, histograms and hypothesis tests.
Google Workspace™ Marketplace · Free plan · 14-day Pro trial
Advanced statistics, Solver and simulation in Google Sheets™.
Sheet Analyst adds guided statistics, regression, ANOVA, Solver, What-If analysis, Monte Carlo simulation and workbook audits to Google Sheets™. Run the analysis beside your spreadsheet and review the results in your workbook.
Free plan · optional 14-day Pro trial · no card required
WORK SMARTER IN SHEETS
What would you like to do?
Choose a workflow to analyze data, model a decision or prepare your workbook.
ΣData AnalysisStatistics, regression and tests
◇Decision MakingSolver, scenarios and what-if
∿Simulation & ForecastingMonte Carlo and forecasts
↻Data PreparationClean, combine and transform
Explore by question
Which Sheet Analyst tool should you use?
Choose a question to see which tool fits, what it needs, and how to check the result.
StatisticsRun guided descriptive statistics, histograms, regression, ANOVA, correlation and hypothesis tests in Google Sheets™ with Sheet Analyst.Read guide SolverUse Sheet Analyst Solver to maximize, minimize or target a formula result by changing spreadsheet inputs subject to model constraints.Read guide What-If AnalysisCompare assumptions in Google Sheets™ with Goal Seek, one- and two-variable Data Tables, and saved scenarios in Sheet Analyst.Read guide Monte Carlo SimulationModel uncertain assumptions in Google Sheets™ with Sheet Analyst Monte Carlo simulation, repeatable seeds and workbook-based result reports.Read guide Data PreparationUse Sheet Analyst to reconcile similar records, combine or join ranges, and reshape spreadsheet data after built-in cleanup is not enough.Read guide Workbook AuditReview formula errors, hardcodes, inconsistent formulas, volatile functions, external dependencies and model differences with Sheet Analyst.Read guide
Work in your current spreadsheetOpen tools from the Sheet Analyst sidebar
Keep calculations in SheetsYour spreadsheet data stays in Google Sheets™
Try it before you upgradeFree plan · optional Pro trial
Analysis in one add-on
Analyze data and test decisions in Google Sheets™.
Sheet Analyst brings statistical analysis, optimization, What-If tools, simulation and workbook checks into one add-on for analysts, finance teams, operators and students.
Decision modeling
Use Goal Seek, Solver, scenarios and Data Tables to test spreadsheet models.
Risk and simulation
Run Monte Carlo analysis to examine uncertain assumptions and possible outcomes.
Workbook review
Audit formula patterns, trace dependencies and compare model ranges.
Use both
Use Google Sheets™ for cleanup; use Sheet Analyst for statistics, Solver and simulation.
Google Sheets™ already includes pivot tables, text splitting, filters and duplicate removal. Open Sheet Analyst for regression, statistical tests, Solver, scenario analysis, simulation and formula review—all from the same spreadsheet.
One add-on
Statistics, optimization and simulation in one place.
Use Sheet Analyst for regression and statistical tests, optimize a model, compare assumptions, or simulate uncertain outcomes. Data matching and workbook-audit tools are included too.
- Statistics
- Solver
- What-If analysis
- Simulation
- Workbook review
- Analysis and statistics
- Solver and Goal Seek
- Data Tables and scenarios
- Monte Carlo simulation
- Data matching and workbook audit
Inside Sheet Analyst
Analyze and model without leaving Google Sheets™.
See how Sheet Analyst handles regression, Solver, What-If comparisons and Monte Carlo simulation.
Decision Making
Solver
Optimize an objective while respecting changing cells and business constraints.Objective cellModel!$D$12
MaximizeMinimizeValue of
Changing cellsInputs!$B$4:$B$8
Model!$F$8:$F$12≤Limits!$B$2:$B$6
Linear model detectionStop safely
What-If Analysis
Goal Seek
Work backward from a target result to the input value that achieves it.Set cellForecast!$D$12
To value250,000
By changing cellAssumptions!$B$6
Target reachedChanging value: 18.42% · Residual: 0.00003
Sensitivity
Data Tables
See how one or two inputs change the result across a decision grid.Row input: B6Column input: B7
Margin8%10%12%1,0001842052261,5002612923232,000338379420
Simulation
Monte Carlo
Model uncertainty with probability distributions, percentiles and charts.P10
182kMedian
247kP90
329k
182kMedian
247kP90
329k
10,000 iterations completeFast Local
Statistics
Regression
Generate model statistics, ANOVA output and coefficient estimates.Regression statisticsObservations: 240
VariableCoefficientP-value
Intercept12.4820.002
Price-1.9300.018
Campaign4.2160.006
R² 0.84Results written to a new sheet
Privacy by design
Your workbook is not our business.
Sheet Analyst works with the spreadsheet you have open. Better Work Apps does not receive your cell contents, formulas, sheet names or spreadsheet identifiers.
Browse the tools
Choose a category.
Open a section to see which analyses and model tools it includes.
Compare Free and Pro →Statistics and analysisSummarize data, test relationships and fit regression models.12
- Descriptive statistics
- Histograms and frequency distributions
- Correlation and covariance
- Linear and logistic regression
- ANOVA
- t-tests, z-tests and F-tests
- Rank and percentile
- Moving averages and exponential smoothing
- Fourier analysis
- Random and periodic sampling
- Outlier detection
- Bootstrap confidence intervals
Decision modelingSet a target, optimize values within constraints, or compare scenarios.6
- Solver with objective and changing cells
- Linear and mixed-integer optimization
- Solver constraints and sensitivity reports
- Goal Seek
- One- and two-variable Data Tables
- Scenario Manager
Simulation and forecastingRun Monte Carlo trials and time-series forecasts in your workbook.7
- Monte Carlo simulation
- Common probability distributions
- Repeatable simulation seeds
- Multiple uncertain inputs and result cells
- Simulation output reports
- Moving-average forecasting
- Exponential-smoothing forecasts
Data preparation and reconciliationMatch similar records, combine ranges and reshape tables.6
- Fuzzy matching
- Combine and join ranges
- Reshape tables
- Split names and dates
- Clean inconsistent values
- Compare two ranges and identify differences
Workbook and model auditCheck formula patterns and trace links between cells.7
- Formula-error and hardcode scans
- Copied-formula consistency checks
- Volatile-formula checks
- Full-column-reference and external-dependency checks
- Trace formula precedents and dependents
- Compare workbook versions and ranges
- Excel-to-Google Sheets™ compatibility review
Before you install
Sheet Analyst questions
Does Sheet Analyst replace built-in Google Sheets™ features?
No. Google Sheets™ already handles everyday filtering, pivot tables and common cleanup. Sheet Analyst complements it with guided statistics, Solver, What-If tools, Monte Carlo simulation and workbook review.
Is there a free version?
Yes. You can use the Free plan or start a 14-day Pro trial without entering a payment card. Compare plans.
Does the add-on send spreadsheet data to the publisher?
No. Cell contents, formulas, sheet names, spreadsheet IDs and calculation results stay out of requests to Better Work Apps, Polar and the licensing service. Read the privacy policy.
Who publishes Sheet Analyst?
Sheet Analyst is published by Better Work Apps, an independent software publisher. It is available from the Google Workspace™ Marketplace.
Select
Choose the cells you want to analyze or transform.
Set options
Choose the method and enter the settings for your analysis.
Review
Check the result before writing it to your workbook.
Feedback
Help us improve Sheet Analyst.
Tell us what worked, what was confusing, or which tool you need next. Leave private spreadsheet data out of your message.