Importing Outlook Tasks to Wrike
All users (except collaborators) can import Outlook Tasks to Wrike.
Adding tasks to Wrike from Outlook can be done in three steps:
-
Export tasks from Outlook.
-
Add Outlook tasks to a Wrike import template.
-
Import tasks to Wrike.
-
Open Outlook.
-
Click the File tab.
-
Select Open & Export and click Import/Export.
-
In the pop-up that appears, select Export to a file and click Next.
-
In the following pop-up select Comma Separated Values and click Next.
-
Select Tasks in the list that appears, and click Next.
-
Choose where you'd like your file to be saved and rename the file (if you'd like to), then click Next.
-
Click Finish.
Your CSV file is now saved to your computer in the location you specified during the export process.
Note
if you have recurring tasks, you may get a dialog box warning you that the file type you're exporting to doesn't support recurring tasks. Press OK on the dialogue box to export recurring tasks as individual occurrences. You'll be able to select the date range you'd like to export recurring tasks.
-
Open Outlook.
-
Click the File tab.
-
Select Options and click the Advanced tab.
-
Click the Export button.
-
In the pop-up that appears, select Export to a file and click Next.
-
In the following pop-up, select Comma Separated Values (Windows) and click Next.
-
Select Tasks in the list that appears, and click Next.
-
Choose where you'd like your file to be saved and name it, then click Next.
-
Click Finish.
Your CSV file is now saved to your computer in the location you specified during the export process.
-
Open Wrike and download and open a Wrike import template in Excel.
-
Open the CSV file you created and copy the data from the following columns:
-
Subject
-
Start date
-
Due date
-
Notes
-
-
Paste the information into the corresponding columns in the Wrike template:
-
Subject > Title
-
Start date > Start date
-
Due date > End date
-
Notes > Description
-
-
Add a unique number in the "Key" column for each task that you need to add to your Excel file.
After transferring data from the CSV file to the Wrike template, you can immediately upload the task information to Wrike or add additional details first.
The last step is to import your tasks into Wrike. You can either import your tasks into an existing folder or project or create a new folder or project in Wrike where you'd like to add tasks.
-
Navigate to a folder, project, or space where you want to add tasks from Outlook.
-
Click the three-dot menu button at the upper right-hand corner of the view you're in.
-
Hover over Import and select Excel.
-
Press Select file in the pop-up that appears.
-
Select the file you want to import.
-
Click Next.
-
If you have names listed in the "assigned to" column, you'll be asked to associate users in your Wrike contact book with the names indicated in the "Assigned to" column of the spreadsheet.
-
Click Next and press Yes when you're asked to refresh the page.
Your Outlook tasks are now added in Wrike.