Clean & Standardize Text Data

I have a collection of text-based records that needs a thorough clean-up. The job is focused on removing duplicate entries and bringing every remaining line into a consistent, well-defined format so the file is ready for downstream analysis and reporting. Here is what I expect from you: • Deliver a single, duplicate-free dataset in the original file type (CSV/Excel/Google Sheet). • Apply a uniform text standard (capitalisation, spacing, punctuation, date or code patterns where relevant) across every record. • Provide a brief change log or summary so I can see what was altered or removed. No numerical fields or mixed media are involved—just plain text. You are free to use your preferred tooling (Excel functions, Python/pandas, OpenRefine, etc.) as long as the final file opens cleanly without broken characters or hidden rows. Once the cleaned file matches the above criteria and passes a quick spot-check, I will mark the project complete. Looking forward to working with you.