Can I load data from a spreadsheet as the session user?

Yes. In the spreadsheet template from which you generate the spreadsheet, Upload Data As must be set to Session User. This setting is for unsecured objects and those secured objects where data security is implemented for spreadsheet data loading.