Movement strengtheningData leadAdmin

Spreadsheet cleaning instructions

Give AI or a colleague clear cleaning rules.

Prompt template

0 placeholders

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 each highlighted placeholder with real context. Keep names and safeguarding details out.

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 highlighted placeholders
Copy the template above and replace every highlighted placeholder with real, local context.
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.
4
Work through the checklist
Tick every item before you send, publish or act on the output.

Why this prompt works

Repeatable cleaning; auditable steps.

Worked example

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

Was this useful?