+ Add Question

Import/Export Tasks as CSV?

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.


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,

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.

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.

Replied on Feb 08, 2014 - 12:57 UTC

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

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)

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.

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.

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


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


Chuck Coughlin
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. -_-;

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.

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 :

This is the export - absolutely JIBRISH

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?

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!

Replied on May 28, 2014 - 00:02 UTC

Agreed, this would be a very useful feature.

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

This is definitely a very desired feature.

Trish Putnam
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!

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.

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.

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.

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
Replied on Aug 07, 2014 - 18:28 UTC

Must have, will not renew and continue to Gqueues!

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

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

Trish Putnam
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.

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)
outputFileName = ARGV[0]

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']

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

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

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]
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"

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

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! :

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!

Lynne Wilkins
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.

Andrius Kasparavičius
Replied on Oct 26, 2014 - 12:49 UTC

Locking in customers data - is lazy way(politely said) to retain them.

Andrius Kasparavičius
Replied on Oct 26, 2014 - 12:53 UTC

Sorry must have quoted some other tool "Toodledo will never lock you in. Export all your data at any time." That's the spirit. =-)

RTCreager  premium
Replied on Oct 26, 2014 - 20:44 UTC

and the source for the quote? http://www.toodledo.com/

RTCreager  premium
Replied on Oct 26, 2014 - 20:49 UTC

as noted by others, without the capability to save my information, I will not be renewing my subscription, and will not be recommending this product to any one. So far, staff responses to adding the export capability have been useless, and a true indication that the owner of the product does not care or doe not recognized the value of being able to export and preserve valuable information captured via the product...quite a remarkable attitude. yup, probably more disappointed with self for not doing a better job of vetting the product before I started using it and paying for the service, which is incomplete

Replied on Oct 27, 2014 - 14:18 UTC

Agreed, this would be a very useful feature

Brian Clarke  premium
Replied on Oct 29, 2014 - 15:18 UTC

Am a Premium user surprised to see no simple export to CSV functionality will try and find something similar with that functionality

SC  premium
Replied on Nov 03, 2014 - 02:13 UTC

Wow! I too can't believe that Todoist does not support a simple text based import/export feature. This is an ABSOLUTE MUST for any tools I use to manage notes/tasklists etc. I have been trying out the Premium feature and was planning on paying for the full year soon, but based on this there is absolutely no way I am going to support Todoist by paying for Premium. From the staff replies here it is pretty obvious that Todoist does not care about this request from end users. I am a software developer myself and I can pretty much guarantee that implementing this feature is a piece of cake if they really wanted to!

Replied on Nov 14, 2014 - 14:59 UTC

Has this really gained no traction in the Todoist offices? Far be it from me to dictate company pipeline policy, but come on, still no provision for export to CSV/TAB?

Kristinn Andersen  premium
Replied on Nov 16, 2014 - 15:42 UTC

An export option is truly missed. Need this for occasional organizing my things in Excel, and even just printing on a piece of paper. A simple thing to fix and make lots of people happy - please!

Rachael Ball
Replied on Dec 05, 2014 - 13:01 UTC

I would like to add my voice to the call for an import and export feature. I am just looking at using Todoist and would pay to be a Premium user, but I am having second thoughts now that I find I can't import from Wunderlist. There are so many To Do list apps out there and you need to try things out with your own content before you know whether it works for you or not. Having to migrate manually becomes seriously offputting. Why you would not just add this feature I don't understand.

Darek Kay  premium
Replied on Dec 05, 2014 - 14:14 UTC

Backup is already implemented - it even does daily backups automatically (Settings - Backup tab).

Joey Orlando  premium
Replied on Dec 06, 2014 - 15:17 UTC

@Derek Kay,

The backup is terrible! It is a consistent pattern, so it's workable, but it is not a universally known encoding of the date. Its neither a CSV nor JSON, as this question is about.

Furthermore, I would like to be able to backup ALL of my tasks, even the very first one I did! All of my archived, those don't show up in the backup logs, and obviously I can't retrieve a backup from that long ago, at least I haven't tried.

Joey Orlando  premium
Replied on Dec 06, 2014 - 15:17 UTC

universally known encoding of the data *

Darek Kay  premium
Replied on Dec 09, 2014 - 14:12 UTC

I see your point. I guess their argument is simplicity. It's meant as a backup, so you can import tasks if something goes wrong. If you want to somehow process the data, then you can use their API. I haven't tried it, yet, but I bet the output format is JSON.

Darek Kay  premium
Replied on Dec 14, 2014 - 21:01 UTC

I wrote a little tool to export either your tasks or all your data (including user settings) as JSON:

You can convert the data to CSV using any online tool (like http://www.convertcsv.com/json-to-csv.htm). Make sure to select the "tasks" option for better CSV results.

The code is open source, so feel free to adjust it (see GitHub link).

Marco Ramirez
Replied on Jan 21, 2015 - 21:50 UTC

i cant believe we still dont have an export to csv!!!!

Replied on Jan 21, 2015 - 22:07 UTC


Miha  premium
Replied on Jan 25, 2015 - 01:32 UTC


Thomas  premium
Replied on Jan 25, 2015 - 13:43 UTC

Hi Darek, your tool does not work for me. Resulting CSV file is gibberish.

Darek Kay  premium
Replied on Jan 26, 2015 - 15:02 UTC


As I wrote, my tool exports all tasks in the JSON format. You need to use a converter to get a CSV. There are tons of free converters on the internet: http://www.convertcsv.com/json-to-csv.htm

If it's still gibberish, you can write me an email and I'll see what I can do: darekkay@eclectide.com

Brian Clarke  premium
Replied on Jan 26, 2015 - 15:05 UTC

ps love the app

Replied on Jan 26, 2015 - 18:43 UTC

I am using this app for last 1 month.I want more filters in free version itself and export to csv is most essential future needed,but it is missing here.

Darek Kay  premium
Replied on Jan 26, 2015 - 22:24 UTC

I've just updated my tool. Now you can export your tasks as CSV without any external converter:

Алмат  premium
Replied on Feb 04, 2015 - 06:40 UTC

Добрый день, пожалуйста, добавьте функцию выгрузки списка в CSV файл, очень нужная функция!

Thomas  premium
Replied on Feb 21, 2015 - 15:41 UTC

Darek, thanks, it does work.
It has a small problem with parsing quote marks like this "

Thomas  premium
Replied on Feb 21, 2015 - 15:43 UTC

Darek, do you think you could also do something to pull the data of completed tasks to CSV?
Thanks so much by the way for doing the work that the todoist team should be doing.

Milo Spencer-Harper
Replied on Mar 19, 2015 - 03:26 UTC

Magi Metrics has built an Excel and Google Sheets plugin which allows you to pull your todoist tasks into a CSV file.


Disclosure: I'm the founder of Magi Metrics

Steven Zook  premium
Replied on Mar 19, 2015 - 13:14 UTC

You can create a txt file to import to a Project. If you create a Project call Temp and then import the txt file it will create the task.

Notepad test.txt file.
...New Task
......New Sub Task 1
......New Sub Task 2
......New Sub Task 3
.........New Sub / Sub Task 1
............New Sub / Sub / Sub Task 1
............New Sub / Sub / Sub Task 2

Chuck Coughlin
Replied on Mar 19, 2015 - 13:30 UTC

I am glad this came into play. Not sure why the users are having to program this? I just have the feeling the programmers are really not dedicated to this program.
With that said, it is unfortunately, I will not renewal my two subscription next month and moved onto Asana for my ToDo lists.

Darek Kay  premium
Replied on Apr 04, 2015 - 20:11 UTC

I've finally got to fix your issue. Please let me know, if it still occurs.

I'm not planning to add completed tasks, but other developers are free to contribute: https://github.com/darekkay/todoist-export