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

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