Auto-Import Data from Email Attachments to Excel using Power Query

Are you tired of manually importing Excel data from email attachments every month? In this video tutorial, I will show you how to set up an automation using Power Query to automatically import Excel data from email attachments and merge them into a single Excel file.

This time-saving solution will allow you to effortlessly extract the data from the email attachment and use it for further data analysis. Watch the video to learn the step-by-step process and start saving time today!
#ExcelDataImport #EmailAttachments #automation #powerquery

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[kiliev]

Your channel is one of the most underrated in the sphere.

[MGAa]

This is like a mini-course on this topic - great stuff - thank you for posting this content !

[ourlittlesmarties]

This is very useful! Thank you so much for sharing it. Love watching your videos and your explanation is perfect!

[cjimmer]

Amazing! Thank you for posting. I can't wait to try this out on PDFs

[paser]

I love this, because it eliminates the need to Power Automate. Thanks for sharing this.

[jibinvinod]

You have no idea, how usefull this information to me. you are a gem!

[keagankemp]

Aah this is beautiful, I had to use a flow but now I can do it in these easy steps thanks a mil

[paspuggie]

I have used this solution before and my clients love it. Well done Chandeep for making a video about it 😊

[nonoobott]

This is very apt. I sure need this and you are so explicit. Thanks so much for sharing

[ursvenky]

I have been following you for power query solutions. Excellent solutions you provided. We are very that your on youtube to provide solutions or else i couldn't get solutions. I implemented things in powerquery which you suggested on YouTube and i got good appreciation in my org. It belongs to you as well. Thank you

[Lalithchary]

Thank you for the tutorial, it is amazing, how can we do on PDF's and CSV's ?

[alexrosen]

Very very useful. Thank you for yet another informative tutorial 🙌

[ocismorkayo]

Technical A-ha moment. Simple, quick, awesome. Many thanks Chandeep. A huge thumb up😊

[tersit]

Perfect solution and very easy method, thanks a lot!

[arunkumarkesavan]

Harray Bro!!! Its really awesome. I recently tried using the same thing using Alteryx and Outlook macro and finally load the data into PowerBI. Now its super easy and skip the intermediate steps. As usual again its clear and useful !!!
Waiting to see your subscriber to reach million !!!

[Archie]

This was an awesome info, thanks for sharing!!

[phoolkhan]

Looking this kind of trick from last 11 months.

Receiving more than 100 branches excel file having locked format and placing the same in my folder one by one and so on and so on...
You can't imagine that what kind of relaxing I'm thinking.


Goodly u r really 💕.

[IvanCortinas_ES]

Absolutely handy, Sir. Thank you very much for the impressive video.

[DeepakKashyap-frek]

Seriously, it is insane. .. Thank you Chandeep.

[unnikrishnansanthosh]

super cool time saver, thank you for sharing