Movement strengthening· Medium risk

Spreadsheet cleaning instructions

Give AI or a colleague clear cleaning rules.

When to use this prompt

Reach for this prompt when you need to give AI or a colleague clear cleaning rules. It's designed for Data lead, Admin. Typically used within Data work.

Draft with AI, then have a colleague verify facts and tone before use.

How to use it

1
Gather your inputs
Have your local context, audience and goal to hand.
2
Fill in the template
Copy the template below and replace every bracketed placeholder with real, local context. Keep names and safeguarding details out.
3
Run it in your AI tool
Paste into your preferred AI assistant. Ask a follow-up if the output misses your association's tone or context.
4
Review with the checklist
Work through the human-review checklist below before you send, publish or act on the output.

Prefer a guided flow? Adapt with the guided builder — it fills placeholders from your association profile.

Prompt template

Given a CSV described below, produce a cleaning instruction set: which columns to keep, standardise date format ({DATE_FMT}), trim whitespace, deduplicate on {KEYS}, redact any personal data columns, and export as {FORMAT}. Do not execute — output the steps only. Description: {DESC}

Replace bracketed placeholders with real context. Never paste identifying details about children, health or safeguarding cases.

Worked example

DATE_FMT: YYYY-MM-DD · KEYS: email · FORMAT: CSV · DESC: [describe columns]

Why this prompt works

Repeatable cleaning; auditable steps.

Was this useful?

Adapt with the guided builder