•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a better way to clean bank CSV files than doing it manually in Excel?
Feels like I’m wasting hours every month on something that should be simple…
I download CSV files from different banks and platforms, and every single one comes out differently: column names don’t match , date formats are all over the place ,sometimes there are separate debit/credit columns ,sometimes everything is combined
By the time I get everything cleaned up in Excel so I can actually use it, I’ve already lost a ton of time.
I’ve tried a few things (Power Query, manual cleanup, formulas), but it still feels way more complicated than it should be.
Curious how you guys are handling this?
Do you have a workflow or a method that actually saves time?
[link] [comments]
Want to read more?
Check out the full article on the original site