+ Add Question

Import/Export Tasks as CSV?

MD

I want to make sweeping adjustments to all my tasks at times. Is there a way to export my tasks to edit in Excel or some spreadsheet program to do this? Let's say I want to make a sweeping change to my due dates or I want to add the same note to a bunch of tasks, I think an excel spreadsheet would be a better use of my time than editing dozens of tasks one by one. I think the formula feature would be useful as well for editing large groups of tasks.

Thanks!

All responses

David Trey staff
Replied on Feb 16, 2013 - 19:44 UTC

Hello Michael,

Unfortunately, it's not possible to export your task list into an CVS document. You can export them to plain text files if you want to duplicate some of them as shown in this video: http://www.youtube.com/watch?v=_Rl_CLGY_3o

But if you want to change the due dates of multiple tasks, please hold the CTRL key while clicking on them and then use "change date" from the menu which will appear at the top.


Best regards,
David

RJ
roger jud
Replied on Jan 11, 2014 - 09:53 UTC

export function is a must for a lot of users. as long there is no solution with a standard (like csv), I won't switch to todois.

RJ
roger jud
Replied on Jan 11, 2014 - 09:54 UTC

to clarify: import and export of projects and tasks is an absolutely must and can't be so complicated.

S
Scott
Replied on Feb 08, 2014 - 12:57 UTC

Yes, this is a terrible shortcoming of the current system.

GS
Gilad Shir premium
Replied on Mar 03, 2014 - 19:10 UTC

also, without it, it makes transitions from other organizers (gqueues for example) very difficult (instead of just importing the csv file i would have to manually copy all the projects into todoist)

PN
Paul Nadon premium
Replied on Mar 13, 2014 - 18:49 UTC

I won't be renewing my Premium solely based on the fact that I cannot export.

SV
Steven Veverka premium
Replied on Mar 25, 2014 - 18:43 UTC

I may be looking for refund. Didn't realize that plain text dump was a premium feature.

C
Christopher
Replied on May 07, 2014 - 16:43 UTC

Are there any plans to offer CSV export (or similar)?

Brendon Wadey staff
Replied on May 07, 2014 - 16:46 UTC

Hi,

Not at this time but it's possible in future updates.

Regards,
Brendon.

Chuck Coughlin premium
Replied on May 07, 2014 - 16:54 UTC

Ya, I have to agree. The export is a bit of an issue. Not sure if I will renewal premium in Janurary. -_-;

C
Christopher
Replied on May 07, 2014 - 16:58 UTC

Thanks for the quick reply Brendon. I'm currently a light-to-moderate user of your free account, but an export (primarily for my own backup purposes) would certainly enhance your product.

G
Girlande premium
Replied on May 07, 2014 - 18:31 UTC

Got to join all the previous - it is a MUST. And very simple to do - you already made a text file (without any rules - so we can't even use it on excel), and basically the text file is a big Jibrish and non readable . - not sure what is the point of this file.
I just register to the premium but not sure will continue without this option.
I am sorry todoist - this doesn't consider as an EXPORT :
[[outlook=id3=MDAwMDAwMDBDMkRGNkM3MkMzNjNEMTREODY5MjFGQkIxQjcyRTA2MDA3MDA3NTc0NkQ3Q0FCOEZDRDQ1QjVENDc0NDBENzVCMEE5NDAwMDAwMDEyRkNEQTAwMDBFODExNkI5MzRGNTJEODQ5QUQ5MzU5MDA5RDM0QUMzQzAwMDA0RTdEQkVCNTAwMDA=, Shadowland Ent - 10748 ]] [[date Apr 30]]

This is the export - absolutely JIBRISH

MA
Matt Allington premium
Replied on May 08, 2014 - 22:39 UTC

Hey, I have followed the instructions in this video about import/export templates, but there is no such "import/export" settings on the gear icon on my version (windows and also online version). Where can I find this feature?

MA
Matt Allington premium
Replied on May 08, 2014 - 23:23 UTC

OK, found it under the task actions - which is not the gear icon. You need to update your video since it seems you have changed the design of the solution

Lleslle Schroeder premium
Replied on May 16, 2014 - 18:59 UTC

Hi Todoist Team,
Just wanted to provide my feedback, request, and desire for the ability to export to CSV as well. I have a process by which I manipulate my daily to-dos in Excel so being able to export easily would save me a lot of time. Currently I am copying and pasting the tasks one at a time out of Todoist into Excel, however, simply having the ability to export to a CSV would make my workflow much more efficient.

Many thanks and I hope this feature can get on the feature release roadmap sooner rather than later. Cheers!

D
Debbie premium
Replied on May 28, 2014 - 00:02 UTC

Agreed, this would be a very useful feature.

VR
Vladislav Rabinovich premium
Replied on Jul 02, 2014 - 03:24 UTC

This is definitely a very desired feature.

TP
Trish Putnam premium
Replied on Jul 02, 2014 - 17:08 UTC

Absolutely agree that a proper export to CSV is a critical function of an application that is intended for serious use. Right now I've had to keep my use in the light end of the range because I can't rapidly manipulate all task data or build reports.

Ideally you could export, do data manipulation, import where the import would overwrite existing items (they do have unique ids, right?) and add anything that didn't have a unique id in that field, but heck, I'd just take the ability to bulk add and then manually delete anything existing!

T
Tom premium
Replied on Jul 09, 2014 - 16:39 UTC

This is 'Must Have' option.

Yuji Tanaka premium
Replied on Jul 22, 2014 - 02:37 UTC

Agree that is 'Must Have' option.

DN
Daniel Naber
Replied on Aug 06, 2014 - 06:35 UTC

Just started using todoist - not having proper import/export is just not acceptable. I will not upgrade to a premium account and I'll look for a different service instead.

JC
John Coumerilh
Replied on Aug 06, 2014 - 14:52 UTC

That settles it for me. Wow, this was looking good. Just wasted an hour testing it, but no import?!! Sheesh! You gotta be kidding me.

MA
Matt Allington premium
Replied on Aug 06, 2014 - 21:22 UTC

This was also an issue for me originally. But there are few comments I want to make.

1. I thought the rest of the product looked pretty good, so I just sucked it up and manually moved over my existing tasks. OK, it took me 45 mins, but if you have just wasted an hour on testing, then 45 mins doesn't seem extreme.

2. There was not much else out there that does all I wanted (for me anyway)

3. Now the 'link to email' is working (once again for me anyway - it doesn't work for some), I am now very happy.

4. But what really surprises me is that ToDoist doesn't just fix this import thing. Man, importing from CSV is not exactly difficult. Just do it I say.

Paulo De Souza premium
Replied on Aug 07, 2014 - 18:28 UTC

Must have, will not renew and continue to Gqueues!

Jim Fisher premium
Replied on Aug 08, 2014 - 14:57 UTC

Exporting to CSV or comma-delimited txt file would be nice!

TP
Trish Putnam premium
Replied on Aug 08, 2014 - 16:27 UTC

As I've said, I truly want a usable generic export/import, such as CSV. However, those who are saying they will go to gqueues should know that it is a good product, but its export and import via CSV isn't really all that useful in terms of being able to edit the CSV and re import it. What GQueues DOES have is a quick add functionality that would allow you to build a pretty simple text file and copy/paste it into the quick add box to add a bunch of items at once, already nested. It doesn't solve all the problems - I don't think you can use quick add to update existing items, for example.

C
colin.canfield premium
Replied on Aug 13, 2014 - 22:55 UTC

I was going to quit Todoist for not having an export (do not want my data lost) but I wrote this exporter instead. I still think they should offer it as an option, it is really fairly simple and is obviously a strategic choice. I did not try to export notes, only put a flag in the CSV column if they are there to let you know to go to get them separately.

For this code to work just put your API token in the script, this is on your ToDoist settings / Account page.

Run it like this ruby export_tasks.rb outfile.csv


require 'rubygems'
require 'json'
require 'rest_client'
require 'pp'
require 'csv'

@todoist_url = "https://www.todoist.com/TodoistSync/v5.3/get"
@api_token = "YOUR TOKEN HERE"

projects = Hash.new
labelList = Hash.new
noteList = Hash.new

if ARGV.length != 1
puts "Please pass in the file name to write"
exit (1)
else
outputFileName = ARGV[0]
end

RestClient.post( @todoist_url+"?seq_no=0",:api_token => @api_token) { |response, request, result, &block|
case response.code
when 200

task_details = JSON.parse response
# pp task_details

task_details['Projects'].each do |prj|
projects [prj['id']] = prj['name']
end

task_details['Labels'].each do |lbl|
labelList [lbl['id']] = lbl['name']
end

task_details['Notes'].each do |note|
noteList [note['item_id']] = 'Y'
end

puts('Writing to file ' << outputFileName)
CSV.open(outputFileName,'w') do |csv|

csv << [ "id","content","due_date_utc","date_string","priority","checked","indent","project","labels","has note","deleted" ]
task_details["Items"].each do |tsk|

labelString = ''
tsk["labels"].each do |label|
if labelString != '' then labelString << ',' end
labelString << labelList[label]
end
if noteList[tsk["id"]] == 'Y' then hasNote = 'Y' else hasNote = 'N' end

project = tsk["project_id"]
csv << [ tsk["id"],tsk["content"],tsk["due_date_utc"],tsk["date_string"],tsk["priority"],tsk["checked"],tsk["indent"],projects[project],labelString,hasNote,tsk["deleted"] ]

print "Task:", tsk["id"],tsk["content"],tsk["due_date_utc"],tsk["date_string"],tsk["priority"],tsk["checked"],tsk["indent"],projects[project],labelString,tsk["deleted"],"\n"
end
end

when 423
raise "Failed"
when 301, 302, 307
response.follow_redirection(request, result, &block)
else
response.return!(request, result, &block)
end
}




JO
Joey Orlando premium
Replied on Aug 20, 2014 - 21:59 UTC

I just wanted to chime in. I can do an iCal -> JSON (or CSV, for that matter) conversion through a quick PHP script, but even the iCal feeds DO NOT HAVE ALL TODOIST Events! Just a handful of them, i am assuming the close-upcoming ones.

If I can't a steady JSON or CSV export in ToDoIst, I may not keep my premium. There isn't that much use in the premium, I just like that i can (seemingly) archive my projects forever.

I love ToDoIst, but I hate the fact that I cannot export to JSON/CSV! I am a web developer, I know how the relational databases that ToDoIst uses works, I can guarantee you that the ToDoist developers pulled more hair over iCal exports than they ever would for JSON/CSV exports! Its freaking easy! Just give us a damn export button! :

R
RTCreager premium
Replied on Oct 01, 2014 - 15:45 UTC

As well as others have noted, the export/import are key functions that are needed much sooner than later. It seems I may have prematurely and foolishly transitioned from my previous task manager, which has the desired export/import capabilities.

Please, not only put this request on your list, but give it a high priority, and with an expected date of implementation, for both tasks and related notes. Possible options are two csv files, one for tasks and the other for notes, or even an xml document consisting of tasks and notes.

thank you!

LW
Lynne Wilkins premium
Replied on Oct 03, 2014 - 11:29 UTC

Not long user but can't believe you haven't sorted this yet - it would be SO useful. I started using todoist because of the integration with Outlook, which I've since discovered is a bit pants - doesn't work the same way that Evernote as made beautifully easy. I may go back to Nozbe if I find their system does export. If Wunderlist ever have an Outlook integration I might go over to that to or try Evernote again for tasks - I do like the simplicity of todoist but there are certain things that are mentioned time and time over that you've not addressed.

I would love a way of exporting so I can mindmap my tasks and see the 'big' picture - come on guys. This must be do-able in a user friendly way.