To upload an Excel file into PaceMkr, it has to follow a specific format. This tutorial guides you to make sure your Excel file will be understood by PaceMkr.
To follow along, you can download this sample Excel spreadsheet.
Arrange your data
The first step is to to create a spreadsheet with the following columns:
| Title | Description |
|---|---|
| ID | The column of your product backlog item |
| Link (optional) | A URL of the product backlog item in your tracking software (if you have one) |
| Title | The summary or title or name of the product backlog item |
After these first 3 columns, you then add the columns of your workflow. Suppose you have the following workflow:
Then you would have the following columns in the spreadsheet:
| ID | Title | Backlog | To Do | Development | Testing | Deployment | Done |
|---|---|---|---|---|---|---|---|
| 1 | Some name |
As for the values in these columns, you put the date at which your PBI entered each column, leaving it blank for columns it didn’t go into or hasn’t gone into yet.
The dates should not include the time. At this time, PaceMkr only supports dates.
You can add additional columns after the workflow columns. These are properties on your product backlog items such as:
| Name | Description |
|---|---|
| State | Know the states of the product backlog items. |
| Type | The types of the product backlog items in your data. |
| Priority | The priority of your product backlog items. |
| Epic name | The name of the epic to which this product backlog item is linked to. |
| Tags | Additional tags used to filter on specific product backlog item types. |
Once your Excel spreadsheet is ready, you can load it in the Excel wizard.