Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
In this video, I’ll show you how to get data from Outlook into Excel. This way you can automatically import your emails to an Excel worksheet. I’ll use Get & Transform (Power Query) to set this up. While you follow the easy steps, you’ll also create a connection from Outlook to Excel in a dynamic way. So anytime you want to get the latest email information, you just have to refresh your Excel table. And we’ll also apply filters to only export specific emails to Excel and parse the contents so you only get the information you need from the emails. No VBA is used and no external add-ins. Instead I use a feature that belongs to Excel.
00:00 How to Use Power Query to Import Data from Outlook
01:05 Setup Connection: Get Data from Microsoft Exchange
02:28 Apply Filters to Select Specific Data
05:01 Load Data to Excel
06:21 Wrap Up
► LINK to more Power Query tutorials: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-
⯆ Link to full article: https://www.xelplus.com/import-outlook-to-excel-with-power-query
My Online Excel Courses ► https://www.xelplus.com/courses/
Power Query Data Sources: https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: 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 #powerquery
