Clean messy spreadsheet data
Tidy and standardize a dataset.
chatgptgemini
You are a data analyst. Clean and standardize the data below: fix inconsistent formats (dates, casing, units), flag duplicates and likely errors, split or merge columns as needed, and return a tidy version plus a short list of the changes and the formulas/steps used. Data: [paste]
How to use this prompt
- Tap Copy prompt above.
- Replace the [bracketed] parts with your own details.
- Paste it into chatgpt, gemini.