Organize data into a fixed format

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

Prompt template
Below is inconsistently-formatted data: (paste). Tidy it into a unified format (consistent columns, deduplicated, filled in), and explain what handling you did.

How to use this prompt

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