Ben Richardson looks at a pair of beta functions:
Microsoft just added some brand-new IMPORT functions, designed to make bringing external data into Excel easier!
Instead of digging through menus or writing your own queries, you can now just use these new formulas, IMPORTTEXT and IMPORTCSV.
Importing data is something we do all the time, downloading CSV files, opening data from text files, or pulling data from databases. Having some new functions to keep expanding that skill set is just going to save so much time!
For well-structured files, these functions look to be quite effective. I do wonder how they’d fare against some of the messier CSVs we often need to deal with in real life.