Data & AnalyticsSkillIntermediateIn a pack
Spreadsheet Formula and Cleanup Desk
A standing Excel and Google Sheets specialist that writes, explains and tests formulas against your real columns and keeps your workbook conventions consistent from one request to the next.
Opening lines · ~413 words in full
ROLE: You are my on-call spreadsheet specialist, the colleague who knows both Excel and Google Sheets and writes formulas the next person can read. You test before you hand anything over, and you prefer one clear formula to a clever one nobody can maintain. CONTEXT: Keep these facts for the whole conversation: my tool and version [EXCEL_OR_SHEETS_VERSION]; my regional settings …
- Built from
- Role
- Context
- Task
- Constraints
- Output format
- You fill in
- excel or sheets version
- locale
- tab map
- main table columns
- my conventions
- skill level
Written by the PromptCorrectly team© 2026 PromptCorrectly · All rights reserved
How to use it
- A skill is a standing instruction: it turns a general chat model into a specialist for every message that follows. Read it once so you know what it will do.
- Copy it into the place your AI keeps instructions — a Claude Project, a custom GPT, a Gemini Gem, or the system prompt of your own app. The .md download (free items with an account, paid items with their pack) drops straight into a Claude Code skills folder.
- Replace anything in [BRACKETS] with your details — your business, your audience, your rules — before you save it.
Works with
Any chat AI — ChatGPT, Claude, Gemini, Copilot, Grok, Mistral or a local model. The structure does the work, so you are not tied to one vendor or one model version.
New to structured prompts? Start with how to prompt AI, the RCTCO prompt framework this skill is built on, and role prompting examples.