Forum Discussion

Michael63's avatar
Michael63
Copper Contributor
Mar 31, 2021
Solved

What's the best way to collect data from a number of Excel spreadsheets within a Sharepoint folder?

Hello community. I don't know whether this is the right space to post this question, but I haven't found a better place.    Here is my problem statement:  I need to collect inputs from a variable...
microsoft 365 apps
sharepoint
  • Michael63's avatar
    Michael63
    Apr 06, 2021
    Thanks, Allan.
    I finally found a solution by this video: https://www.youtube.com/watch?v=3GIz50pftZ0
    It shows how to apply data transformation on multiple Excel files with arbitrary filenames in a Sharepoint folder.

    Thanks so much,
    Michael
Allan_Clarke's avatar
Allan_Clarke
Iron Contributor
Apr 04, 2021
Only other suggestion I have would be to use Excel Power Query. It allows you to pull data from multiple spreadsheets. Try this for a heads up: https://www.youtube.com/watch?v=0aeZX1l4JT4
Michael63's avatar
Michael63
Copper Contributor
Apr 06, 2021
Thanks, Allan.
I finally found a solution by this video: https://www.youtube.com/watch?v=3GIz50pftZ0
It shows how to apply data transformation on multiple Excel files with arbitrary filenames in a Sharepoint folder.

Thanks so much,
Michael

Resources