When you have the same data exported over and over and want to do the same thing with that data, there are two great ways to help.
1) Create a “starter” spreadsheet that already has the Pivots and “views” of the data you want. Copy the exported data into the “starter” spreadsheet and refresh all the pivots to view the new data.
2) Create a “macro” that you save in your personal macros folder that you can run against the newly exported data anytime you need it (make sure you enable macros on the newly opened document)!