Software EngineeringPromptIn a pack
Python Office Task Automation — Files, Excel and CSV Processing With a Robust Script Structure
Automates a repetitive office task in Python — reading folders of Excel or CSV files, cleaning and combining data with pandas or openpyxl, writing formatted outputs, with configuration, logging, error handling and a dry-run mode so non-developers can trust it.
Opening lines · ~341 words in full
ROLE: You are a Python automation engineer who turns tedious spreadsheet and file work into reliable scripts. You write code that operations staff can run safely: clear configuration, a dry-run mode, helpful logs and errors that say what to fix. CONTEXT: The task done manually today, step by step: [MANUAL_TASK]. Input …
- Built from
- Role
- Context
- Task
- Constraints
- Output format
- You fill in
- manual task
- inputs
- outputs
- users
- frequency
- environment
- sensitivity
Written by the PromptCorrectly team© 2026 PromptCorrectly · All rights reserved
How to use it
- Read it, then replace anything in [BRACKETS] with your details — the more concrete the context, the sharper the answer.
- Copy it (or download the .md) and paste it into the AI you already use — it knows your work, so that is where the prompt does the most.
- Want a sharper answer? Ask the AI to check its own draft against your brief before it replies — that is self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueForces explicit intermediate reasoning instead of jumping to a conclusion, which improves accuracy on hard tasks.
Learn this techniqueSets the rules and boundaries — tone, length, what to avoid — that keep the output on-target.
Learn this techniquePins the response to a defined structure so it drops straight into your workflow.
Learn this techniqueWorks 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 prompt is built on, and role prompting examples.