Excel Toolkit for Sheets: User Guide

Last updated: November 14, 2026

Excel Toolkit brings the Excel Analysis ToolPak and Goal Seek to Google Sheets. Every tool reads a range you choose and writes the results to a new sheet. Your data is never changed, and nothing leaves your spreadsheet.

Quick start

1. Open your spreadsheet and choose Extensions → Excel Toolkit for Sheets → Open Excel Toolkit.
2. Pick a tool under Analysis tool.
3. Select your data in the sheet and click Use selection (or type a range such as A1:C20).
4. If the first row has titles, tick Labels in first row.
5. Click Run. The results open in a new sheet.

Options you will see in most tools

• Input range: the cells to analyze. Include the title row if you tick Labels in first row.
• Grouped by: Columns if each variable is a column (the usual case), Rows if each variable is a row.
• Labels in first row: uses the first row as names in the results instead of "Column 1, Column 2".
• Numbers stored as text: see Numbers that are skipped below.
• Alpha: the significance level. 0.05 gives 95% confidence intervals and critical values.

The tools

Descriptive Statistics

One column of results per variable: mean, standard error, median, mode, standard deviation, sample variance, kurtosis, skewness, range, minimum, maximum, sum, count and the confidence level for the mean. Each variable needs at least two numbers.

Regression

Linear regression with one or more X variables. Input Y range is a single column; Input X range is one or more columns with the same number of rows. The output matches Excel: regression statistics (R Square, Adjusted R Square, standard error), the ANOVA table, and coefficients with standard errors, t statistics, P-values and confidence limits. Tick Residuals to list predicted values and residuals, or Constant is zero to force the line through the origin. Rows with a blank in any variable are left out.

t-Test

Compares the means of two variables. Choose the type: equal variances, unequal variances (Welch), or paired (the two ranges are before/after measurements of the same items, in the same order). The output gives the t statistic and one-tail and two-tail P-values and critical values.

ANOVA: Single Factor

Tests whether three or more groups share the same mean. Put each group in its own column; groups can have different sizes. The output has a summary per group and the ANOVA table with F, P-value and F crit.

Correlation

The correlation matrix (Pearson) between two or more columns. Rows with a blank in any column are left out.

Histogram

Counts how many values fall in each bin and adds a chart. Bin range is optional: leave it empty for automatic bins, or give a column with the upper limit of each bin. As in Excel, a value is counted in the first bin whose limit is greater than or equal to it; larger values go to "More".

Goal Seek

Finds the input value that makes a formula reach a target, like Excel's What-If Analysis. Set cell is the cell with the formula, To value is the result you want, and By changing cell is the input cell the formula depends on (it must contain a value, not a formula). Example: find the loan amount that gives a monthly payment of 500. If no solution is found, the original value is restored. Undo Goal Seek puts back the previous value.

Numbers that are skipped

Text, dates and empty cells are ignored, as in Excel. After each run the sidebar tells you how many cells were skipped.

If cells that look like numbers are skipped, they are stored as text. This usually happens when the data uses a different decimal separator from your spreadsheet's locale, for example 5.5 in a spreadsheet set to a locale that writes 5,5. To include them, set Numbers stored as text to how your data is written:

• Decimal point for numbers like 1,234.56
• Decimal comma for numbers like 1.234,56

The toolkit never guesses: a value that does not match the format you picked stays skipped.

Troubleshooting

• "Google blocked this request" or PERMISSION_DENIED: this is a Google limitation when more than one Google account is signed in to the same browser. Open the spreadsheet in a browser profile or private window where only one account is signed in.
• "Your first row looks like titles": tick Labels in first row and run again.
• "The X variables are collinear": one X column is a combination of the others (for example a duplicate, or a total of other columns). Remove it.
• "needs at least 2 numeric values": the range has too few numbers. Check the range and the Numbers stored as text setting.
• The menu does not appear: reload the spreadsheet. The menu is under Extensions.

Privacy

The add-on only has access to the spreadsheet you open it in, and calculations run inside your Google account. See the Privacy Policy.

Help

We are happy to help. One thing to know first: to protect your privacy, we cannot see your spreadsheet or anything that happens in it. All we know is what you tell us, so a good description gets you a fix much faster.

Email cellwrightapps@gmail.com and include:

• Subject: start it with excel-toolkit, so we know which add-on you mean.
• Which tool you used (for example Regression or Goal Seek).
• The exact message shown in the sidebar. Copy and paste it, or attach a screenshot.
• What happened, step by step: what you selected, what you clicked, what you expected and what you got instead.

Please do not send passwords or confidential data. Replies come from an AI support assistant with human oversight.