Clean up a messy data table

Gives you a safe step by step plan to fix duplicates, dates, spaces and formats in a table, with a before and after on sample rows.

It will ask you for

  • Tool
  • What is wrong with the table
  • A few invented or anonymous sample rows

Prompt preview

Act as a careful data cleaning assistant. I work with [Tool] (if it is Python, use pandas). What is wrong with my table: [What is wrong with the table]. A few sample rows, invented or anonymous: [A few invented or anonymous sample rows]. Give me a …

Just this prompt

Use it on the site with your details and download it to keep.

Unlock for 3,50 €

Code and spreadsheets prompt pack Best value

All 7 prompts in Code and spreadsheets, with fields to fill in and reminders.

You save 15,10 € compared with buying the 6 prompts one by one

The whole pack for 5,90 €

Frequently asked questions

What is this prompt for?

Gives you a safe step by step plan to fix duplicates, dates, spaces and formats in a table, with a before and after on sample rows.

What do I need to prepare?

It asks you for: tool, what is wrong with the table, a few invented or anonymous sample rows.

Which AI tools does it work with?

It works with ChatGPT, Claude and Gemini: fill it in here, copy it and open it in the chat you prefer. It was tested with Claude Sonnet 5.5 on 22 October 2026.