slack_to_csv.py

# -*- coding: utf-8 -*-

import json
import datetime
import csv
import codecs

d = datetime.datetime(2017, 9, 1, 0, 0, 0, 0)
rows = []
while True:
    fname = d.strftime("%Y-%m-%d.json")
    try:
        f = open(fname)
        data = json.load(f)

        for m in data:
            row = []
            row.append(str(m["user"]))
            row.append(m["text"])
            row.append(str(m["ts"]))
            print("%s,%s,%s" % (row[0],row[1].replace("\n", "\\n"),row[2]))

        f.close()
    except:
        pass
    d = d + datetime.timedelta(days=1)

    if fname == "2018-01-16.json":
        break


f = open('messages.csv', 'w')

writer = csv.writer(f, lineterminator='\n')
writer.writerows(rows)

f.close()