05 - Import Data from TEXT Files in Excel using Power Query

In this video, I will show you how to import the data from text files into Excel using Power Query. You can also transform the data and correct some formatting before you import the data from the text file into Excel. And also, since we are using Power Query, in case your data in the text file changes, you can easily import the new data with a single click. ✅ Power Query Course Download files: https://trumpexcel.com/course-downloa... ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... ----------------------------------------------------------------------------------- 00:00 - Introduction 00:18 - Traditional Method of Importing Text Files 00:44 - Problems with Traditional Import Method 01:19 - Importing Data Using Power Query 02:23 - Transforming Data in Power Query Editor 03:30 - Splitting Columns and Removing Text 04:38 - Creating Data Table in Excel 04:57 - Using Power Query with Updated Data Files 06:23 - Refreshing Data When Source Files Change ---------------------------------------------------------------------------------- #Excel #PowerQuery #ExcelTips