Content:
1. How to access the Import tool in Kanbanize?
2. How to format your Excel Spreadsheet for a successful import?
Importing cards and initiatives using an Excel spreadsheet is the quickest way to populate your Kanban board, without having to create cards manually.
With this functionality, users can easily import cards from external systems as well as update existing boards and cards. Users can also export cards from the Kanban boards to import them on other boards within the account or transfer them to other systems.
1. How to access the Import tool in Kanbanize?
Open the board where cards and initiatives will be imported and go to the Board Sidebar, located to the right side of your Board -> select the Import icon (img.1).
Note: The system allows users to import items both to the Cards Workflow and to the Initiative Workflow. Make sure that the column names in the workflows are different, otherwise, the items will be imported to the Cards Workflow.
Img.1
Once in the Import tab -> click the "Browse…" button and choose the xls or xlsx file from your computer. Check out how to format your Excel spreadsheet for a successful import (p.2 below).
When the file is uploaded, the system will validate your data for compatibility and the validation status will be displayed. Columns marked in red are not recognized as card fields and their values are not imported. For example, the image below (img.2) displays the Tag column mistyped (it should be Tags) and highlights the incorrect column in red.
Canel the import by closing the import window and correct the mistake in your Excel file.
Then upload the updated file again and select "Import".
Img.2
You will get a System Notification message: "Your import has started and you should see the cards appearing on your board. After the import is completed, you will receive an email with the status for all cards." -> click OK.
Note: If you do not specify a column where cards to be imported, they will become available in the Backlog column or in the column/swimlane set as default in your Personal Board Settings.
2. How to format your Excel spreadsheet for a successful import?
Step 1: Create an xls or xlsx file that needs to be properly formatted, so that your data can be matched to the cards' fields in Kanbanize. In the spreadsheet, give descriptive names (column headers) to the columns matching any of the following Kanbanize card properties:
'Title', 'Description',"Card ID", 'Custom Card ID", 'Priority', 'Assignee', 'Color', 'Size', 'Tags', 'Deadline', 'Ext link', 'External link', 'Template', 'Type', 'Type name', 'Column', 'Column name', 'Lane', 'Lane name', 'Comment', 'Parent', 'Creation date'.
Select the properties in accordance with your specific needs.
Important:
- Make sure that each column header in the Excel file is typed correctly, otherwise you will not be able to import the values of that column.
- The card field “Title” is mandatory for the successful import. All other fields are optional.
Step 2: Insert the respective properties' values in each of the columns.
Take a look at the following file to see what an example of an Excel spreadsheet file should look like.
Notes:
- The allowed Deadline date formats are as follows: MM/DD/YYYY, DD-MM-YYYY, YYYY-MM-DD
- If you want to import tasks and link them as child cards to existing Parent or Initiative cards, your Excel file should have a column header “Parent” that holds the existing Parent/Initiative IDs e.g. 2756, 3281, etc.
For example: If you import Table 1 (see the image below), the system will import and link 4 of the child cards titled: Test 1, Test 2, Test 3, Test 4 to the existing Parent ID 2756 and 1 child card titled Test 5 to the existing Parent/Initiative ID 3281.
Note: The parent cards 2756 and 3281 are existing cards on the Board.
Table: 1
- Custom fields can be imported, if they have been assigned to the board prior to the import. The column headers in your spreadsheet need to match the name of the Custom field you wish to import.
For Example: The column headers in Table 2: Sign off by; Version; Severity and Customer are custom fields that have been created and added to the board prior to the import.
Table 2
Related articles:
To learn how to update & move cards or initiatives using Excel, please check the following dedicated article.
To learn how to export cards from Kanbanize, check the dedicated article.
To learn how to import and export cards using the "Kanbanize for sheets" add-on, check the dedicated article.