Formula and function design
Prompts that produce pasteable formulas with a plain-language explanation.
24 curated prompts
ChatGPT Prompts for Excel
Spreadsheet questions fail when the model cannot see the actual layout. These prompts force an explicit column contract, a stated assumption list, and a formula that can be pasted and tested.
ChatGPT prompts for ExcelExcel AI promptsspreadsheet prompts
Cleaning and reconciliation
Templates for deduplication, text normalisation and cross-sheet matching.
Reporting and pivots
Prompts for pivot structure, metric definitions and summary layout.
Featured AI prompt templates
Copy-ready prompts selected from this topic cluster.
TextData Analysis
Senior Data Analyst: Translating Data into Business Insights and Actionable Recommendations
Act as a senior data analyst who transforms data into business insights and actionable recommendations. Possess expertise in SQL querying, statistical analysis, A/B testing, funnel analysis, retention metrics, and more. Follow a structured analytical process: question scoping, data validation, methodology selection, statistical rigor, visualization, and action planning. Supports outputs for ad-hoc analysis, metric definition, A/B testing, and cohort analysis.
TextData Analysis
CSV Data Quality Profiler
Profiles CSV and spreadsheet data before trusting it for analysis, imports, or dashboards, infers column types, measures missing values, duplicates, mixed types, outliers, whitespace, and encoding issues, and generates a prioritized quality report with concrete fixes.
TextData Analysis
Senior Analytics Engineer Prompt
This prompt defines the role, skills, process, and best practices of a senior analytics engineer building scalable, maintainable data pipelines and analytical systems in production.
TextData Analysis
Crypto Market Outlook Analyst
Act as a professional crypto analyst to review an institution's 2026 outlook and provide a concise summary.
TextData Analysis
Energy Analysis with DJU, Consumption and Costs
Act as an energy analysis expert to analyze Degree Days Unified (DJU), energy consumption and costs between 2024-2025, compare trends, identify optimization opportunities, and produce a comprehensive report with charts and tables.
CodeData Analysis
Multi-Currency Exchange Rate Converter
Build a comprehensive currency converter using HTML5, CSS3, and JavaScript with support for 170+ currencies including crypto.
CodeData Analysis
Aviation Data Analyst: FDR Analysis Program
Develop a program that analyzes Flight Data Recorder (FDR) data from multiple aircraft types and generates detailed reports.
TextData Analysis
Scalping Analysis for Indian and Crypto Markets
Analyze charts and provide perfect readings, stop losses, buy/sell signals, profit percentages, and strategies for scalping in India and crypto markets.
TextData Analysis
Excel Data to Figma Presentation Designer
Transform Excel data into visually appealing, readable Figma presentations.
TableData Analysis
Bank Transaction Analysis
As a financial analyst, sort and detect anomalies in bank transaction data.
TableData Analysis
Data Transformer
Transform data according to input schema and produce results in a specified output schema.
TextData Analysis
Scientific Data Visualizer
Act as a scientific data visualizer, applying data science principles and visualization techniques to turn complex information into compelling visuals.
How do I describe a spreadsheet to an AI model?
Give column names, data types, two or three sample rows, and where the output should land. That is usually enough for a working formula.
Why does the generated formula error out?
Most often locale differences (comma versus semicolon separators) or merged cells. State your separator and avoid merged ranges.
Can these prompts write VBA or Apps Script?
Yes, but ask for a commented script and a manual alternative in case macros are blocked.