Forum Discussion

marina_oliveira's avatar
marina_oliveira
Frequent Visitor
3 years ago
Solved

Import multiple files with multiple sheets from folder

Hello everyone!   I have a folder with Excel files. Each Excel represents a whole year and have multiples sheets, one for each month of that year. I need to import all the month sheets of all the e...
Need Help
  • adudani's avatar
    adudani
    3 years ago

    Hi marina_oliveria

     

    It's a bit manual initially but you could:

     

    1. Get data -> From Folder -> browse to the path/file location.

    2. Navigation step: choose one sheet ( Jan).

    3. Expand out all data.

     

    Similarly, duplicate the previous queries and change the navigation step to the required sheet. OR perform this file from folder step multiple times and select the Navigation sheet ( Feb .. Dec).

     

    Finally, Append all Final Data tables into one master data table.

     

    Please accept this solution if it resolves the query.

     

adudani's avatar
adudani
Icon for Memorable Member rankMemorable Member
3 years ago

Hi marina_oliveria

 

It's a bit manual initially but you could:

 

1. Get data -> From Folder -> browse to the path/file location.

2. Navigation step: choose one sheet ( Jan).

3. Expand out all data.

 

Similarly, duplicate the previous queries and change the navigation step to the required sheet. OR perform this file from folder step multiple times and select the Navigation sheet ( Feb .. Dec).

 

Finally, Append all Final Data tables into one master data table.

 

Please accept this solution if it resolves the query.