Converting Trello JSON to CSV and Managing with Google Spreadsheets
I’ll introduce the procedure for converting JSON exported from Trello using “Export as JSON” to CSV and managing it with Google Spreadsheets.
Trelloparse can be installed with the following commands. I’m installing it to /usr/local/bin/ which is in the PATH.
sudo curl https://gist.githubusercontent.com/RealOrangeOne/c35751ee794e90df512bdfba6f22574d/raw/trello-parser.py -o /usr/local/bin/trelloparse
sudo chmod +x /usr/local/bin/trelloparse
The procedure for converting Trello cards to Google Spreadsheets is as follows:
I created a sample Trello Board CodeNote.net | Trello for this article.
From [Menu] - [More] - [Print and Export] - [Export as JSON], you can download a JSON file like the following.
Download the JSON file https://trello.com/b/LlqGZTul.json and parse it with the trelloparse command.
$ cd ~/Downloads
$ trelloparse LlqGZTul.json LlqGZTul-parsed.json
Reading Data...
Found 3 cards in 3 lists.
Parsing...
Output to /Users/username/Downloads/LlqGZTul-parsed.json!s
Please visit https://json-csv.com/ to convert the output to CSV.
Convert the JSON file parsed by the trelloparse command to a CSV file using a library or a site like json-csv.com.
Finally, import the CSV file into Google Spreadsheets.
That’s all from the Gemba where I want to aggregate Trello cards in Google Spreadsheets.