Skip to main content

How to export all emails from an Outlook mail folder to Excel/CSV?

This article is talking about exporting all emails from an Outlook mail folder to a new Excel workbook. And there are two solutions:


Export all emails from a mail folder in Outlook to Excel/CSV with Copy feature

This method will guide you to copy all emails from a mail folder in Outlook, and then paste to Excel workbook directly. Please do as follows:

1. In the Mail view, click to open the mail folder that you will copy emails from.
Note: If you do not want to copy each email’ message text to Excel, please ignore below three steps and jump to Step 5 directly.

2. Turn off the Reading Pane by clicking View > Reading Pane > Off. See screenshot:

3. Click View > Add Columns to open the Show Columns dialog box. See screenshot below:

4. In the opening Show Columns dialog box, please choose All Mail Fields from the Select available columns from drop down list; click to highlight the Message option in the Available columns section, and then click the Add button and OK button successively. See screenshot above.

5. Now select all emails in the open folder, and copy them with pressing the Ctrl + C keys simultaneously.
Note: There are two methods to select all emails in the open mail folder in Outlook: A. Select the first email in the mail list, and then press the Ctrl + Shift + End keys at the same time; B. Select any email in the mail list and then press the Ctrl + A keys at the same time.

6. Create a new workbook, and then paste the emails into Excel with selecting the Cell A1 and pressing the Ctrl + V keys simultaneously.

7. Save the workbook.

Note: If you want to save all emails as an CSV file, please click File > Save as in the workbook to save it as an CSV file.

3 steps to export all emails from an Outlook mail folder to Excel

In general, you can apply the Import / Export feature to export emails from an Outlook mail folder to an Excel workbook with 12 steps. However, if you have installed Kutools for Outlook, just 3 clicks are enough with the Quick Report feature!


Export all emails from a mail folder in Outlook to Excel/CSV with Import/Export feature

This method will introduce Microsoft Outlook’s Import and Export Wizard to export all emails from a mail folder to Excel workbook.

1. Click File > Open & Export (or Open) > Import/Export (or Import).

2. In the opening Import and Export Wizard, please click to highlight the Export to a file option, and click the Next button.

3. In the opening Export to a File dialog box, please click to highlight the Comma Separated Values option, and click the Next button.

4. In the new Export to a File dialog box, please click to highlight the mail folder that you will export emails from, and click the Next button.

5. In the third Export to a File dialog box, please click the Browse button.

6. In the popping up Browse dialog box, please specify the destination folder you will save the exported CSV file into, name it in the File name box, and click the OK button. See screenshot above:

7. And then click the Next button in the Export to a File dialog box.

8. In the last Export to a File dialog box, please check the Export “E-Mail messages” from folder option to open the Map Custom Fields dialog box. See screenshot below:
Note: If the Map Custom Fields dialog box does not come out, please check the Export “E-Mail messages” from folder option, and then click the Map Custom Fields button.

9. In the Map Custom Fields dialog box, please add or move fields in the To section as you need, and then click the OK button. See screenshot above:

10. Click the Finish button in the opening Export to a File dialog box.

So far, all emails in the specified mail folder have been exported as an CSV file already. To save as an Excel file, please go ahead as follows:

11. Go the destination folder, right click the exported CSV file, and then select Open with > Excel from the right-clicking menu. See screenshot:

12. Now the exported CSV file is opening in Excel. Please save the Excel workbook.

So far we have exported all emails from the specified mail folder in Outlook to a new Excel workbook already.


Export each email from an Outlook mail folder to an individual Excel/CSV file

If you have Kutools for Outlook installed, you can apply its Save as File feature to easily export each email from an Outlook mail folder to an individual Excel file or CSV FILE in bulk with several clicks only. Please do as follows:

Kutools for Outlook: Ultimate Outlook toolkit with over 100 handy tools. Try it FREE for 60 days, no limitations, no worries!   Read More...   Start Free Trial Now!

1. Open the specified mail folder in Outlook, press Ctrl + A keys to select all emails in it, and click Kutools > Bulk Save.
doc copy email to excel 001

2. In the Save messages as other files dialog box, please click Browse button  to specify the destination folder you will save the Excel files, check the Excel format option (or CSV format option) only, and click the Ok button. See screenshot:
doc copy email to excel 002

Now you will see each email in the specified mail folder is exported as an individual workbook (or CSV file) in bulk. See screenshot:


Export all emails from a mail folder in Outlook to Excel with an amazing tool

If you have Kutools for Outlook installed, you can apply its Quick Report feature to quickly export all emails from an Outlook folder to Excel with only 3 steps.

Kutools for Outlook: Add more than 100 handy tools for Outlook, free to try with no limitation in 60 days. Read More      Free Trial Now

1. Click to select the specified mail folder on the Navigation Pane, and click Kutools Plus > Quick Report.

2. In the Save Report dialog, click the select the destination folder you will save the Excel file into, name the output file in the File name box, and click the Save button.

3. Now a dialog box comes out and asks your permission to open the output file. Click Yes to go ahead.

So far, all emails in the specified mail folder have been exported into the newly opening workbook.


Related articles:


Best Office Productivity Tools

Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook

🤖 AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

📧 Email Automation: Out of Office (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

📨 Email Management: Easily Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

📁 Attachments ProBatch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

🌟 Interface Magic: 😊More Pretty and Cool Emojis   /  Boost Your Outlook Productivity with Tabbed Views  /  Minimize Outlook Instead of Closing ...

👍 One-click Wonders: Reply All with Incoming Attachments  /   Anti-Phishing Emails  /  🕘Show Sender's Time Zone ...

👩🏼‍🤝‍👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Over 100 Features Await Your Exploration! Click Here to Discover More.

Read More       Free Download      Purchase
 

 

Comments (12)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Hello there, Thank you for this helpful tutorial
I just have a question is there a way to export sender email not just the name, Because as you explained its just export sender name

Thank you
This comment was minimized by the moderator on the site
Hi Sir
I am trying to extract content from multiple attachments from multiple emails in outlook to an excel file. export/import option downloads only the body of the message. No feature is available to extract the content of the attachments. can you help please?
This comment was minimized by the moderator on the site
Hi there,

Sorry that we do not have such features. You can submit the feature request to 🙂

Amanda
This comment was minimized by the moderator on the site
I just tried the Outlook Options/Advanced/Export function and I can get the fields I wanted for each message, but somehow not the Receive Date.  I don't see anywhere in the process to add that field.
This comment was minimized by the moderator on the site
Hi there,

Unfortunately exporting to CSV from Outlook does not have the option to include date and time. However, you could use the Quick Report feature from Kutools for Outlook.

1. Go to the Kutool Plus tab, click the drop-down arrow and then select Settings.
2. In the pop-up setting panel, tick the ones you want to export. Then click Quick Report.

If you don't have Kutools for Outlook installed, click here to download and enjoy a full-function free trial for 60 days: https://www.extendoffice.com/download/kutools-for-outlook.html

Amanda
This comment was minimized by the moderator on the site
I've now bought KuTools for Outlook. The 3 steps you describe doesn't work. I have a folder with 299 mails and 299 mail addresses, but when I follow your 3 steps, the Excel file only shows 4 e mail adresses
This comment was minimized by the moderator on the site
Hi there,
When you followed the 1st step, did you select the specific mail folder that you want to extract mails from?
If yes, could you advice what version of Outlook and computer system you are using? Since I just tried the Quick Report feature, it worked well, extracted all the mails (556 in total) from the inbox I selected.
Amanda
This comment was minimized by the moderator on the site
Thanks for the tutorial. I wanted to extract specific informations from my email contents but couldn't see how to do it with this method. I ended using a mail parser for it (Parseur.com), and it worked great!
This comment was minimized by the moderator on the site
Hi Matt,
Could you tell more about your problem? For example which kind of information you want to extract?
This comment was minimized by the moderator on the site
Hi Kelly,


I need help with the 30 day look-back for the mailbox! I am looking to export all the emails from last 30 days including, dates, times sender,receiver,detailed messages in some format. Would you please help?




Thank you
Shruj
This comment was minimized by the moderator on the site
Hi Shruja,
Normally, the Import and Export feature can not export message content in Outlook. If you need to export the message content, I suggest to custom your folder view settings to list all fields you want to export, show the folder in list view, and then copy to Excel or other applictions.
This comment was minimized by the moderator on the site
Hi Kelly,


I am looking for help with Outlook. I have emails from last 30 days and I would like get all the information Including the message, Date, Time, and Who it was sent to all the details into Excel. Is it possible to do it?
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations