Clean Mixed CSV Data

I have several Excel/CSV files that contain a mix of text and numeric fields. They need a thorough data-cleaning pass so the information is analysis-ready: duplicates removed, spelling and capitalization standardized, numeric columns properly typed, and obvious entry errors fixed. You’re welcome to use the tools you know best—Excel functions, Power Query, VBA, or Python (Pandas) all work for me—as long as the final output is a clean, well-structured CSV plus a short log that explains the key transformations you performed.