Is it possible to export my data from Trello, to back it up?

Question

Is there a way to export my data from Trello to my own computer?

I'm happy to accept any file format, so long as the data is in a file-format that can be parsed, e.g. I'm comfortable with writing a script to extract the data.

(I always try, with any online data I create, to find a way to export a copy of the data, and I have a Sunday evening routine of doing data dumps, then local backups.)

Answer 1

With the release of the Data Export feature, you can now

1. Go to your board
2. Click the "Board Menu" button (on the right-hand-side of the screen)
3. Select "Share, Print, and Export"
4. Click "JSON"

This will download a copy of your board data.

Pro tips:

• You can also just add .json (or /somename.json) to the end of a board or card URL, to get the prompt to save the downloaded file (e.g. https://trello.com/board/welcome-board/4e6a8095efa69909ba007382/somename.json)
• Alternatively, instead of clicking on the "JSON" button, you can right-click on it, and copy the URL
• If you have lots of boards that you want to download regularly, you'll have to save all the JSON links somewhere for all your boards, and download each one individually.
• Changing the names of all these individual files for each set of backups could get a little tedious, so one idea would be to create a new folder each time you backup your boards, and then save a set of exported files into that folder.

Answer 2

Update: This is now available from a print/share/export menu on board and card detail.

Not currently. But it has been requested often and should be coming soon.

There is currently a card for this: https://trello.com/card/board/data-export/4d5ea62fd76aa1136000000c/4e9d8a91f482dd34ea18335a

Answer 3

As a stopgap, there's a (third party) XML export bookmarklet here:

http://bryanesmith.com/downloads/trello-dump/

Note: Using this bookmarklet can break HTTPS. You might want to logout and login again after using this tool.

Answer 4

The following bookmarklet will only export an outline of your board; not nearly enough detail for a true export or backup, but it's a start. The script could be much more refined, but worked in IE9, FF 7, and Chrome against my own board and 3 others I tried.

javascript:
var l=document.getElementsByClassName('list');
var lp='';
for(x=0;x<l.length;x++){
    var ltc=l[x].getElementsByClassName('list-title');
    var lt=ltc[0].getElementsByTagName('h2');
    lp=lp+lt[0].innerHTML+'\n';
    var cards=l[x].getElementsByClassName('list-card-title');
    for(y=0;y<cards.length;y++){
        var cardTitle=cards[y].getElementsByTagName('a');
        lp=lp+'\t- '+cardTitle[0].innerHTML+'\n';
    }
}
var tad=document.createElement('div');
tad.innerHTML="<div align=\"right\">[<a href=\"#\"onClick=\"tad.style.visibility=\'hidden\'\;\">Close</a>]&nbsp<p/></div>&nbsp;Copy the text below into another editor for an outline of your board<p/>";
var ta=document.createElement('textarea');
ta.value=lp;
document.body.appendChild(tad);
tad.style.position="absolute";
tad.style.left='20%';
tad.style.top='20%';
tad.style.border='solid 2px black';
tad.style.backgroundColor='white';
tad.appendChild(ta);
ta.select();
void(0);

Answer 5

Please see http://trello.com/privacy for the prospects for data migration and APIs.

Answer 6

A card for data export has been added to the Trello Development board. It will likely be developed after the public API though.

https://trello.com/card/board/data-export/4d5ea62fd76aa1136000000c/4e9d8a91f482dd34ea18335a

Answer 7

If you want an automated solution, I've created a Google Spreadsheet that auto imports your open Trello boards every 4 hours. It's not as complete as the Trello export function, but it gives you most things you'd want. Details here: http://www.littlebluemonkey.com/blog/online-scrum-tools-part-4-trello-backup/

Answer 8

Joel has just tweeted that there's now a similar bookmarklet to dump Trello data to XML: Trello Dump

Particular differences from @BrettB's script here:

1. It's presented as a button on a web page, that can be dragged to a browser toolbar, so it's a bit easier to set up
2. It downloads the colour tag of each item (but not the name of the tag)

Answer 9

as recommended by Trello

1. Go to Board Menu > Share, Print, & Export (this will export the data to a JSON file)

2. Use this JSON to CSV converter to convert the JSON file to CSV format.

3. You will then have the data stored inside a readable file (CSV). This can then be opened up in Excel or Open Office.

Also see here