Which AI is this prompt for?

It works with ChatGPT, Claude, Gemini and other mainstream text AIs — just replace the bracketed parts with your own situation.

How do I adapt this prompt?

First replace the (bracketed) placeholders with your real data; if the result is too generic, add background context, specify the output format and length, and give one or two examples — the AI's answer will be more precise.

Clean messy data

A ready-to-use “Data & Analysis” AI prompt template. Replace the (bracketed) parts below with your own needs.

Prompt template

The data below is messily formatted:
(paste)

Tidy it into a unified, clean table format (consistent columns, removing duplicates and extra symbols), and explain what adjustments you made.

How to use this prompt

Copy the whole prompt above and paste it into ChatGPT / Claude / Gemini.
Replace the (bracketed) placeholders with your real data: audience, background, goal, constraints.
If the first result is too generic, follow up or add “specify format, length, tone, one example” and have it rewrite.

Clean messy data

How to use this prompt

More prompts in this category