Uploaded March 2026 | Updated September 2026, 4 days ago
🔥 500,000+ enrolled in our courses. Join them 👉 link.xelplus.com/yt-d-all-courses
Excel's IMPORTCSV function lets you pull CSV data directly into your spreadsheet with one formula. No Power Query, no VBA, no opening files. In this tutorial, I'll show you how to build a dynamic dashboard that checks which regions submitted their data, totals revenue, and flags missing values — all without opening a single CSV file.
⬇️ DOWNLOAD the files I use from here: xelplus.com/excel-importcsv-function/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-importcsv&utm_content=importcsv#download-section
IMPORTCSV is currently available to Microsoft 365 Insiders (Beta channel, Windows Version 2502, Build 18604.20002+).
🔓 Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
⏱️ Timestamps:
0:00 The problem: checking multiple CSV files manually
1:32 The scenario: CSV files from different regions
2:08 Step 1: Set up your file paths
2:37 Step 2: Use IMPORTCSV to load CSV data
3:23 Step 3: Make it dynamic with XLOOKUP + dropdown
4:43 5 important things to know about IMPORTCSV
7:02 Bonus: Clean up file paths with custom formatting
8:17 Step 4: Check who submitted their data
10:59 Step 5: Color-code with conditional formatting
12:00 Step 6: Calculate total revenue per region
12:27 Step 7: Flag missing data with SUMPRODUCT
13:36 Final result + when to use Power Query instead
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
📌 What you'll learn:
- How to use IMPORTCSV to import CSV files with a formula
- How to switch between multiple CSV files using a dropdown and XLOOKUP
- How to check submissions, sum revenue, and find blanks across files
- When to use IMPORTCSV vs. IMPORTTEXT vs. Power Query
- How to hide file paths with custom number formatting
🎬 LINKS to related videos:
→ XLOOKUP explained: youtu.be/4c0CLUER6nw
→ Custom number formatting: youtu.be/68Tet_8BNB8
→ Learn Power Query: youtu.be/x7mzOYEn0XA
👕 Get the Official XelPlus MERCH: xelplus.creator-spring.com
🧭 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🧰 Resources I recommend: xelplus.com/resources
🛒 More resources on my Amazon page: amazon.com/shop/leilagharani
📲 Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
🔥 500,000+ enrolled in our courses. Join them 👉 link.xelplus.com/yt-d-all-courses
Excel's IMPORTCSV function lets you pull CSV data directly into your spreadsheet with one formula. No Power Query, no VBA, no opening files. In this tutorial, I'll show you how to build a dynamic dashboard that checks which regions submitted their data, totals revenue, and flags missing values — all without opening a single CSV file.
⬇️ DOWNLOAD the files I use from here: xelplus.com/excel-importcsv-function/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-importcsv&utm_content=importcsv#download-section
IMPORTCSV is currently available to Microsoft 365 Insiders (Beta channel, Windows Version 2502, Build 18604.20002+).
🔓 Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
⏱️ Timestamps:
0:00 The problem: checking multiple CSV files manually
1:32 The scenario: CSV files from different regions
2:08 Step 1: Set up your file paths
2:37 Step 2: Use IMPORTCSV to load CSV data
3:23 Step 3: Make it dynamic with XLOOKUP + dropdown
4:43 5 important things to know about IMPORTCSV
7:02 Bonus: Clean up file paths with custom formatting
8:17 Step 4: Check who submitted their data
10:59 Step 5: Color-code with conditional formatting
12:00 Step 6: Calculate total revenue per region
12:27 Step 7: Flag missing data with SUMPRODUCT
13:36 Final result + when to use Power Query instead
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
📌 What you'll learn:
- How to use IMPORTCSV to import CSV files with a formula
- How to switch between multiple CSV files using a dropdown and XLOOKUP
- How to check submissions, sum revenue, and find blanks across files
- When to use IMPORTCSV vs. IMPORTTEXT vs. Power Query
- How to hide file paths with custom number formatting
🎬 LINKS to related videos:
→ XLOOKUP explained: youtu.be/4c0CLUER6nw
→ Custom number formatting: youtu.be/68Tet_8BNB8
→ Learn Power Query: youtu.be/x7mzOYEn0XA
👕 Get the Official XelPlus MERCH: xelplus.creator-spring.com
🧭 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🧰 Resources I recommend: xelplus.com/resources
🛒 More resources on my Amazon page: amazon.com/shop/leilagharani
📲 Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
