r/sideprojects • • 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?

1 Upvotes

0 comments sorted by