Uploaded February 2026 | Updated November 2026, 3 days ago
Excel has just made Power Query optional with these new functions: IMPORTCSV and IMPORTTEXT.
β¬οΈ Download the example file here and follow along: bit.ly/import26file
βΆοΈ Excel LET Function video: youtu.be/5eOII3sq8wY
π©βπ« Join my Excel and Power BI courses: bit.ly/import26courses
β¬οΈ Join the Microsoft 365 beta program: techcommunity.microsoft.com/category/microsoft365/kb/microsoft-365-insider-kb
Excel has two new functions that make importing data from CSV and Text files super easy and most importantly, completely transparent.
Donβt get me wrong, Power Query is still my favourite tool for gathering and cleaning data, but CSV and Text Files are typically already clean, so Power Query can feel like overkill.
Plus, if anything goes wrong down the track, the Power Query settings are all encoded in the query editor, which can be daunting to try and troubleshoot.
Whereas with these new functions, the encoding and structure are explicit, visible and easy to control.
LEARN MORE
===========
π° EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
#Excel #ExcelFunctions #PowerQuery
Excel has just made Power Query optional with these new functions: IMPORTCSV and IMPORTTEXT.
β¬οΈ Download the example file here and follow along: bit.ly/import26file
βΆοΈ Excel LET Function video: youtu.be/5eOII3sq8wY
π©βπ« Join my Excel and Power BI courses: bit.ly/import26courses
β¬οΈ Join the Microsoft 365 beta program: techcommunity.microsoft.com/category/microsoft365/kb/microsoft-365-insider-kb
Excel has two new functions that make importing data from CSV and Text files super easy and most importantly, completely transparent.
Donβt get me wrong, Power Query is still my favourite tool for gathering and cleaning data, but CSV and Text Files are typically already clean, so Power Query can feel like overkill.
Plus, if anything goes wrong down the track, the Power Query settings are all encoded in the query editor, which can be daunting to try and troubleshoot.
Whereas with these new functions, the encoding and structure are explicit, visible and easy to control.
LEARN MORE
===========
π° EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
#Excel #ExcelFunctions #PowerQuery










