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

★★★ Get the complete Power Query Course: https://courses.xelplus.com/p/excel-power-query

► 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/

EXCEL 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

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

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!

#MsExcel #powerquery