How to export Outlook task to Excel, CSV and Outlook Message (msg)

Exporting  Outlook tasks to Excel, CSV and .msg formats

An ideal way to back up your Outlook task is to synchronize between your cloud task such as Google and your Outlook with some sync Outlook add-in like EVO Collaborator for Outlook. However, when such synchronization is not available, you can still manually export your Outlook task to your external hard drive by some mean. Besides EVO’s Power Toys for Outlook (Click to download for trial),

Outlook generally provides 3 formats that tasks can be exported into with some downfall which we will talk about later in this article. Let’s first brief what these 4 formats are:

Outlook Message Format – Unicode:

Advertisement

  • Outlook saves tasks into a file format of Outlook Message Format. One thing good about this file is that this file format retains all properties and metadata fully compatible with Outlook.
  • Other than Outlook Message Format -Unicode, theoretically, Outlook tasks can also be saved as .ICS file format with aide from CalDAV protocol. Some Outlook add-in is able to convert Outlook tasks into .ICS and interact with other CalDAV task services on the market.
  • Export:
    • Each of these Outlook Message Format files counts toward one task and it can be imported back to Outlook. The downfall of saving events into .ics or .vcs files is that you can only save one event at a time. Up to some point, it is not practical when trying to import a large number of tasks at once. If you try to select all your tasks and save them, you would end up with one single TXT file instead. This TXT file cannot be used for import and it is probably good for printout.
    • You can follow the steps below to save your task as Outlook Message Format – Unicode file: (We use Outlook 2016 in tutorials throughout this article)
      1. Click on Tasks at lower-left.
      2. Click on selected task entry in the selected task folder under Navigation Pane of My Tasks.
      3. Click on File at top-left.
      4. Select Save As.
      5. Browse to location where you will be saving the msg file.
      6. Click on Save button.
    • If you have e-mail access, then there is another way to compliment the above one-by-one vCard saving solution:
      1. Click on Tasks at lower-left.
      2. Select the task folder you want to export under Navigation Pane of My Tasks.
      3. Use hotkey of CTRL + A to select all tasks and CTRL + C to copy all of them.
      4. Click on Mail at lower-left.
      5. Click on New Email at top-left.
      6. Fill in e-mail address you want to send your tasks backup to.
      7. Click on body section of the newly created e-mail.
      8. Use hotkey of CTRL + V to paste all the tasks you just copied to clipboard.
      9. Click on Send button to send tasks to your e-mail address.
  • Import:
    • There are two methods to import your msg files of Tasks back to Outlook. One is through Drag & Drop:
      1. Open Windows Explorer.
      2. Browse to the folder where msg files of Tasks are located.
      3. Select all that you like to import by hot key of CTRL+A for selecting all msg files or CTRL+Mouse Click for multi-select.
      4. Drag all selected files and drop them in the folder of your choice under My Tasks in Outlook’s Navi Panel.
    • Another method is is through open and save:
      1. Open Windows Explorer.
      2. Browse to the folder where msg files of Tasks are located.
      3. Select one msg file of Tasks and double-click the file to open it.
      4. Click on File at top-left.
      5. Click on Move to Folder button and select Copy to folder….
      6. Select the folder where you like to move the task to.
      7. Click on OK.
    • Note: .msg files cannot also be imported into Thunderbird due to file incompatibility.

CSV: Export Outlook tasks to CSV

  • Export:
    • CSV (Common Separated Values) file is commonly used to store data for import and export in various software applications. Outlook uses CSV to store its task entry information since common (,) can be conveniently used to separate all fields. However, exporting Outlook tasks into a CSV file has a potential character encoding issue that characters other than ASCII and the language version your Outlook was installed contained in the task entries will be corrupted. For example, if you install the Korean version of Outlook and your task entries contain any Japanese hiragana or katakana,which are not in UTF-8 or Unicode, then these Japanese characters will appear as junky characters or question marks in the exported vCard files even though they look OK in Outlook before exporting.
    • One good thing about using CSV is that you export the whole task folder or sub-folder as a whole. The following steps will walk you through on how to do it:
      1. Click on File at top-left.
      2. Click on Open & Export.
      3. Select Import/Export.
      4. Select Export to a file and click on Next >.
      5. Keep Common Separated Values selected and click on Next >.
      6. Select task folder you want to export and click on Next >.
      7. Click on Browse button to browse a location for saving file.
      8. Enter file name and then click on OK and Next >.
      9. Click on Finish.
      10. Enter date range of date during which appointments will be exported and click on OK. (Note that only part of recurring appointments falling into the date range will be exported.)
      11. As an export result, non-ASCII or non-Unicode foreign characters will end up series of question marks that we mentioned earlier in this section.
  • Import:
    • Outlook provides an import wizard to facilitate bringing task entries stored in CSV files:
      1. Click on FILE at top-left.
      2. Click on Open & Export.
      3. Select Import/Export.
      4. Select Import from another program or file.
      5. Keep Common Separated Values selected and click on Next >.
      6. Click on Browse to the folder location where you keep the CSV file.
      7. Click on one of radials under Options.
      8. Select a task folder as your destination in the folder tree and hit Next >.
      9. Make sure item in action list is checked and click on Finish.
    • As an import result, non-ASCII or non-Unicode foreign characters will end up series of question marks that we mentioned earlier in this section.
    • CSV file exported from Outlook cannot be imported to Thunderbird perhaps due to incompatibility of field positioning.

Excel Spreadsheet: Export Outlook tasks to Excel 2016/2013

  • Export:
    • Outlook tasks are usually displayed in Simple-List view. If we like to simply copy & paste Outlook task entries to Excel spreadsheet, then it is better we change view to Detailed view. Moreover, by looking at the Detailed view, some of the fields we use within task entries may not be seen. Therefore, we need to make them visible before exporting. How? We add items via Add Columns.
    • Copy & pasted task entries with foreign language characters are looking OK within Excel because Excel supports multi-languages. However, exporting the CSV file will result the same character encoding issue like exporting as CSV producing junky characters above.
    • The following steps will export Outlook tasks via Copy & Paste method:
      1. Click on Tasks at lower-left.
      2. Select the task folder you want to export under Navigation Pane of My Tasks.

        export outlook tasks to excel
      3. Click on VIEW ribbon at top.
      4. Select Change View to the left.
      5. Click on Detailed and tasks events will appear in a listing fashion.
      6. If additional fields need to be included, click on Add Columns.
      7. Select field such as Owner to the left and click on Add -> button. Then, Owner will appear in the list to the right. If you need to re-arrange order of fields, then select fields and click on Move Up or Move Down to change position. When you finish, click OK to leave the Window.
      8. Use hot key of CTRL + A to select all tasks entries and use CTRL + C to copy them onto clipboard.
      9. Switch to Excel where you open a new workbook. Use CTRL + V to paste all copied entries.
  • Import:
    • How do we import the saved Excel file back to Outlook since XLSX file extension is not an option in import source list? This is easy! What we do is save the workbook into a CSV file and follow the CSV import steps above. To save workbook files as CSV files, follow the steps below:
      1. In Excel application, open the Excel file and click on FILE at top-left.
      2. Select Save As to the left.
      3. Click on Browse icon to browse the folder location where you want to save the CSV file.
      4. Pick a name for the CSV file.
      5. Click on Save as type pull-down list and select CSV (MS-DOS) or CSV (Comma Delimited).
    • As an import result, non-ASCII or non-Unicode foreign characters will end up series of question marks that we mentioned earlier in this section.

Leave a Reply