For an easier import of your data, we have prepared instructions for export and preparation of data for the following tools:
Import data from Trello
First, you need to export your data from Trello. Please go here to see how to export the data.
☝️Important: Trello allows only Business Class clients to export data or alternatively install the Trello Chrome Extension.
Trello 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 Columns
Select the option Delimited in the pop-up
Select the option comma and select finish
Data matching
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 | Trello |
Project name | Name of the board |
Client | Name |
Task name | Field is not available in the Trello export |
Description | Desc |
Type of work | Field is not available in the Trello export |
Start date | Field is not available in the Trello export |
Due date | Due |
Planned Effort | Field is not available in the Trello export |
User | Members |
Status | idList |
Data matching via Chrome Extension
awork | Trello |
Project name | Name of the board |
Client | Field is not available in the Trello export |
Task name | Title |
Description | Description |
Type of work | Field is not available in the Trello export |
Start date | Field is not available in the Trello export |
Due date | Due |
Planned Effort | Field is not available in the Trello export |
User | Member |
Status | List |
Now you can import the data into your workspace, as described here.
Import data from Asana
First, you need to export your data from Asana. Asana gives you the option to export projects 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 Columns
Select the option Delimited in the pop-up
Select the option comma and select finish
Data matching
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 |
Task name | 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 |
User | Assignee |
Status | Field is not available in the Asana export |
Now you can import the data into your workspace, as described here.
Import data from Monday
First, you need to export your data from Monday. There are two options:
There will be an Excel file for every board in both cases, from where you can copy the content to the awork import template. The field-mapping is the following:
awork | Monday |
Project name | Name of the board |
Client | Field is not available in the Monday export |
Task name | Name |
Description | Field is not available in the Monday export |
Type of work | Field is not available in the Monday export |
Start date | Field is not available in the Monday export |
Due date | Date |
Planned Effort | Field is not available in the Monday export |
User | Person |
Status | Status |
Now you can import the data into your workspace, as described here.
Import data from Jira
First, you need to export your data from Jira. To do so, go to the project, select Issues and filters, and click on advanced search. Now select Advanced Search. Afterward, an Export button should appear in the top right corner. Select the option Export Excel CSV (all fields) and download the .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 Columns
Select the option Delimited in the pop-up
Select the option comma and select finish
Data matching
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 | Jira |
Project name | Project Name |
Client | Field is not available in the Jira export |
Task name | Summary |
Description | Description |
Type of work | Issue Type |
Start date | Field is not available in the Meistertask export |
Due date | Due Date |
Planned Effort | Original Estimate |
User | Assignee |
Status | Status |
Now you can import the data into your workspace, as described here.
Import data from Meistertask
First, you need to export your data from Meistertask. Please go here to see how to export the data.
Meistertask 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 Columns
Select the option Delimited in the pop-up
Select the option comma and select finish
Data matching
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 | Meistertask |
Project name | Field is not available in the Meistertask export |
Client | Field is not available in the Meistertask export |
Task name | name |
Description | notes |
Type of work | Field is not available in the Meistertask export |
Start date | Field is not available in the Meistertask export |
Due date | due_date |
Planned Effort | Field is not available in the Meistertask export |
User | assignee |
Status | section |
Now you can import the data into your workspace, as described here.