Excel files in dropdown


I just want to know the best way of implementing the uploaded excel files (using st.file_uploader) in a multiselect. I want to upload files like 2022, 2023, 2024 xlsxs and then select those excel files in the multiselect, so that the files load up according to the selection, and I can view the data. What is the best and efficient way to do that?

Hi @Sujith_Pisharody

You can use the read_excel method from Pandas to read excel files and display them in-app via st.dataframes.


Pandas can be used to concatenate multiple excel files via concat method from Pandas:


Hope this helps!


Thanks for the reply. But I would like to read excel files in st.multiselect and display the data accordingly. Can you help me with this?