The Library

Browse every prompt

Filter by platform, role, function or prompt type. Save the ones you want, copy them straight into your favourite AI tool.

AI platform

All platforms

ChatGPT Claude Gemini Grok Midjourney DALL-E Stable Diffusion Copilot Perplexity Notion Nano Banana Higgsfield Other

Job role

All roles

Function

All functions

Prompt type

All types

Standard prompt Agent prompt Dashboard Skill Workflow Runs on a schedule

3 prompts·Search: "clean-data"

Copilot

#data analysis

Build a pivot table in Excel from a messy export

Copilot lists the data quality issues in a messy export, applies the minimum cleanup on a copy, builds the pivot with slicers, and tells you what the pivot is actually saying.

Copy

Gemini

#data analysis

Clean up a messy column in Google Sheets

Paste in a messy Sheets column and get a single formula that fills a clean version, plus a flag column for the rows that need a human eye.

Copy

Copilot

#data analysis

Clean an Excel date column with mixed formats

Copilot identifies every date format in a messy Excel column, converts each row to your target format, flags the rows it could not parse, and respects AU locale.

Copy