Excel Just Made File Imports Ridiculously Simple (New Functions) @MyOnlineTrainingHub
Excel Just Made File Imports Ridiculously Simple (New Functions)  @MyOnlineTrainingHub
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 Just Made File Imports Ridiculously Simple (New Functions)From Negative to Positive Values in Excel | Beginner to AdvancedHow to Insert a Checkbox in Excel | Interactive ChecklistsI Turned Excel Into the Ultimate Productivity System (Free Template)Say GOODBYE to These 3 Excel FunctionsHigh-Income Excel Skills Worth Learning in 2026 (Free File)This 1 Excel function can do 90% of your calculations!7 Excel Functions That Build a Forecast That Updates ItselfMaster Data Cleaning with Power Query in Excel in 9 MinutesHow to Get Excel for Free (Legally)5 Ways to Make Your Excel Data Usable (Splitting Cells)Compare Two Excel Sheets and Catch Every Single Difference
MyOnlineTrainingHub |

Excel Just Made File Imports Ridiculously Simple (New Functions)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER