The weekly grind
The same messy export, cleaned by hand, every single week.
Excel chokes on the big files, mangles your leading zeros, and only removes exact-duplicate rows. Web cleaners want you to upload customer data you’re not allowed to share. So you trim, find/replace, and dedupe by hand—again—and hope you didn’t miss a cell.
The CSVPrune workflow
Compose the cleanup once → save a recipe → drop in next week’s file.
CSVPrune opens what Excel can’t, fixes encodings and delimiters, dedupes by any key, and builds calculated columns with a live preview—then captures the exact steps as a replayable recipe you can batch-run or hand to a watch folder. All on your machine, with nothing uploaded.