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.
No, it is not possible to change it when downloading. However, you can load it in a spreadsheet or script and change the format of the duration.
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.