This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
Function: extract txt file in different subfolder. Need info of text file timestamp and content. Content txt file is xml code.
Issue: I am not able to extract the content as the power pivot detect the text file as xml and it populate the xml table. How to make it read the content without xml connection?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Use Power Query to import / read the files, see video below.
Andreas.
Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube
Could you share us some test file to reproduce your issue?
For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.