Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Where can I find a complete description of the Trello JSON format ?

frederic Jugé
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 5, 2023

Good morning I did a JSON export of my Trello cards to convert them to Excel format. But I can't find everything I need, ie the date of creation of a card, its label, and the column in which it is located. Where can I find a complete description of the JSON format used by Trello? Thank you so much.

1 answer

0 votes
Alina Kurishko
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 6, 2023

Hi Frederic, 

Welcome to the Atlassian Community!

First, have you tried looking through the article we have concerning how to make sense of Trello's JSON export? You can find it at https://support.atlassian.com/trello/docs/making-sense-of-trellos-json-export/

Hope it brings a little more clarity! 

I can also suggest trying to search (using the default Cmd+F on macOS or Ctrl+F on Windows in your browser) for fields with names like "date", "list", and "labels" if you want to find exact info about cards. These details would look similar to the pieces below (I've obfuscated some identifiable information with ***): 

"date":"2023-06-06T11:13:38.889Z"
"list":{"id":"***","name":"***"}
"labels":[{"id":"***","idBoard":"***","name":"Green","color":"green"}]

 I hope this information helps! 

Alina | The Trello Team

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events