1 min readfrom 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?

submitted by /u/Free_Signature_9745
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article