I’m working with an Excel/CSV file that lists every e-book we distribute, and it needs a careful tidy-up before it can go live in our system. The three pain points are clear: • Remove every duplicate record. • Correct obvious errors that have crept into the sheet. • Standardise formats so fields read consistently across the file. Author names, publication dates, and title fields are the columns that matter most, so the work should start there. I’m happy for you to use whatever workflow suits you best—Excel & Power Query, Google Sheets, or a Python/pandas script—as long as the final spreadsheet opens cleanly in Excel and keeps the original column order. Deliverables 1. A cleaned .xlsx (or .csv) containing zero duplicates, corrected entries, and uniform formatting. 2. A brief report—one page is fine—summarising what you found, the rules or scripts you applied, and any lingering anomalies I should know about. Consistency, accuracy, and a clear audit trail are key. If that sounds straightforward, let’s get the file polished.