Excel Zip to Clean CSVs

Замовник: AI | Опубліковано: 05.12.2025
Бюджет: 30 $

I have a series of ZIP archives that each contain one or more Excel workbooks. I need a repeatable solution that automatically unpacks those archives, converts every worksheet to a CSV, and then makes the resulting files available for straightforward download. While most of the structure can stay intact, I do need light data cleansing during the process—specifically, removal of duplicate rows and correction of obvious entry errors so the CSVs are analysis-ready the moment they are generated. A Python or similar script that leverages pandas or another robust data-handling library is perfectly fine as long as it runs reliably on a standard Windows or Linux environment. Command-line execution is acceptable; a simple UI or command flag to set the output folder would be a bonus but not essential. Deliverables: • A working script or utility that unzips, converts, and cleans the data in one pass • Clear instructions for setup and use • A short sample run (before/after files) to prove duplicate-removal and error-correction are working I’m ready to test as soon as you deliver the first draft.