Can you change which values are included and how they are formatted, when you download a report as a CSV file from Toggl?
I would like to get the duration of the different tasks in a format that numbers can understand as a duration value.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
I wrote this Python script that fixes the toggl.com CSV for my purposes, it may be a useful starting point for your needs:
#!/usr/bin/env python import csv import sys import operator r = csv.reader(sys.stdin) rows= for row in r: row = "'%s" % row row = "'%s" % row row = "'%s" % row rows.append(row) rows = [rows] + sorted( rows[1:], key=operator.itemgetter(5) ) w = csv.writer(sys.stdout) for row in rows: w.writerow(row)
The script may be useful for Excel users too, I have not checked.