One embodiment of the invention is directed to a method for transferring data from a specified spreadsheet, having a name, rows and colunms, to a relational database table. The method includes the steps of receiving the spreadsheet at a given location, assigning a name to the relational database table that is derived from the spreadsheet name, and creating names for colunms of the table from the contents of a first row of the spreadsheet. Data types for respective colunms of the table are derived from the contents of a second row of the spreadsheet. After creation of the table, data is loaded into locations of the table from respectively corresponding cells of the specified spreadsheet.