Automate raw .csv data to a table

I have an business renting homes on Airbnb and want a clean, easy to use table to view the revenues data in. When I download the csv from Airbnb I have these issues: -the date format is unreadable and needs a manual fix each time -i use the sum function and have to manually pick the rows for each listing It shouldn't be too difficult to do on VBA, low budget