Spreadsheet insights
Excel & spreadsheets 6 min setup
Turn spreadsheet analysis into an executive summary
Convert verified metrics into decisions, changes, risks, and requests without overstating evidence
Open recipeTopics
AI prompts for Excel formulas and spreadsheet work
Excel prompt templates for formulas, lookups, data cleaning, workbook design, analysis, charts, validation, and troubleshooting
Spreadsheet outputs can look correct while referencing the wrong field, hiding missing matches, or breaking on blanks. These recipes start from the real workbook layout and require representative tests before a result is trusted.
How to use this collection
- Provide exact sheet names, headers, cell references, data types, and representative rows.
- Test normal, blank, duplicate, unmatched, and error cases before filling down.
Choose a recipe
40 recipesSpreadsheet insights
Excel & spreadsheets 6 min setup
Standardize category labels in Excel
Map known label variants to an approved vocabulary while exposing unknown values
Open recipeSpreadsheet insights
Excel & spreadsheets 6 min setup
Split combined fields into Excel columns
Separate names, addresses, or codes using verified delimiters and exception flags
Open recipeSpreadsheet insights
Excel & spreadsheets 7 min setup
Reshape an Excel table between wide and long formats
Unpivot or pivot data while protecting record grain, identifiers, null meaning, and aggregation rules
Open recipeSpreadsheet insights
Excel & spreadsheets 6 min setup
Refactor repeated Excel calculations with LET
Name repeated expressions once, preserve workbook behavior, and verify that the refactor is equivalent
Open recipeSpreadsheet insights
Excel & spreadsheets 6 min setup
Normalize text formatting in Excel
Standardize presentation differences without changing identifiers or meaningful text
Open recipeSpreadsheet insights
Excel & spreadsheets 6 min setup
Generate useful analysis questions for a spreadsheet
Turn a dataset and decision into questions its fields can actually answer
Open recipeSpreadsheet insights
Excel & spreadsheets 4 min setup
Generate an Excel formula from a requirement
Turn a calculation need and real column layout into a formula you can verify
Open recipeSpreadsheet insights
Excel & spreadsheets 5 min setup
Diagnose and fix an Excel formula error
Find the root cause of an Excel error before replacing the formula
Open recipeSpreadsheet insights
Excel & spreadsheets 7 min setup
Find and investigate spreadsheet outliers
Flag unusual values with a method suited to the distribution, then investigate before removal
Open recipeSpreadsheet insights
Excel & spreadsheets 7 min setup
Find and handle duplicate records in Excel
Define duplicate identity, detect exact and near matches, and preserve conflicts for review
Open recipeSpreadsheet insights
Excel & spreadsheets 5 min setup
Extract names, emails, or codes in Excel
Build a text formula from real delimiters without assuming every row has the same shape
Open recipe