Python Data Entry Automation Script

I have a repetitive data-entry routine that currently relies on manually copying information from a set of Excel/CSV files into another system. I’d like a concise Python script that will pick up the source files from a local folder, extract the required fields, apply any simple cleaning rules (trim spaces, check for nulls, fix obvious typos), and then push the results into the target template automatically.

The workflow at a glance
• Watch or scan a specified directory for new Excel/CSV files
• Parse each file, map columns to my destination format, and write the consolidated output (CSV is fine)
• Log any rows that fail validation so I can review them later

I’m fine with standard libraries such as pandas, openpyxl or csv, whichever you’re most comfortable with for quick turnaround. A clear README and well-commented code are all I need for hand-off; no UI is required. If you can wrap the whole thing in a reusable function and include a small sample dataset to prove it works, that will be perfect.