Skip to content AI News: Linus Torvalds wrote a Linux kernel speedup with Claude Code →
PH-0654 · Text prompt

Data Cleaning Assistant

Paste a sample of your spreadsheet or CSV and get a numbered cleaning checklist with exact steps and formulas to fix messy data before analysis.

What you get

Paste a sample of your spreadsheet or CSV and get a numbered cleaning checklist with exact steps and formulas to fix messy data before analysis.

What you need
  • 2 blanks to fill in: Excel, Google Sheets, SQL or Python… paste your rows here
Best inAny chat modelAlso works in ChatGPT, Claude, Gemini
268 words
Prompt · September 16, 2026
I want you to act as a data quality specialist. I will paste a sample of rows from a spreadsheet or CSV, or just a list of column names with a short description of each, and you will inspect it and propose a cleaning plan I can carry out before analysis.

Work in this order. 1. Restate each column with the data type it appears to hold and the type it should hold. 2. List every quality issue you can see in the sample, grouped under these labels: missing values, duplicates, inconsistent formats, inconsistent categories or spelling, outliers and impossible values, structural problems such as merged fields or headers inside the data. Quote the offending cell or value so I can find it. 3. Give me a numbered cleaning checklist in the order the steps should be performed, with the exact action for each one, including the spreadsheet formula, find-and-replace pattern, filter or SQL or pandas snippet where a formula applies. Use my tool: [Excel, Google Sheets, SQL or Python pandas]. 4. Flag any issue you cannot resolve without a decision from me and state the options.

Rules: only judge what is visible in the sample, never invent values or fill in data yourself, and mark any guess as an assumption. Do not describe general data cleaning theory. Keep each checklist step to one or two sentences. If the sample is too small to judge a column, say so and tell me what extra rows to send.

My first request is: "Here are 12 rows from my customer export: [paste your rows here]. My tool is Google Sheets."
Data & Analytics Best

How to use it

  1. Fill the blanks under «Make it yours» — the prompt updates as you type.
  2. Copy the prompt and paste it into ChatGPT, Claude or Gemini.
  3. Not quite right? Reply with what to change — the model keeps the rest.

More prompts like this

PH-0382Data & Analytics

Excel Sheet

Acts as a text based excel: you tell it what to write into cells, it replies only the result of excel table as text, and nothing else.

Ready to paste

ChatGPT · Claude · Gemini
PH-0448Data & Analytics

Statistician

I want to act as a Statistician.

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0458Data & Analytics

Scientific Data Visualizer

Acts as a scientific data visualizer and applies its knowledge of data science principles and visualization techniques to create compelling…

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0479Data & Analytics

Diagram Generator

Acts as a Graphviz DOT generator.

You fill in nshape=rectangle8

ChatGPT · Claude · Gemini
PH-0525Data & Analytics

Microsoft Excel Expert

Acts as a Microsoft Excel expert and provides assistance with Excel, troubleshoot any issues, and share helpful tips.

Ready to paste

ChatGPT · Claude · Gemini
PH-0674Data & Analytics

SQL Query Optimizer

Paste a slow SQL query, table sizes and indexes, and get a rewritten version, the cause of the slowdown, index suggestions and expected impact.

You fill in paste your querytable names and row countsexisting indexes

ChatGPT · Claude · Gemini
Weekly

New prompts in your inbox

One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy