We recommend knowing what information you're looking for going in, and using the 'find' feature in your spreadsheet viewer to find it-that will typically be easier than looking for it yourself. However, if you're trying to extract a single piece of information from the JSON these converters can make that task a little easier. If a developer isn't available, you may want to try using an online JSON-to-CSV converter, such as:īecause of the one-to-many nature of Trello data (one card can map to several pieces of information-multiple comments, checklist items, etc.), the converted CSV usually isn't usable as a document to present to others.

To do this, we suggest reaching out to a developer-JSON, particularly when it's covering a whole board, can be complicated to parse out correctly. You may run into a situation where you need to use Trello's JSON export to locate a piece of information. Here's a link you can use to search for these - Īnother option is the TrelloExport Chrome extension: If you're not working with a Premium Workspace, or want to pull information from the JSON that isn't included in the Premium CSV export, the first thing we'd suggest is looking at the third-party Power-Ups that exist for Trello as you may be able to use one of this to link between Trello and another app to display this data in another app (e.g.

in a single row in Excel, since some of it contains information about actions over time (movement) and some contains information about static information (the content of new checklist items, for example). That nesting and one-to-many nature of the data is why some of this information isn't included on Trello's CSV export. That information is hard to represent e.g. For example, for a single card, you can have information about what's currently on the card, a history of what was previously on the card, information about changes that have been made to the card (moves between lists), and information about structures that are themselves nested (like checklist items within a checklist on a single card). One of the difficulties with making Trello's JSON human-readable is that in many cases, there are multiple pieces of information nested within a single structure. There's also a JSONView add-on for Firefox. JSON without the Chrome JSONView extension.įor Chrome, we recommend the JSONView extension.

Open json in excel