Feature Request/Idea: How to handle excel files with multiple sheets

Overview of the Feature Request

When we upload an Excel file with multiple sheets, only the first gets converted to .tab format in the ingestion process. So, if we want to download data from dataverse in Rdata format, for example, we can't access the other sheets. User must download the original excel .xlsx file in order to have access to the data.

I believe it's not that easy for some data providers to split their multi-sheet excel files into separate .csv files. It might not make sense for them to split the data. Thus it would be good if Dataverse could handle these cases.

What kind of user is the feature intended for?
Depositor, data user

What inspired the request?

I recieved data from an experiment that had multiple sheets, one for climate data, one for experiment design, another for fertilizer treatment, irrigation etc. It makes sense for all this data to be in a single excel file, with multiple sheets. But when uploading it to dataverse, only the first sheet was converted.

What existing behavior do you want changed?

When uploading .xlsx with multiple sheets, all sheets gets converted to .tab. That could be by creating one .tab file for each sheet, ex.: myData.xlsx with two sheets would become myData.sheet1.tab and myData.sheet2.tab.

Another option would be a folder type structure for stored data. (not sure if that is possible)

Any brand new behavior do you want to add to Dataverse?

Generate more than one .tab file when uploading multiple-sheet excel files.

Any related open or closed issues to this feature request?

A related discussion is at: https://github.com/IQSS/dataverse/issues/7452

Start by reviewing Dataverse's ingestion process and the related discussion in issue #7452. The requested behavior is for a multi-sheet .xlsx upload to produce one .tab file per sheet, while preserving access to all sheets.