SimpleScrumTools

Portfolios and projects

Exporting a project

Download the backlog as a .csv file, the whole project as .json, or a sprint report as a PDF.

Where to find it

NeedsView view

Open the project, and scroll to Export, under Import. Anyone who can see the project can download it: everything in a download is already on the project's screens.

The backlog as .csv

Backlog as .csv downloads one row for every item in the project, in backlog order. Done items are included. Deleted items are not. The columns are Key, Name, Summary, Description, Notes, Status, Priority, Size, Type, Phase, Epic, Sprint, Assignee, Blocked, Blocked by, External ID, Created and Updated. Created and Updated are in UTC.

The file opens in Excel, Numbers and Google Sheets. A cell that starts with =, +, - or @ is written with an apostrophe in front, so a spreadsheet shows it as text rather than running it as a formula. The same apostrophe goes in front of one of these characters after a semicolon or a tab, or at the start of a later line in a cell, so a list in a description shows it on each line.

The file imports back, into this project or another. See Importing a backlog. If your text already holds an apostrophe in one of these places, the export writes a second one. The import removes one apostrophe from each of these places, so your text comes back as you typed it. It removes one from a file that another tool wrote too. It suggests Key for External ID, so each new item remembers the key it had. Map External ID instead to keep the external IDs. Status, Sprint and Assignee are not imported: every imported item starts as a Draft in the backlog.

Into another project, a row imports only when that project has a phase, item type and epic of the same name. Create them first, or set the Phase, Type and Epic columns to Ignore in the preview, and the items land in the default phase.

Everything as .json

Everything as .json downloads the whole project in one file: its settings, phases, item types, epics, Definition of Done, sprints and their Increments, every item, impediments, and every Scrum Event with its notes and cards. Items are named by their key, sprints by number and people by display name. The file holds no email addresses and no internal IDs.

A sprint report as PDF

  1. Open Reports and pick the sprint. See Reports.
  2. Click Save as PDF, beside the title.
  3. In the print dialog, choose Save as PDF as the destination. On an iPhone or iPad, tap the Share button at the top of the print options, then Save to Files.

The PDF holds the sprint's health, its list of items, the burndown and velocity, each with its table of numbers. It prints in the light theme, without the menus.