Extract Outlook Emails in Excel

Hello,

Greetings!

Now-a-days whenever I am speaking with any of my colleagues after a long time, instead of gossips I hear resignations and the challenge that I hear is to take the backup of their data from their machine. I wondered how we can take an extract of all of the email data and I found that this can be done using MS excel.

Here are the steps that you need to follow to take back up your outlook data.

Open MS Excel, navigate to 'Data' tab, click on 'Get Data' drop-down, click on 'From Other Sources' and click on 'From Microsoft Exchange'

Enter your email and click on 'Ok'

Sign in using your Microsoft account and click on 'Connect'

Power Query will set up a connection between Outlook and MS Excel. Click on 'Mail'

Once clicked, you will be able to see all your emails in different folders (Inbox, Sent, Draft, other folders) Click on 'Transform Data'

Once clicked, Power Query Editor will open and you can extract the data which you want. Once done, click on 'Close & Load'

Once clicked, a new sheet will be created in excel, and data from the outlook will be loaded in your excel.

Save the excel and this is how you will be able to keep backup of your Outlook data as well.