Importing Data from Trello

Here's how to export data from Trello when you're switching from Trello to awork, prepare the CSV in Excel, and transfer the contents into the awork import template.

How to Import Data from Trello

Export Data from Trello

First, export your data from Trello. You can find instructions here: Exporting Data from Trello.

Split CSV into Columns in Excel

Trello exports your data as a .csv file. You can open it with Excel. However, all the data will be separated by commas in a single column.

Here's how to split the data into individual columns:

1. Select the column with your data

2. Go to Data in Excel and then click Text to Columns

3. Select the Delimited option in the pop-up

4. Choose Comma and click Finish

Field Mapping (Trello Export → awork Import Template)

Now your data will be displayed in individual columns. You can copy this data into the awork import template.

The field mapping looks like this:

Field Mapping via Chrome Extension

If you're using the Trello Chrome Extension, use this field mapping instead:

Upload Data to awork

After that, you can upload your data to awork as described here.

Tips and Best Practices

• Split Excel columns first before copying data into the awork import template

• Watch out for missing Trello fields: Some awork fields are not available in the Trello export (see tables above)

• Choose the correct mapping: Trello export and Chrome Extension provide different field names (for example, Status)

FAQ

Can I always export Trello data?

Trello only allows data exports for Business Class customers. As an alternative, this article mentions the Trello Chrome Extension.

What format does Trello use to export data?

Trello exports your data as a .csv file.

Why is all my data in a single column when I open it in Excel?

The values in the CSV are separated by commas. You can split them into individual columns in Excel using Data → Text to Columns (select Delimited option with Comma as the separator).