[Feature Request] Export the tasks as an Excel file

[huskier]

Sometimes we need to export the tasks as an Excel file for archiving or other purposes, so this feather request.

[brzd]

If possible, also ability to export in other formats. Would csv be easiest to start with?

Where are the tasks currently saved and in which format?

[raimund-schluessler]

You can download a complete calendar as ics file.

Tasks are save in the database as CalDAV entry.

[brzd]

Thank you!

@raimund-schluessler In more detail, how can I download tasks as ics file? I wasn't able find such an option or a right place to do that?

brzd

[raimund-schluessler]

@raimund-schluessler In more detail, how can I download tasks as ics file? I wasn't able find such an option or a right place to do that?

On the left side, click on a calendar / task list and on the three dots icon. Then select download. However, I don't know if that is a good replacement for exporting to excel, because you will get all tasks of that calendar in an unordered way.

[brzd]

@raimund-schluessler

Sorry, tasks are there, they were not imported correctly in outlook when tested.
[Tried that, but it only downloads calendar events. None of the tasks in task app are included.]

[brzd]

Easy way to export to excel is to select all tasks and just copy them to excel. You have to have all tasks expanded in the view. This way you get numbered tasks in original order pasted into separate rows in excel. Worked well for me!

[ghosttable]

I agree, export would be nice to have

[urmatej]

Hello,
just to bump this up.
Export would be really nice, of course including all info Task are defined by, but maybe it would be also nice to implement an Import.
BTW, Bravo for the app. Really useful piece of software.

[muety]

+1 for import and export via the web interface 🙂

[daudtivan]

Guys,
Went around the export limitation with a single command line in linux:
awk -F':' '$1~/^(SUMMARY)/{ printf "%s%s",$2,($1=="SUMMARY"? ORS:"\t") }' input-file.ics > output-file.csv

The output contains only the item name, but you can list dates and other stuff too.
Original post on stackoverflow https://stackoverflow.com/questions/48709853/convert-ics-into-table-awk

With that, I was able to obtain a plain csv and import that into a spreadsheet, which I used to prioritize my backlog using math (besides other nice tricks as well ;-)

Hope it helps.