+ 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

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

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

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

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

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

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

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

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

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

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

Hi,

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

Regards,
Brendon.

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

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

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

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

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

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

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

Agreed, this would be a very useful feature.

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

This is definitely a very desired feature.

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

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

This is 'Must Have' option.

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

Agree that is 'Must Have' option.

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

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

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

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

Must have, will not renew and continue to Gqueues!

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

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

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

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

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

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

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!