How to Copy File Names From a Folder to Excel (The Fastest Method using PowerQuery)
Автор: Excel AI by George
Загружено: 2025-12-04
Просмотров: 94
Описание:
Manually typing file names into Excel? Stop.
This Power Query trick lets you import EVERY filename from a folder in seconds, fully automated.
In this video, you’ll learn step by step:
1. How to use Excel’s From Folder feature
2. How Power Query reads filenames automatically
3. How to clean the names (remove extensions like .png or .pdf)
4. How to load the data into Excel as a clean table
5. How to reuse this workflow anytime the files change
This is perfect for:
• Corporate reporting
• Project documentation
• Audits + compliance folders
• Asset management
• Productivity workflows
• Anyone who uses Excel daily
If you want faster, cleaner reporting, this trick is a game changer.
#exceltips #exceltutorial #powerquery #exceltraining #dataextractor
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: