Converting Trello JSON to CSV and Managing with Google Spreadsheets

Tadashi Shigeoka ·  Thu, July 19, 2018

I’ll introduce the procedure for converting JSON exported from Trello using “Export as JSON” to CSV and managing it with Google Spreadsheets.

Trello トレロ

Prerequisites: Installing Trelloparse

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

Procedure for Converting Trello Cards to Google Spreadsheets

The procedure for converting Trello cards to Google Spreadsheets is as follows:

  1. [Menu] - [More] - [Print and Export] - [Export as JSON]
  2. Trello JSON parser
  3. JSON to CSV Converter Online
  4. Import Google Spreadsheet

Export as JSON

I created a sample Trello Board CodeNote.net | Trello for this article.

Export as JSON | Trello

From [Menu] - [More] - [Print and Export] - [Export as JSON], you can download a JSON file like the following.

Format with trelloparse

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 JSON 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.

Import file on Google Spreadsheets

Finally, import the CSV file into Google Spreadsheets.

That’s all from the Gemba where I want to aggregate Trello cards in Google Spreadsheets.