Excel cannot use docx file using Get Data (manually saved docx file in txt folder, put new txt file path in Sheet1 A1, Power Query guide)
Introduction
This article provides a guide on how to use Excel to load a docx file using Power Query, specifically when the docx file has been manually saved as a txt file in a folder, and the new txt file path is put in Sheet1 A1.
Prerequisites
- Excel 2016 or later with Power Query add-in installed
- Manually saved docx file in txt format and placed in a folder
- New txt file path placed in Sheet1 A1 of the Excel workbook
Procedure
Follow these steps to load the txt file into Power Query:
- Open the Excel workbook containing the new txt file path in Sheet1 A1.
- Click on the "Data" tab in the ribbon.
- Click on "Get Data" from the Data tab.
- Select "Text/CSV" from the dropdown menu.
- Navigate to the folder containing the txt file and select the file.
- Click "Load" to load the data into Power Query.
- If the txt file contains a header row, check the "My data has headers" checkbox before clicking "Load".
- Once the data is loaded, you can perform any necessary transformations and then load the data back into the Excel worksheet.
Troubleshooting
If you encounter any issues while loading the txt file, ensure that the file path in Sheet1 A1 is correct and the txt file is located in the specified folder.
In this article, we have learned how to load a txt file into Excel using Power Query, even when the docx file has been manually saved as a txt file in a folder, and the new txt file path is put in Sheet1 A1.
References
- Microsoft Support: Connect to a text file with Power Query
- Excel Easy: Power Query: Text Files
), and an unordered list (). It does not include page layout tags like ``, `
`, etc., and it does not mention a multipage article since the purpose of generation is to provide a single-page output.