Skip to main content
Import data from other tools

This is how you export your data from Trello, Asana, Monday, Jira, or Meistertask to import it into awork afterward easily.

Merle avatar
Written by Merle
Updated over a week ago

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:

  1. Select the column with the data

  2. Go to Data and Text to Columns

  3. Select the option Delimited in the pop-up

  4. 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:

  1. Select the column with the data

  2. Go to Data and Text to Columns

  3. Select the option Delimited in the pop-up

  4. 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:

  1. Select the column with the data

  2. Go to Data and Text to Columns

  3. Select the option Delimited in the pop-up

  4. 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:

  1. Select the column with the data

  2. Go to Data and Text to Columns

  3. Select the option Delimited in the pop-up

  4. 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.

Did this answer your question?