First you need to export your data from Asana. Asana fives you the option to export porjects or the whole company (only for Enterprise customers). Please go here to see how to export the data.
Asana exports the data as a .csv file. You can open the .csv with excel, but all the data will be in one column. You can change that by performing the following steps:
- Select the column with the data
- Go to "Data" and "Text to Colums"
- Select the option "Delimited" in the pop-up
- Select the option "comma" and select "finish"
The content will now be in different columns, from where you can copy the content to the awork import template. The field-mapping is the following:
| awork | Asana | |
| Project Name | <-> | Projects |
| Client | <-> | Field is not available in the Asana-Export |
| Taskname | <-> | name |
| Description | <-> | Field is not available in the Asana-Export |
| Type of Work | <-> | Field is not available in the Asana-Export |
| Start Date | <-> | Start Date |
| Due Date | <-> | Due Date |
| Planned Effort | <-> | Field is not available in the Asana-Export |
| Assignee | <-> | Assignee |
| Status | <-> | Field is not available in the Asana-Export |
Now you can import the data into your workspace, as described here.