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

[HimaniS]

Quicksight is not allowing to upload an Excel with multiple sheets as a whole in data source. At the time of upload, it directly takes to the sheet level to select one.
Is it possible somehow to upload the whole Excel as one as data source? It would be convenient to work with. Also, in future if there’s change in some sheets it would be better to just re-upload the whole excel.

Let me know if there’s some possibility.

Many Thanks!
Himani

[apjvinod]

Hi @HimaniS

Thanks for reaching out , currently its not possible to combine multiple sheets and load into QuickSight 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

[anil.kumar]

Thanks @apjvinod for responding us back, We will try to explore if required and get back to you for any questions