3,649
likes
138
comments
daily view 0
monthly view 0
Live Analytics
Comments 0
The New Excel Trick to Link CSV Files Instantly Analytics Table
Income Estimates for The New Excel Trick to Link CSV Files Instantly
Based on this YouTube video's total view count of 113K views and industry-standard rates, the estimated total earning is $80 - $228 through ad revenue. Historical data is not yet available to calculate daily, weekly, or monthly averages.
About The New Excel Trick to Link CSV Files Instantly
Explore The New Excel Trick to Link CSV Files Instantly with 113,874 views, 3,649 likes, and 138 comments. Experience the impact of this video content that has captured audience attention.
Link CSV files to Excel with one formula. The new IMPORTCSV function pulls in CSV data without opening the files. No Power Query, no VBA. ⬇️ Download the practice files: https://www.xelplus.com/excel-importcsv-function/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-importcsv&utm_content=importcsv#download-section 📘 Combine and clean CSV files at scale with Power Query: https://www.xelplus.com/course/excel-power-query/ Six regions send a CSV file every month. You need to know who submitted, what the revenue looks like, and whether any data is missing. Instead of opening each file, you'll build a small dashboard that checks all of them from one workbook. Copy the file paths, then point IMPORTCSV at them. Add a drop-down and XLOOKUP to switch between regions. Use the take_rows argument with XMATCH and ISNA to check whether each file has the selected month, then color-code the result with conditional formatting. CHOOSECOLS and SUM total the revenue. LEN and SUMPRODUCT count blank cells, because COUNTBLANK doesn't work on arrays returned by a formula. You'll also see five things to know before using IMPORTCSV: SharePoint and OneDrive links, refreshing with Data → Refresh All, skipping and taking rows, the locale argument for regional formats, and IMPORTTEXT for semicolon-delimited files. Plus a custom number format that shows a link icon instead of a long file path. IMPORTCSV is currently available to Microsoft 365 Insiders (Beta Channel, Excel for Windows, Version 2502, Build 18604.20002 or later). ★ 500,000+ professionals learn Excel with our courses: https://link.xelplus.com/yt-d-all-courses ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 0:00 Check CSV files without opening them 1:32 The scenario: monthly CSV files from six regions 2:08 Copy file paths with Copy as Path 2:35 IMPORTCSV: load a CSV file with one formula 3:23 Switch files with a drop-down and XLOOKUP 4:43 5 things to know: SharePoint, refresh, rows, locale 6:28 IMPORTTEXT for semicolon-delimited files 7:02 Hide file paths with custom number formatting 8:39 Month drop-down to check submissions 9:45 XMATCH and ISNA: flag missing months 11:11 Color-code results with conditional formatting 12:00 Total revenue with CHOOSECOLS and SUM 12:27 Count missing data with LEN and SUMPRODUCT 13:36 IMPORTCSV vs Power Query: when to use which 🎬 XLOOKUP explained: https://youtu.be/4c0CLUER6nw 🎬 Custom number formatting: https://youtu.be/68Tet_8BNB8 🎬 Learn Power Query: https://youtu.be/x7mzOYEn0XA 🔓 Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #importcsv #exceltips
About YouTube Real-Time View Count
With SocialCounts.org’s view counter, track your YouTube video’s live view count and YouTube likes count in real time with fast, reliable updates.
Watch every YouTube video live view count rise with our real-time YouTube views tracker—built for accuracy and minimal delay.
Follow YouTube real time views as they happen, using our dedicated view counter for YouTube videos.
Get up-to-date live view count on YouTube and see real-time growth with SocialCounts.org’s smart tracking tools.
Embed Widget
Parameters:
fullscreen=true- Fullscreen countergraph=true- Live graph chartcounter=0/1/2- Select counter (0=likes, 1=views, 2=comments)
URL
Click to copy the embed URL to your clipboard

