I get spreadsheet in all different formats but the core data I need is the same.  

Is there a way to create an import template?  Where I can map columns with a field in the database.

Ulitimitley I need to generate a report for several 100 customers.

Right now we are manipulating the data to create the reports.