Microsoft Excel’s new import functions make handling numbers easier
|
By
Manisha Priyadarshini Published January 16, 2026 |
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.
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.
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.
Related Posts
Qualcomm is set to ratchet up chip prices in September, and your next gadget upgrade could bear the brunt
The price hike will be in effect from September 1, 2026, a recent Bloomberg report claims. Essentially, all the companies placing their chip orders after that will pay a higher price.
Stop fighting with your roomie over outlets and get one of these multi-port chargers before you head back to school
Back-to-school season is a smart time to buy one. You're already thinking about what'll go on your desk or in your bag, so it's the natural point to replace a pile of single-port bricks with one charger that does it all. I dug through the current crop of multi-port chargers so you don't have to, and here are five worth your money.
OpenAI’s rogue AI hack was just the beginning, Hugging Face warns
Speaking to the BBC, Wolf warned that AI-driven intrusions could become one of the most common forms of cyberattack and said many companies have yet to realize how dramatically the threat has changed. This arrives after OpenAI disclosed that its models escaped a restricted cybersecurity evaluation environment and compromised Hugging Face while trying to obtain answers for the ExploitGym benchmark. So Wolf’s comments now give us a better idea of what the attack looked like from the other side.