Whirlpool user Alicia2 wanted to extract Word document metadata into a Spreadsheet. It should return something like Name = Sheet1, Data = Table.
That seemed like an interesting problem and something I could use some time. I built this Spreadsheet that you put into a folder along with the Word documents (DOCX format). Click on Table Edit the data in the table as you normally would with Power Query. Make sure “Expand Column” is selected and then click OK.
This is how you consolidate data and merge sheets in Excel.
I hope you will find the information in this short tutorial helpful.
The latter is a visual user-friendly tool that lets you compare two Excel spreadsheets by a common column(s) and pull matching data from the lookup table.Plus, find out how to create animated slideshows from still images using a similar Timeline-based workflow.I had read an interesting request on the Whirlpool forum over the weekend.The Spreadsheet then uses Power Query to suck in the file names in the folder (manual refresh required). I found Create a new folder in your sharepoint site. Once you have the data the way you want it in Power Query, turn the query into a function. Add the code as shown below Save the Power Query Create a new query to import all the files located in your Share Point folder Once you have the files you need, create a custom column that uses your function produced in the first step above. You should end up with your consolidated table of data something like this.Finally you click the Extract Metadata button, and the Spreadsheet does the rest. Add all the files you want to consolidate into this folder. First rename the Query to something like f Get My Files Share Point. If you want a comprehensive lesson on how to use Power Query, checkout my training course here Matt Allington is the owner and principal consultant at Excelerator BI Pty Ltd.