How to display emails in Excel sheets using Power Query

Excel can do pretty much anything, but did you know it can even display emails as a table?

About

Using Power Query data sources we can fetch emails from any inbox using MailSlurp's free email account API to proxy email data into Excel. That means we can sort and filter emails, display them in a table, and even create custom reports.

Steps

1. Get a free API Key from the MailSlurp dashboard

2. Create an inbox or connect your external account
3. Create a new Excel sheet
4. Click data sources and click or .

5. Create a blank query

6. Paste in the following M script (be sure to replace your API Key)

7. Click to load the data into Excel!

You will see your emails displayed as a table in your sheet. You can refresh the data and see live emails arrive in your spreadsheet!

More information

For more information on Power Query and MailSlurp check out the official documentation.