Excel file format

Tutorial to learn how to understand the Excel file format required by PaceMkr.

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.

You've successfully subscribed to PaceMkr
Great! Next, complete checkout for full access to PaceMkr
Welcome back! You've successfully signed in
Success! Your account is fully activated, you now have access to all content.