Bank File Conversion App for Excel 2013 (BFC) is designed with PowerPivot in mind. In fact, the three outputs provided by the conversion (Excel Tables, XML and CSV) are readily imported into PowerPivot for further analysis.
This post uses a sample workbook that you can access here. Once the workbook is opened in Excel Online, click File–> Save As–> Download Copy.
Why PowerPivot? Because it unleashes incredible capabilities in Excel. There are three that come to mind immediately: 1) no table size restrictions in PowerPivot (Excel maximum is about a million) 2) in PowerPivot one can join tables imported from a multitude of sources and 3) in PowerPivot large numbers of data sources can add data tables to the data model.