If you often work with data that initially exists as a text file or CSV, Microsoft Excel now has new built-in tools that make it easier to insert this information into a spreadsheet.
The update introduces two new features, IMPORTTEXT and IMPORTCSV, designed to transfer external data directly into Excel cells using formulas. Instead of going through the traditional import wizard every time, users can now load files directly into a worksheet and keep the data connected to its source.
This is how Excel’s new import functions work
The IMPORTTEXT feature 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 an optimized option specifically for CSV files.
It requires common CSV formatting, allowing for faster use when working with standard exports from apps, databases or online tools. Both features allow users to point to local file paths or supported locations and the data can be updated when the source file is updated.
According to Microsoft, these features are intended to reduce repeated manual steps when working with frequently updated files. Once the formula is set up, Excel can re-import the data without having to start over each time. Keeping import logic visible within a formula makes it easier to review, adjust, or troubleshoot compared to older import methods.
The new import features are currently rolling out to Microsoft 365 Insider users. They do not replace Power Query, but rather offer a simpler, formula-based alternative for everyday data imports. You can also use the new import capabilities as part of the context for the =COPILOT function to ask Copilot questions about the data you brought into Excel and get insights without leaving the sheet.
This builds on Microsoft’s broader effort to make Copilot a more practical helper for all Office apps. It also fits into Microsoft’s broader effort to make working with Excel faster, along with tried-and-true tips like essential keyboard shortcuts and everyday workflow tricks that many users rely on to get more done.
