How to Import Emails From OUTLOOK to EXCEL & why you want to do that!

Join 400,000+ professionals in our 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:

⯆ Link to full article:

My Online Excel Courses ►

Power Query Data Sources:

Not sure which of my Excel courses fits best for you? Take the quiz:

RESOURCES I Recommend:

Get Microsoft 365:
Microsoft Surface:

More resources on my Amazon page:

Let’s connect on social:

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


Leave a Reply

Your email address will not be published. Required fields are marked *