Claude prompt to write an Office Script for Excel
An Office Script prompt for ChatGPT or Copilot that produces a working Excel script in TypeScript, built on ranges and tables rather than cell-by-cell loops.
Tuned for Claude · structured role / context / task / output
Open in the builder →Ready-to-use prompt
# Role You are an experienced workflow-automation architect who designs reliable, maintainable automations on the platform in use: a precise trigger, exact connector and action names, explicit conditions, error handling, and a test plan. # Context Write an Office Script that cleans a raw export sheet, removes duplicate rows, and builds a summary table on a new sheet. # Task Design the automation described in the context above for the stated platform: the trigger, each action in order with exact connector or action names, the conditions and approvals, error handling and retries, and how to test it before it goes live. # How to approach this You reason carefully on your own. Work the problem through internally and return a clear, well-structured answer — there's no need to spell out scratch work in <thinking> tags. Use that internal reasoning to catch edge cases before you commit, and scale the depth of thought to the difficulty of the task. - Lay the automation out in order: trigger, each action, the conditions and branches, error handling, then a test plan. Before you finalize, verify that the trigger fires on exactly the intended event and nothing else; every action names the real connector, action, or command for the stated platform; the first failure has a handling path: retry, notify, or stop; the test plan covers the main path and that first failure. # Constraints - Do not invent connector, action, or command names. If unsure one exists, say so and use the closest real alternative. - Use clear markdown sections and headings. Favor well-structured, thorough output over terse output. - If a critical detail is missing or genuinely ambiguous, ask a brief clarifying question before continuing; otherwise state your interpretation in one line and proceed. - Do not open with "I'd be happy to help" or any variant. Just start. - Do not add "Note:", "It's worth mentioning", or "I should point out" framing — put facts in the deliverable, not in disclaimers around it. - Treat clearly benign tasks as safe and complete them directly. - Deliver the result directly — no apologies or meta-commentary about the prompt itself. # Output format Return only the requested output. If multiple distinct variants would clearly help, label them (e.g., "Option A", "Option B"). # Done when - the output fully answers the goal in the Context section with no missing parts
Customize this prompt
Answer a few quick questions and Promptivo re-tunes the prompt above to your exact situation.
Start the interview →Why this prompt works
Office Scripts use the ExcelScript API, not VBA and not Node, so the prompt pins the API and asks for range and array operations, which is where performance and correctness live.
Scripts cannot reach email, Teams or the web on their own. The prompt says when to hand off to a Power Automate flow that runs the script.
Sheet and table names are the most common failure, so the prompt requires them to be checked before any write.
Using this prompt in Claude
For office script excel, Claude is a strong choice — it's especially good at careful step-by-step reasoning and cleanly structured long-form writing. Promptivo formats this prompt the way Claude works best: explicit step-by-step thinking and clearly delimited output sections.
Paste it into claude.ai or the Claude desktop app, then replace any bracketed details with your own. Claude sometimes opens with caveats, so this prompt tells it to lead with the answer and keep each section clearly delimited.
Tuned for Claude: how it differs
| Model | What Promptivo changes |
|---|---|
| ChatGPT | Concise instructions, strict format adherence, no preamble. |
| Claude | Explicit step-by-step thinking and clearly delimited output sections. |
| Gemini | Precise phrasing with brief reasoning cues where they improve accuracy. |
| Copilot | Office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps. |
Questions, answered
- What is the difference between an Office Script and a VBA macro?
- Office Scripts are TypeScript, run in Excel on the web and desktop, and can be called from Power Automate. VBA runs only in desktop Excel and needs a macro-enabled workbook. Pick Office Scripts for cloud and automation, VBA for desktop-only legacy files.
- Can an Office Script send an email?
- Not by itself. Return the data from the script and let a Power Automate flow send the email or Teams message.
- How do I make an Office Script fast?
- Read a range into an array once, work in memory, and write back once. Avoid per-cell loops and repeated getRange calls. The prompt asks for this pattern.
- Is Claude good for office script excel?
- Yes. Claude handles office script excel well thanks to its careful step-by-step reasoning and cleanly structured long-form writing, and Promptivo tunes the prompt to match — explicit step-by-step thinking and clearly delimited output sections. Paste it into claude.ai or the Claude desktop app.