Convert the outbox.json in a Mastodon account export to a CSV with columns published, to, and content.

extract.py

#!/usr/bin/env python3

import csv
import json

data = json.load(open("outbox.json"))

out = csv.DictWriter(open("outbox.csv", "w"), ["published", "to", "content"])
out.writeheader()

for post in data["orderedItems"]:

    # boosts just have the original post URL as content
    if type(post["object"]) == str:
        content = post["object"]
    else:
        content = post["object"]["content"]

    out.writerow({
        "published": post["published"],
        "to": "|".join(post["cc"]),
        "content": content
    })