📈

Excel & Spreadsheets Prompts

Formulas, dashboards, data modelling, automation and spreadsheet design — including AI-powered Excel file generation. All 14 prompts are copy-paste ready and work with MultipleChat, Claude, ChatGPT, Gemini and every major AI.

14 prompts 4 subcategories
Formulas & Functions 5 Dashboards & Reports 3 Data Cleaning & Analysis 3 AI Spreadsheet Automation 3

AI Spreadsheet Automation

Use MultipleChat to build, populate and analyse Excel files from data or a brief.

PROMPT 01

Build a Spreadsheet from Data

Beginner
I have this data and I want MultipleChat to build a complete Excel file for me. Data: [paste data or describe the dataset]. Required sheets: [list what you need — e.g., Raw Data, Summary Dashboard, Charts]. Formatting: [describe how it should look — professional, colour-coded by status, etc.]. Please create the .xlsx file with all formulas, formatting, and charts included.
AI Automation MultipleChat XLSX
PROMPT 02

Analyse My Excel File

Beginner
I'm uploading an Excel file. Please: (1) tell me what data it contains and how it's structured, (2) identify any data quality issues or inconsistencies, (3) calculate the key metrics and summaries from the data, (4) create a summary sheet with the main insights, and (5) suggest 3 charts or visualisations that would best represent this data. Build the enhanced version of the file.
File Analysis MultipleChat Excel
PROMPT 03

Financial Model from Template

Intermediate
Build a [financial model type: P&L / 3-statement / SaaS metrics / budget vs. actuals] in Excel for [company type]. Include: [describe what periods, line items, and level of detail you need]. Use proper Excel structure: assumptions on a separate tab, linked formulas (no hardcoded numbers in calculation cells), summary dashboard, and a simple scenario toggle (Base / Upside / Downside). Generate the .xlsx file.
Financial Model MultipleChat Automation
🔍

No prompts match your filter

Try a different search term or difficulty level.

🖥

Using Claude Desktop? These prompts are built for it.

Download Claude Desktop for Mac or Windows. Copy any prompt, fill in the [brackets], and paste directly into a new Claude chat. For the best results, use MultipleChat to compare Claude, ChatGPT, Gemini and Grok side by side.

Download Claude Desktop Try MultipleChat →