Movement strengthening· Medium risk

CSV column mapping helper

Map messy incoming columns to your schema.

When to use this prompt

Reach for this prompt when you need to map messy incoming columns to your schema. It's designed for Data lead. 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 the source columns {SOURCE} and target schema {TARGET}, propose a mapping. Flag columns with no obvious match, and any fields that likely contain personal data needing extra care.

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

Worked example

SOURCE: [list] · TARGET: [list]

Why this prompt works

Cuts a boring hour to five minutes.

Was this useful?

Adapt with the guided builder