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

1 Like