Download the IMPORTCSV Workbook
Get the dashboard + 6 sample CSV files from the video. All formulas included and ready to use.
What Is the IMPORTCSV Function?
IMPORTCSV is one of two new import functions Microsoft added to Excel in early 2026 (the other being IMPORTTEXT).
It returns a dynamic array, which means the imported data spills automatically into as many rows and columns as the CSV contains.
The full syntax:
=IMPORTCSV(file_path, [skip_rows], [take_rows], [locale])- file_path (required): A local path or web URL pointing to the CSV file.
- skip_rows (optional): Number of rows to skip from the top. Negative values skip from the bottom.
- take_rows (optional): Number of rows to return. Negative values take from the bottom.
- locale (optional): The locale of the CSV data, e.g.,
"en-US". Useful when your system locale differs from the file’s formatting.
Point it at a CSV file, press Enter, and the entire dataset appears in your sheet. One formula. No import wizard. No setup dialogs.
Availability: As of March 2026, IMPORTCSV is available to Microsoft 365 subscribers on the Insiders Beta channel (Windows, Version 2502, Build 18604.20002 or later). No confirmed date yet for general availability or Excel for Mac.
The Problem: Manually Checking Multiple CSV Files
If you manage a team or department, you know this scenario. Every month, CSV files land in a folder from different regions. Could be sales data, expense reports, headcount numbers.
Before you can do any real work, you need to answer three questions:
- Who actually submitted their data?
- What does the revenue look like?
- Is any of the data incomplete?
The old way? Open each file individually, scan through it, close it, open the next one. Repeat six times. And every time you open a CSV in Excel, you risk accidentally editing or deleting data with a stray click.
With IMPORTCSV, you can answer all three questions from a single Excel file. Here is how I built it step by step.
How to Build a Dashboard with IMPORTCSV
Step 1: Set Up Your File Paths
First, tell Excel where your CSV files are.
In File Explorer, select your CSV files (hold Shift and use the arrow keys), then right-click and choose Copy as path. Paste those paths into your Excel workbook. Each row holds the path to one region’s file.
This is the only setup IMPORTCSV needs. Everything else builds on these paths.
Step 2: Load CSV Data with IMPORTCSV
In any cell, type:
=IMPORTCSV(A2)Where A2 contains the file path to your first CSV file. Press Enter, and the entire CSV spills into the sheet as a dynamic array. Products, months, revenue numbers. All from one formula.
Since this is a dynamic array, Excel fills as many rows and columns as the data requires. Just make sure the surrounding cells are empty, or you will get a #SPILL error.
Step 3: Make It Dynamic with a Dropdown
A static import is useful, but the real value comes from switching between regions on the fly.
- Create a dropdown using Data > Data Validation > List with your region names (Northeast, Southeast, Midwest, etc.).
- Use XLOOKUP to match the selected region name to its file path.
- Pass that XLOOKUP result as the
file_pathargument in IMPORTCSV.
New to dropdowns? See our full guide on how to create a dropdown list in Excel.
The formula looks like this:
=IMPORTCSV(XLOOKUP(D2, A2:A7, B2:B7))Now when you switch the dropdown from Northeast to West Coast, the entire dataset refreshes instantly.
No reopening files. No copy-pasting between workbooks.
Step 4: Check Who Submitted Their Data
This is where the dashboard gets practical.
Add a second dropdown for the month. Then use IMPORTCSV with the take_rows argument set to 1 to pull only the header row from each CSV file. The header row contains the month names.
Combine that with XMATCH to check whether the selected month exists in each file’s headers. Wrap it in ISNA and IF to return a checkmark or X emoji:
- If XMATCH finds a match, it returns a position number. You show a checkmark.
- If the month does not exist, XMATCH returns
#N/A. You show an X.
Add conditional formatting to color the checkmarks green and the crosses orange. Now the submission status is obvious at a glance.
Step 5: Calculate Total Revenue Per Region
Using the same IMPORTCSV pattern, you can grab a specific column from each CSV and sum it. Use CHOOSECOLS to pick the column matching your selected month, then wrap it in SUM.
If the month is missing from a region’s file, return a dash instead of an error. This gives you a clean revenue comparison across all regions for any selected month, without loading full datasets into your workbook.
Want to see exactly how each formula is built? Download the practice file. Every formula from this tutorial is included and ready to explore.
Step 6: Flag Missing Data
The last piece of the dashboard identifies incomplete submissions. Even if a region submitted their CSV file, individual cells within that file might be blank.
For this, I use LEN combined with SUMPRODUCT to count blank cells in the relevant column.
Why not COUNTBLANK? Because COUNTBLANK does not work on arrays returned by a formula. It only works on cell references that are already on the grid.
The result shows exactly how many data points are missing per region, per month. You know immediately who needs a follow-up, without opening a single CSV file to check.
5 Important Things to Know About IMPORTCSV
1. It works with SharePoint and OneDrive
If your files live on SharePoint or OneDrive, use the web (HTTPS) link as the file path instead of a local path. Excel will prompt you to authenticate through your organizational account the first time you use a web-based path.
2. You need to manually refresh
IMPORTCSV does not auto-refresh when the source CSV changes. Go to Data > Refresh All to pull in the latest data. This is intentional. Import functions sit outside Excel’s normal recalculation cycle so they do not slow down your worksheet every time something changes.
3. You can control which rows to import
The skip_rows parameter lets you skip rows from the top of the file (useful for metadata or multi-row headers). Use a negative number to skip rows from the bottom. The take_rows parameter works the same way: positive values count from the top, negative from the bottom.
4. Handle regional formatting differences with the locale parameter
If your operating system uses commas as decimal separators (common in Germany) but your CSV files use dots (common in the US), results will look wrong. Set the locale parameter to match the CSV file’s formatting. For US-formatted files, use "en-US". This also handles date format differences (month-first vs. day-first).
5. Use IMPORTTEXT for non-comma delimiters
If your files use semicolons (common in European CSV exports) or tabs instead of commas, switch to IMPORTTEXT. It is IMPORTCSV’s sister function with more flexibility:
=IMPORTTEXT(file_path, [delimiter], [skip_rows], [take_rows], [encoding], [locale])For standard comma-separated files, stick with IMPORTCSV. For everything else, IMPORTTEXT has you covered.
Bonus: Clean Up File Paths with Custom Number Formatting
Long file paths make a dashboard look cluttered. Here is a clean fix using custom number formatting:
- Select the cells containing your file paths.
- Press Ctrl+1 to open Format Cells.
- Go to the Custom category.
- Type three semicolons:
;;;to hide the displayed value entirely. - Or place a link emoji before the semicolons so each cell shows a small icon instead of the full path.
The actual file path stays in the cell. Formulas referencing it still work. It is purely a display trick. Custom number formatting controls what the cell shows, not what it contains.
For more techniques like color-coded arrows and threshold icons, see our full tutorial on custom number formatting in Excel and smart uses of custom formatting for dashboards.
IMPORTCSV vs. Power Query: When to Use Which
IMPORTCSV is not a replacement for Power Query. They solve different problems.
Use IMPORTCSV when:
- You need a quick check on CSV data without a full import workflow
- Your data is already clean and does not need transformation
- You want formula-level transparency (anyone can read the formula and understand the source)
- You are building a lightweight checking tool or dashboard
Use Power Query when:
- You need to combine and clean data from multiple sources
- Your data requires transformation: reformatting dates, fixing inconsistencies, adding calculated columns
- You need the output as a proper Excel Table
- You are working with large or complex datasets that need reshaping
For many real-world scenarios, you can use both. IMPORTCSV for a quick status dashboard, Power Query for the deep analysis.
Frequently Asked Questions
What is the IMPORTCSV function in Excel?
IMPORTCSV is a new Excel function that imports data from a CSV file directly into your spreadsheet as a dynamic array. The syntax is =IMPORTCSV(file_path, [skip_rows], [take_rows], [locale]). Only the file path is required. It was introduced to Microsoft 365 Insiders in January 2026.
Is IMPORTCSV available in Excel right now?
As of March 2026, IMPORTCSV is available to Microsoft 365 subscribers on the Insiders Beta channel, running Windows Version 2502 (Build 18604.20002) or later. There is no confirmed date for general availability or Excel for Mac support. Check Microsoft’s official documentation for the latest status.
What is the difference between IMPORTCSV and IMPORTTEXT?
IMPORTCSV is a simplified version of IMPORTTEXT. It defaults to comma delimiters and UTF-8 encoding, so you have fewer parameters to set. IMPORTTEXT gives you full control: custom delimiters (semicolons, tabs, pipes), encoding options, and locale settings. Use IMPORTCSV for standard comma-separated files. Use IMPORTTEXT for everything else.
Does IMPORTCSV auto-refresh when the CSV file changes?
No. IMPORTCSV sits outside Excel’s normal recalculation cycle. To update the imported data, go to Data > Refresh All. This is by design so that imports do not add delay every time your worksheet recalculates.
Can IMPORTCSV replace Power Query?
Not entirely. IMPORTCSV is best for quick, formula-based imports where the source data is already clean. Power Query remains the better tool when you need to combine multiple data sources, transform values, reformat dates, or load results into a structured Excel Table.
Can I use IMPORTCSV with SharePoint or OneDrive files?
Yes. Replace the local file path with the HTTPS web link to your SharePoint or OneDrive file. Excel will ask you to authenticate through your organizational account on first use.
Try It Yourself
I built this dashboard in about 15 minutes. But it is reusable every single month.
Swap in your own file paths, adjust the region names, and you have a working submission tracker that saves hours of manual checking.
Download the practice file below and try it with your own data.
Ready to build your own?
Get the dashboard + 6 CSV files. All formulas included.
Download the Free Workbook ↑Featured Bundle
Power Excel Bundle
Leila Gharani
Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.
