Powerful trick to combine all Excel files in a folder AUTOMATICALLY
Need to automatically combine all files in a folder to One Excel workbook? You are going to love this *completely* automatic way. This simple but insanely time saving trick uses Power Query to combine files in a folder.
In this video ⏱👇
==============
0:00 - Introduction to the combine files problem
0:36 - A quick look at the folder & one of the files
1:10 - Combining the files with "Get Data → Folder" option in Excel
2:36 - Cleaning up the file data with Power Query rules
5:32 - Loading the data to Excel
5:55 - What happens when you add files to the folder
7:08 - How to learn Power Query
Sample files 📂
============
Here is a ZIP file that has individual monthly files & consolidated workbook (with Power Query connection). https://chandoo.org/wp/wp-content/uploads/2021/11/combine-files-pq.zip
For a similar example, but using PDFs, see this video: https://youtu.be/5I0pnj_-LLA
Watch next 📽👉
==============
🔥 [RECOMMENDED] Detailed Power Query Tutorial (80 minutes) - https://youtu.be/PiFAa_jjaEI
Power Query tips play list -https://youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Combine sheets in an Excel file - https://youtu.be/k_ugshJ4wIw
Combine Data from PDFs - https://youtu.be/5I0pnj_-LLA
Credits:
======
Big bang theory clip from https://www.youtube.com/watch?v=5cCEw9Tageg
Music from Epidemic Sound. Get high quality & fresh songs for your videos from here: https://www.epidemicsound.com/referral/gdubva
Have an awesome day 🌞🌼😀
Видео Powerful trick to combine all Excel files in a folder AUTOMATICALLY канала Chandoo
In this video ⏱👇
==============
0:00 - Introduction to the combine files problem
0:36 - A quick look at the folder & one of the files
1:10 - Combining the files with "Get Data → Folder" option in Excel
2:36 - Cleaning up the file data with Power Query rules
5:32 - Loading the data to Excel
5:55 - What happens when you add files to the folder
7:08 - How to learn Power Query
Sample files 📂
============
Here is a ZIP file that has individual monthly files & consolidated workbook (with Power Query connection). https://chandoo.org/wp/wp-content/uploads/2021/11/combine-files-pq.zip
For a similar example, but using PDFs, see this video: https://youtu.be/5I0pnj_-LLA
Watch next 📽👉
==============
🔥 [RECOMMENDED] Detailed Power Query Tutorial (80 minutes) - https://youtu.be/PiFAa_jjaEI
Power Query tips play list -https://youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Combine sheets in an Excel file - https://youtu.be/k_ugshJ4wIw
Combine Data from PDFs - https://youtu.be/5I0pnj_-LLA
Credits:
======
Big bang theory clip from https://www.youtube.com/watch?v=5cCEw9Tageg
Music from Epidemic Sound. Get high quality & fresh songs for your videos from here: https://www.epidemicsound.com/referral/gdubva
Have an awesome day 🌞🌼😀
Видео Powerful trick to combine all Excel files in a folder AUTOMATICALLY канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
5 Tricks Power BI PROs use to Create Amazing Dashboards 👩💻BRILLIANT Excel Trick to Get One Pivot Table from Many Sheets 🤯Excel VBA - Beginner to PRO Masterclass with Code Samples50 things you didn't know Excel can DO 💡TOP 10 XL Functions #excelDON'T tell my boss, but ChatGPT made this Excel dashboard 🤫Example Data Analyst Interview Question - Can you solve this? 🤔I don't use PIVOT tables anymore... I use this other thing instead!Excel Magic Revealed: Unstacking Data Like a Pro! ✨What is Microsoft Fabric & what can we DO with it?Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...How to make a Map Chart in Excel - Quick & Simple TutorialONLY Excel pros use this INDEX MATCH trick 💡How to make an Interactive & Beautiful Excel Dashboard in 5 StepsI got braces in my 40s!6 *proven* strategies I used to make $100,000+ with my Excel SkillsHoney, I shrunk the lengthy Excel formula (by 80%😮)FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work 🚀How to use TEXTSPLIT() in ExcelMake a beautiful and interactive To-Do List with Excel (Easy Tutorial 👌)Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖