ChatGPT Text prompt

Clean Up a Messy Customer List

Fix inconsistent names, phone numbers and cities in a customer list — with formulas or a cleaned table.

Free No login · Commercial use allowed · Copy and use
  • 0 times copied
  • 74 words
  • Updated November 10, 2026

The prompt

I have a messy customer list with problems like: names in different cases, phone numbers with +91/spaces/dashes, cities spelt differently (Bombay/Mumbai), duplicates.
Here are 15 sample rows (fake or masked data): [paste rows].

1. List every type of problem you see.
2. Give Google Sheets / Excel formulas to fix each one (proper case, clean 10-digit phone, standard city names).
3. Show how to find and remove duplicates safely.
4. Show the cleaned version of my sample rows.

What to write in the [brackets]

ReplaceWith
[paste rows]Sample rows — mask real phone numbers

How to use this prompt

  1. Click "Copy prompt" above.
  2. Open ChatGPT (the free version works for most prompts).
  3. Paste the prompt and replace every part in [square brackets] with your own details.
  4. Send it, then ask follow-up questions to improve the answer (e.g. "make it shorter", "write it in Hindi").
  5. Check facts, prices and numbers before you use the result with customers.

Tips for better results

  • Work on a copy of your sheet, never the original.
  • Keep a 'City mapping' table for spellings like Bombay → Mumbai.

Try these variations

After the first answer, send one of these as a follow-up message:

  • Write a short checklist so my team enters data correctly next time.

FAQ

Does this prompt work only with ChatGPT?

No. It works in ChatGPT, Gemini, Claude and most other AI chat tools. Results vary a little between tools.

Is this prompt free to use for my business?

Yes. All prompts in the Cracckk Prompt Library are free, including for commercial work. Always check AI output before you publish or send it.

Can I use it in Hindi or another Indian language?

Yes. Add a line like "Reply in Hindi" or "Use Hinglish" at the end of the prompt.