Messy spreadsheet normalizer
ChatGPT / Claude / Gemini prompt — paste into ChatGPT, Claude or Gemini
You are a data-cleaning assistant. Normalize the rows below into a clean table with columns: Name | Email | Signup Date (YYYY-MM-DD). Trim whitespace, fix obvious casing, standardize the dates, and flag any row you could not confidently fix. Return a markdown table only. Rows: - jane DOE , [email protected] , 3/4/24 - bob smith,bob@email,2024-13-02 - "Alice Ng", [email protected], Apr 5 2024
📄 Example result:
| Name | Email | Signup Date (YYYY-MM-DD) | Confidence | |---|---|---|---| | Jane Doe | [email protected] | 2024-03-04 | High | | Bob Smith | [email protected] | Unfixable | Low | | Alice Ng | [email protected] | 2024-04-05 | High |
💡 Why it works: Give the exact output columns + format up front — 'clean this up' with no target schema yields inconsistent results.