Not able to upload Excel with multiple sheets at one go as a data-source

[apjvinod]

Hi @HimaniS

Thanks for reaching out , currently its not possible to combine multiple sheets and load into Quick Sight datasource.

One workaround is discussed in the below community post by using python pandas dataframes to combine it .

Best way to work with multiple-sheet excel file?

Hi, Thanks for reaching out. One recommendation that would not require you to individually load the files and combine them which would understandably be pretty tedious, would be to do this in Python and Pandas. read_excel() method in Pandas can return a dictionary of data frames, one DF per sheet. Then just need to concat() into one DataFrame and write to the file type of your choosing. You can then upload that single file. Sean

At AWS, our roadmap is primarily driven by our customers.
Your feedback helps us build a better service, I have tagged this as feature request.

If you could message me separately with AWS Account id & your organization name will update the internal product feature requests.

Thanks
VInod