Business Reports CSV Conversion to Excel

We used to generate a business report (Reports>Business Reports>Transaction Reports+date range) to established a rolling daily total of sale and gross revenue.
At the end of a month/week, it was them a simple copy and paste job in to excel to create a rolling total which built to a financial year that took a few seconds. This is important for us as, with our Amazon account we need to keep below VAT registration threshold. Simple. Easy. Quick. However Amazon changed the system.

This methodology is no longer possible as colum data will be integrated and reformatted both via C+P and via a CSV download - does anyone know the simplest method of transferring this data to Excel, either by preserving the Amazon generated column format shown on the seller dashboard or converting the data to relevant Excel columns?
Thanks