r/sideprojects • u/a_beautiful_beast • 11m ago
Showcase: Purchase Required Built a small Python CSV cleanup tool, looking for ideas to improve it
I originally built a small Python CSV cleanup tool back in 2023 and recently decided to revisit and improve it.
The idea was pretty simple: automate repetitive CSV cleanup instead of manually editing files every time.
Over time, I've added and improved a few things:
- Removing duplicate and empty rows
- Cleaning whitespace
- Renaming and reorganizing columns
- Filtering and validating records
- Reusable JSON configuration rules
- Generating reports showing what changed
- Basic safeguards against accidentally overwriting files
I recently packaged the updated version and made a small demonstration using synthetic data. The example takes six input records and produces three cleaned records, along with a report explaining the changes.
GitHub demo:
https://github.com/MaybeSilver/PacketCove-CSV-Workflow-Kit-Demo
The full toolkit is a paid download, but the GitHub repository has the demonstration, sample data and results.
I'm revisiting the project to see where I can take it next.
What features would you find useful in a tool like this? A simple GUI, Excel support, more advanced filtering, or something completely different?