•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
Tagged with
#real-time data collaboration
#real-time collaboration
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#workflow automation
#bank CSV files
#data cleaning
#Excel
#Power Query
#manual cleanup
#date formats
#time-saving
#column names
#debit/credit columns
#workflow
#productivity
#automation
#formulas