For applications of web-based analytics and business intelligence reporting, methods and systems are provided for exporting a data table as a spreadsheet pivot table by automatic creation of formatted spreadsheet pivot tables with application specific initial views. The views are specified by templates allowing a user to view multiple pivot tables in a single spreadsheet book. Pivot tables are created by a remote server that performs the exporting of the data table so that a user can save the pre created pivot table in his/her local machine. In one embodiment of the invention, the data table on which a pivot table is subject to have a limited number of rows of a spreadsheet data sheet. In another embodiment, the data table on which a pivot table is subject to can exceed the limit of the number of rows of a spreadsheet data sheet.