We believe data analysis should not interfere with what is best for the data collector. FormBuilders have the freedom to build a form in any way they please to make the user experience better, and that should not limit data analysis. When you download an Excel spreadsheet of iFormBuilder Data each subform is a different tab in excel. In some cases, data needs to be compiled into a single table and it can be done in Google Sheet.
The video below demonstrates how to transform all your data including data from many different subforms and load it all into one sheet in Google Docs Sheet for analysis.