Microsoft Excel’s new import functions make handling numbers easier
Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The post Microsoft Excel’s new import functions make handling...
Kass
Digital Trends may earn a commission when you buy through links on our site. Why trust us?
CSV and text files can now spill directly into cells
Rubaitul Azad / Unsplash
If you often work with data that starts life as a text file or CSV, Microsoft Excel now has new built-in tools that simplify how that information gets pulled into a spreadsheet.
The update introduces two new functions, IMPORTTEXT and IMPORTCSV, designed to bring external data directly into Excel cells using formulas. Instead of going through the traditional import wizard every time, users can now load files straight into a worksheet and keep that data connected to its source.
How Excel’s new import functions work
Microsoft
The IMPORTTEXT function allows users to import data from text-based files such as TXT, CSV, and TSV. It supports custom delimiters, text qualifiers, and encoding options, giving users control over how data is interpreted when it lands in Excel.
The imported data appears as a dynamic array, meaning it automatically expands to fit the incoming content. For simpler use cases, IMPORTCSV offers a more streamlined option specifically for CSV files.
It assumes common CSV formatting, making it quicker to use when working with standard exports from apps, databases, or online tools. Both functions allow users to reference local file paths or supported locations, and the data can refresh when the source file is updated.
According to Microsoft, these functions are meant to reduce repeated manual steps when working with frequently updated files. Once the formula is set up, Excel can re-import the data without starting over each time. Keeping the import logic visible inside a formula makes it easier to audit, adjust, or troubleshoot compared to older import methods.
Microsoft
The new import functions are currently rolling out to Microsoft 365 Insider users. They do not replace Power Query, but instead offer a lighter, formula-based alternative for everyday data imports. You can also use the new import functions as part of the context for the =COPILOT function, to ask Copilot questions about the data you’ve brought into Excel and get insights without leaving the sheet.
This builds on Microsoft’s broader push to make Copilot a more hands-on helper across Office apps. It also fits into Microsoft’s broader effort to make Excel quicker to work with, alongside long-standing tips like essential keyboard shortcuts and everyday workflow tricks that many users rely on to get more done.
Manisha likes to cover technology that is a part of everyday life, from smartphones & apps to gaming & streaming…
I found an iPad browser that finally puts a desktop-like experience on Apple’s tablet
Beam draws heavy inspiration from a hot-favorite Mac browser and it's a breath of fresh air.
The situation with mobile browsers on Apple’s platforms is not exactly rewarding for users. Safari gets the job done, but for every other browser landing on the iPhone or iPad, they are forced to use Apple’s WebKit engine. Simply put, most browsers are simply wrappers built atop the same foundation on iOS and iPadOS
As a result, you won’t find Safari alternatives that can really stand out. On the desktop side for Mac, there’s no such rule. As a result, you can find terrific options such as Perplexity Comet, Dia, and ChatGPT Atlas, aside from the big names such as Chrome, Edge, and Firefox.
AMD has new chips, but RAM prices are the real boss fight
AMD acknowledges RAM supply crisis as it charts careful GPU and CPU roadmap
If you thought 2026 was going to be the year PC building finally got easy again, AMD has some bad news. The company is heading into the new year facing a perfect storm of supply chain headaches and skyrocketing prices. In a candid chat with Gizmodo during CES, AMD’s Ryzen lead David McAfee laid out the situation, and honestly, it sounds like they are trying to steer a ship through a hurricane without losing any cargo.
The hardware they showed off at CES tells the story better than any press release could. They revealed the new Ryzen 7 9850X3D and some beefed-up Strix Halo APUs, specifically the Ryzen AI Max+ 388 and 382. On paper, these look solid for future laptops or handhelds. But if you look closer, there is a catch: these new chips are still running on the older RDNA 3.5 graphics architecture. They aren't getting the shiny new graphical tech just yet. Even McAfee admitted that the jump in performance from the previous 9800X3D to this new 9850X3D is going to be pretty minor - mostly noticeable if you are grinding esports titles or older games. It feels less like a revolution and more like they are just keeping the lights on while they wait for the storm to pass.
OLED MacBook Pro displays may already be in production ahead of rumored 2026 launch
With OLED display panels reportedly entering production, Apple's next-generation MacBook Pro appears closer than ever, and it could be the most significant visual upgrade in years.
Apple's OLED MacBook Pro seems to be one step closer to hitting store shelves. According to a Korean blog post, production of OLED panels for the purported MacBook models has already begun, by none other than Samsung.
What's even more interesting is that the display manufacturing process is said to be running ahead of schedule (initially planned for the second quarter of this year). If that's true, Apple has already finalized the display technology, size, and other specifications, right on time for the rumored 2026 launch.
