Excel: Link CSVs in Seconds

Key insights

• IMPORTCSV: The video shows how IMPORTCSV pulls a .csv file into Excel with a single formula, so you don’t need Power Query, VBA, or to open each file manually.
  Use it to link CSV files directly into a worksheet and keep the layout simple for dashboards.
• IMPORTTEXT: Use IMPORTTEXT when you need more control over parsing (custom delimiters, encoding, fixed-width fields).
  It handles .txt, .csv, and .tsv files and supports extra parameters for precise imports.
• dynamic refresh: Imported data becomes a live connection you can refresh (Data > Refresh All), so changes in source files update the sheet automatically.
  This makes it easy to build dashboards that reflect the latest submissions without manual reimports.
• XLOOKUP: Combine IMPORTCSV/IMPORTTEXT with a dropdown and XLOOKUP to switch between region files and pull the right dataset into your dashboard.
  This lets you total revenue per region and switch views with one selection.
• SUMPRODUCT: Use SUMPRODUCT (or similar functions) to detect and flag missing values across imported files, and apply conditional formatting to color-code submissions and blanks.
  You can also hide file paths using custom number formatting to keep the sheet clean.
• Power Query: Choose Power Query instead when you need heavy transformations, complex joins, or better performance on very large files.
  For most simple imports and linked dashboards, IMPORTCSV/IMPORTTEXT offer a faster, easier path.

Overview: A new Excel shortcut from Leila Gharani [MVP]

In a recent YouTube tutorial, Leila Gharani [MVP] demonstrates a streamlined way to link CSV files into Excel using a formula-based approach. She highlights the new IMPORTCSV function and contrasts it with the more configurable IMPORTTEXT, showing how these functions can replace repetitive manual imports. Consequently, the video focuses on building a live dashboard that reads multiple CSV files without opening them, aiming to save time for routine reporting tasks.

Leila walks viewers through a practical scenario where regional teams submit CSV files and a central spreadsheet must track submissions, sum revenue, and flag missing values. Moreover, she demonstrates how to switch between files with a dropdown and use lookup logic to dynamically update the sheet. This hands-on approach makes the new functions easier to evaluate for everyday use in spreadsheets.

The tutorial clarifies that these functions were available initially to Microsoft 365 Insiders on Windows builds in early 2026, so availability may vary across organizations. Therefore, viewers should check their Microsoft 365 channel and build number before trying the exact steps. In short, the video offers a useful preview of a shift in how Excel handles text-based imports.

How IMPORTCSV and IMPORTTEXT work

Leila explains that IMPORTCSV serves as a shorthand for bringing comma-separated files into a worksheet with minimal parameters. She demonstrates the core syntax: point the formula to a file path or URL, optionally skip rows, and then press Enter to load a dynamic array. As a result, the imported data stays linked and can be refreshed, making it more like a live feed than a one-time copy.

On the other hand, Leila shows that IMPORTTEXT offers deeper parsing control for .txt, .csv, and .tsv files, including custom delimiters, encoding options, and row filters. Consequently, users who need precise parsing or unusual file formats will likely prefer IMPORTTEXT for its flexibility. She also highlights that some advanced cases let you combine these functions with array builders like SEQUENCE for fixed-width processing.

Importantly, the video notes that imported arrays are refreshable through the Data > Refresh All command, so changes in the source file propagate to the sheet. However, Leila points out that refresh behavior and performance depend on file size and connection type. Thus, while dynamic linking offers convenience, it also introduces tradeoffs around speed and reliability for large or remote files.

Building a dynamic dashboard: steps shown in the video

Leila begins the dashboard build by standardizing file paths and then using IMPORTCSV to load a sample file into a designated area on the sheet. Next, she adds a dropdown and uses XLOOKUP to switch between path entries, which lets the user view different region files without touching formulas. This pattern keeps formulas tidy and gives end users a simple selector to change the data source.

Moreover, she layers formatting and logic on top of the imported data: conditional formatting highlights missing submissions, and simple SUM formulas aggregate revenue by region. To flag blanks across files, she demonstrates a formula that uses SUMPRODUCT to count empties and return a clear status. Consequently, viewers see how to combine import formulas with familiar Excel tools to create a readable operational dashboard.

Leila also shares cleanup tips, such as hiding raw file paths via custom number formatting so the sheet looks cleaner for non-technical users. She uses clear examples with timestamps in the video to separate each step and show results in real time. Therefore, the tutorial is practical for analysts who want to move from manual CSV checks to a single, maintainable dashboard.

Tradeoffs and practical challenges

While the new functions simplify many workflows, Leila discusses several tradeoffs that organizations should weigh before adopting them widely. For instance, formulas that pull many large CSV files can slow a workbook and increase refresh times, whereas Power Query can be more efficient for heavy transforms and batching. Thus, teams must balance speed and ease of setup against long-term maintainability and performance.

Security and file access present another challenge. The video stresses that file paths and permissions matter: local file references behave differently than URLs, and some corporate environments restrict external connections. Additionally, regional settings and encoding differences can lead to subtle parsing errors, so the video recommends testing with representative files before rolling out a solution.

Finally, error handling and auditability remain practical concerns. Because formula-driven imports can hide transformation steps, tracking how data changed over time may be harder than with query-based workflows. For that reason, Leila suggests documenting logic and keeping backup copies, particularly in collaborative or regulated environments.

When to use formula imports and when to choose Power Query

Leila offers clear guidance on when to prefer formula imports versus using Power Query. She recommends IMPORTCSV or IMPORTTEXT for quick, lightweight tasks where you want a live link and minimal setup, such as checking submissions or summarizing a few files. Conversely, she advises using Power Query when you need complex joins, repeated transformations, or to combine many files into a single consolidated dataset.

Moreover, the video emphasizes testing and gradual rollout: start with a pilot workbook for one team, measure refresh times, and note any parsing quirks with your regional formats. In addition, simple tips—like hiding file paths, keeping formulas readable, and refreshing on a schedule—can improve reliability for everyday users. Therefore, viewers can make informed choices by weighing ease of setup against scale, performance, and governance needs.

Overall, Leila Gharani’s tutorial provides a practical look at how the new import functions can speed routine work while also highlighting real-world limits and safeguards. As organizations experiment with these tools, they should carefully consider performance, security, and maintainability to decide whether a formula-based link or a query-driven pipeline fits their needs best.

Keywords

Excel link CSV files, link CSV to Excel, link CSV files Excel tutorial, Excel link CSV instantly, dynamic CSV link Excel, Power Query link CSV, auto-refresh linked CSV Excel, how to link CSV in Excel