CSV Data Cleanup & Formatting

I have several raw CSV files that need to be transformed into tidy, analysis-ready tables. Everything will start in their current CSV format, but the finished, cleaned datasets must work flawlessly in both Excel and Google Sheets so the team can pick up where you leave off.

Here’s what I need from you: every duplicate row must be removed, all formatting inconsistencies corrected, and any missing data filled or flagged using sensible, well-documented rules we agree on up front. I don’t just want a quick sweep—I need reliable, repeatable logic so the next import of data can be cleaned the same way.

Please tell me about projects where you handled similar data-quality challenges. A concise note outlining your experience is all I’m after; no lengthy proposals required. If we’re a good fit, I’ll share a small sample file so you can show your approach before we move on to the full batch.