Export tasks to CSV
Could you implement a quick, export all as raw data
ie. No need to go to an API, just Nice orthogonal table accessable using an URL.
That way it would be very easy to implement a spreadsheet that uses that URL in order to extract the information.
That makes it very easy to implement your own statistics.
It should show all tasks, completed or not completed, along with their tags etc.
Nick
ie. No need to go to an API, just Nice orthogonal table accessable using an URL.
That way it would be very easy to implement a spreadsheet that uses that URL in order to extract the information.
That makes it very easy to implement your own statistics.
It should show all tasks, completed or not completed, along with their tags etc.
Nick
emily (Remember The Milk) says:
Nick, thanks for your feedback -- not sure if you saw this already (or if it's helpful), but we have an iCalendar export available. We provide the iCalendar format as it's handled by most calendar software -- you might be able to use this export to get the data into other formats. Hope this helps!
emily (Remember The Milk) says:
Nick, this URL seems fine on our end -- as the list is private, it should prompt for your username/password if you aren't already logged into Remember The Milk.
smpandrews says:
Emily, I would like to support Nicks idea whilst the Ical format is great for importing to calendars it is not friendly if you wish to create your own reports using excel and/or MSaccess. This would greatly help me manage my team (who all use the iphone app) and brief my boss on completed tasks. The boss has a certain way they like things presented.
soxfree says:
Vote for import/export via Excel
zockette says:
Having a complete export with notes would be awesome :)
(closed account) says:
+1 for excel including notes
plockerman says:
export to csv please
dschur says:
+1 for export to csv files
sylviavas says:
prefer export to tab-delimited but some kind of easy export would be great. even just a copy/paste if it didn't pick up too much irrelevant stuff
linkz57 says:
This might be close: http://google-opensource.blogspot.com/2011/08/introducing-google-tasks-porter.html
I'm not suggesting leaving Remember The Milk for Google Tasks, but Google Tasks is easier to export from, advertising an export to CSV from this same tool.
So far I haven't gotten it to work, eleven snapshots and it's still failing on me. That said, the idea is promising: import from RTM and export to CSV. From a CSV, you could open that in Ms Office, Libre Office, Google Docs, etc and export to XLS, TSV, and go from there.
If you're feeling really clever you could take the source code from Tasks Porter, combine it with a Google Docs API for conversion and simplify the XLS export from RTM into a one-step effort. Take that one step further with Grease Monkey and now you have an "export to..." menu on the RTM page with options like CSV, ODS, XLS, etc.
That would require much more Python and Javascript than I have to offer, but if someone else could (perhaps the fine coders at RTM, like Bob T. Monkey) and I for one would appreciate it.
I'm not suggesting leaving Remember The Milk for Google Tasks, but Google Tasks is easier to export from, advertising an export to CSV from this same tool.
So far I haven't gotten it to work, eleven snapshots and it's still failing on me. That said, the idea is promising: import from RTM and export to CSV. From a CSV, you could open that in Ms Office, Libre Office, Google Docs, etc and export to XLS, TSV, and go from there.
If you're feeling really clever you could take the source code from Tasks Porter, combine it with a Google Docs API for conversion and simplify the XLS export from RTM into a one-step effort. Take that one step further with Grease Monkey and now you have an "export to..." menu on the RTM page with options like CSV, ODS, XLS, etc.
That would require much more Python and Javascript than I have to offer, but if someone else could (perhaps the fine coders at RTM, like Bob T. Monkey) and I for one would appreciate it.
allthatcaz says:
@linkz57, I'm not clear on how to use Google Tasks Porter to import tasks. It's asking for a file, but all I have is the RTM iCal address, which the file field won't accept. I've successfully linked RTM to my Google Calendar, but how would I create an importable file for Google Tasks Porter from my RTM iCal address?
willmarlow says:
This would be an awesome feature -- I'd love to be able to export the raw data to .csv.
markginter31 says:
Same here. Export to csv or tab delimited or even to Open/Libreoffice format in Calc
aka178 says:
The 1st thing to do with any new software/gadget is to investigate backup/recovery options. RTM looks poor. Please dont tell me about lossy iCal exports. It is a shame.
Please add XML/CSV/BIN/whatever export and import. So i would able to backup data, wipe my data and restore it back with all details in in 3 mouse clicks.
Please add XML/CSV/BIN/whatever export and import. So i would able to backup data, wipe my data and restore it back with all details in in 3 mouse clicks.
alejandropolit1370 says:
Please add XML or CSV or BIN or whatever export and import.
fcastell says:
+1 to have export to excel!
sjhanley says:
I vote for exporting tasks with notes within RTM in csv or excel format.
mebsan00 says:
see it
http://pipes.yahoo.com/pipes/pipe.info?_id=49c30ca389410df9ef49b008e0d65203
http://pipes.yahoo.com/pipes/pipe.info?_id=49c30ca389410df9ef49b008e0d65203
brennen.chua says:
+1 to CSV
limacat says:
CSV would be useful
sherry.agee says:
+1 to CSV
rchrin says:
CSV would be useful
sunjana1 says:
+1 on CSV
isaacab says:
+1
darrenmwalker says:
Excel export please! - Don't make me go looking for a To Do App that does.
jumibu says:
+1 on CSV
egatlin says:
why can't I export my data? all fields/contents to a delimited format? just weird that this isn't available
huffhomeservices says:
it's ridiculous. i do believe the task manager managers don't want us to be able to manage our task managers.
morrisont says:
+ 1 million for CSV export....
grahl says:
I patched rtm-cli to export my tasks to a csv file, see here for details.
stevep771 says:
I discovered a work-around for this if anyone is interested. Go to one of your lists or do an advanced search. At the right side of screen, in the box you have an option to print. This creates a printer friendly version of the page. Now right-click on the page and choose 'save.' In save dialog box, choose 'single page htm.' This creates an htm file that you can open in excel.
Once in Excel, i made a spreadsheet that you can paste your data into and it will parse the data so you can save it as csv. If anyone is interested, i can make the sheet available. I know it's not ideal. Is a multi-step process. But if you're desparate, it works.
Once in Excel, i made a spreadsheet that you can paste your data into and it will parse the data so you can save it as csv. If anyone is interested, i can make the sheet available. I know it's not ideal. Is a multi-step process. But if you're desparate, it works.
rothtimo says:
+1 for integration with excel
+1 for Excel. I use Smartsheet and BaseCamp, too and have a weekly recurring task in RTM to reminder me to do those download/backups/exports. Sadly, I can't do weekly backups from RTM. I want all Tasks and Notes, too, because I have lots of Notes saved that I need to be sure are backed up weekly. Please make this a priority. Thanks.
eagleofjade says:
Definitely thumbs up for CSV export, surprised this hasn't been done by now!
weiszguy says:
+1 for export!
If I could have a CSV/excel/tab-delimited, or something along those lines, that would making reporting so much easier.
If I could have a CSV/excel/tab-delimited, or something along those lines, that would making reporting so much easier.
rameshcpoy says:
It will be great if we get raw data including notes in CSV format.
francois_nguyen says:
+1 for export : it would be possible to do some data analysis
(closed account) says:
Let's see, it's been EIGHT YEARS since someone suggested this feature. Wonder why you won't implement it??
bzdevil says:
Sad such a BASIC feature doesn't exist.
(closed account) says:
+1 for CSV/Excel expor
julie.jacksonforsberg says:
+1 for CSV export. My boss also has a certain way she wants / needs to see information, and she's not open to new tools. I need a task management system that works for me!
tiebor says:
+1000
ashineko says:
+1 - All these great new features, and we still can't export to CSV.
cwb3106 says:
+1
carloscadu says:
+1 csv/excel export
(closed account) says:
I despair that these are ever read by RTM staff.
andrewturnbull says:
Another +1 for a simple csv/xml export option
delucals says:
Yes please consider export in csv format! Loading into a calendar doesn't help me when I manage my list by project, not day ;-( - Thanks for considering!
ciltis says:
+1 for CSV export of search results/lists/tasks+subtasks instead of the entire database.
rebecca.oday says:
+1 for excel or csv including notes, subtasks, priority and tags. I agree with everyone here, having an export that is easier to use than iCAL would be a really nice feature. Please note, I have never seen Remember The Milk go offline nor have I never been able to get my data. However, for analysis purposes or just plain piece of mind, having a more standard export option would be great.
(closed account) says:
rtm needs more methods to get the data out. sharing and connecting different services is the expected workflow nowadays
so +1 for csv export as this is a open and universal format
PS: the android app lacks content sharing too, there isnt even a button for copy to clipboard
so +1 for csv export as this is a open and universal format
PS: the android app lacks content sharing too, there isnt even a button for copy to clipboard
tm36 says:
Wished I'd checked on this before paying for pro, moved from todoist, like the RTM interface a lot more, but export should be a basic function.
(closed account) says:
yes, please
bonzofestoon says:
Bob,
This is a great idea requested a decade ago.
Stop monkeying around and get mooooving on this. You practically have it done with the export to ical and atom feeds; between the two I am sure you can figure it out.
This is a great idea requested a decade ago.
Stop monkeying around and get mooooving on this. You practically have it done with the export to ical and atom feeds; between the two I am sure you can figure it out.
djgoncalves says:
This is a basic but an essential feature. Thanks.
alessandro.puzielli says:
+1 for export in CSV. Thanks
satoshi.sakao says:
+1 for CSV output.
shivrajd says:
+1 for CSV output with notes for selected tasks.
catyr says:
Yes this is essential. I'd like to quickly clean up my tasks but don't want to have to look through everything. It would be great just to export stuff to CSV that I can go through at a later time and reenter anything that I want to do. Then I could just happily delete away and clean up my lists.
hguillemain says:
Same as the 75 smart people before me
kngrmd1 says:
Export tasks option needed please
kngrmd1 says:
option to export import tasks easily via csv or excel,with all info like notes, tags,notes, duedates, repeating scenario are essential please
may be smartsearch etc., does not have to be exported/imported.
may be smartsearch etc., does not have to be exported/imported.
kngrmd1 says:
Remember the milk is afraid that people will abandon RTM
RTM has excellent architechture in terms of Android app and chrome browser in my windows 10 laptop.
(i have not tried RTM in any ios devices, but im sure you have a great app there too)
Anyways RTM has immense facitlities and it has great snappy app.
When mass adding tasks , why should we go round about like emailing tasks , or using google sheets and zapier?
why cannot it be as simple as importing an excel sheet ?
RTM can provide a template excel sheet that we have to download, we should not really edit the header in that sheet.
we can populate the specific rows and columns and just import N number of tasks in one go
It is necessary please
RTM has excellent architechture in terms of Android app and chrome browser in my windows 10 laptop.
(i have not tried RTM in any ios devices, but im sure you have a great app there too)
Anyways RTM has immense facitlities and it has great snappy app.
When mass adding tasks , why should we go round about like emailing tasks , or using google sheets and zapier?
why cannot it be as simple as importing an excel sheet ?
RTM can provide a template excel sheet that we have to download, we should not really edit the header in that sheet.
we can populate the specific rows and columns and just import N number of tasks in one go
It is necessary please
kngrmd1 says:
Also exporting the tasks with the due date, repeat patters, tags, list it is in , start date, estimated time, notes , location name alone at least, should be made available.
we tap export and all tasks are exported to a nice excel sheet
how difficult is that?
RTM should not fear people will abandon them at this point in time.
You give what customers need, they will not leave you .
when there is a possiblity of exporting to excel sheet, there is peace of mind , if RTM shuts down or if there is an error in RTM, our tasks are safe.
Lets say i have a loving , upper middle class father.
My father has to make sure he insures his life in a good reliable life insurance company,
make Fixed deposits etc., etc.,
create safety nets for his own future and also for his dependents future , if he dies suddenly.
Not just that he has to make sure the information regarding all his insurances and fixed deposits are available to his dependents.
It does not mean father will die, but a safety net is there.
This is life.
Life has to continue, no matter what, is'nt it?
Likewise No one is expecting or wishing RTM will die or will have a glitch once in a while.
But if anything like that happens , RTM should care for us by giving option to export the tasks into nice excel sheet.
Thats all.
I can set up a task which repeats every sunday to export the tasks from RTM and keep the exported file safe , this way if something happens to RTM, i always have few days old data as such.
Show that RTM cares for its customers even if RTM dies down,
even if RTM has a glitch that could be once in 10 years.
{im telling about the scenario in india, where life insurance premiums are low , Bank interest rates for fixed deposits are high (banks pay interest for the money we save in india)}
we tap export and all tasks are exported to a nice excel sheet
how difficult is that?
RTM should not fear people will abandon them at this point in time.
You give what customers need, they will not leave you .
when there is a possiblity of exporting to excel sheet, there is peace of mind , if RTM shuts down or if there is an error in RTM, our tasks are safe.
Lets say i have a loving , upper middle class father.
My father has to make sure he insures his life in a good reliable life insurance company,
make Fixed deposits etc., etc.,
create safety nets for his own future and also for his dependents future , if he dies suddenly.
Not just that he has to make sure the information regarding all his insurances and fixed deposits are available to his dependents.
It does not mean father will die, but a safety net is there.
This is life.
Life has to continue, no matter what, is'nt it?
Likewise No one is expecting or wishing RTM will die or will have a glitch once in a while.
But if anything like that happens , RTM should care for us by giving option to export the tasks into nice excel sheet.
Thats all.
I can set up a task which repeats every sunday to export the tasks from RTM and keep the exported file safe , this way if something happens to RTM, i always have few days old data as such.
Show that RTM cares for its customers even if RTM dies down,
even if RTM has a glitch that could be once in 10 years.
{im telling about the scenario in india, where life insurance premiums are low , Bank interest rates for fixed deposits are high (banks pay interest for the money we save in india)}
kngrmd1 says:
I will set up task " backup RTM " that repeats every sunday.
I will backup RTM to nice excel sheet .
If RTM has a glitch or dies down for whatever reason,
then I always have few days old data that i can refer to or use it else where.
show that RTM cares its customers , no matter what
I will backup RTM to nice excel sheet .
If RTM has a glitch or dies down for whatever reason,
then I always have few days old data that i can refer to or use it else where.
show that RTM cares its customers , no matter what
bhugo says:
It is unfortunate that RTM doesn't seem to want to listen, I left Evernote for the inability to have multi-level pages, and it now seems I will be leaving RTM for no export ability. These are not outrageous requests or crazy demands...I cannot understand why they won't create this feature. After almost 5 years of RTM, Todoist it is then.
As of today (12 jan 2019), it looks like I can export in a JSON format or an iCalendar format.
JSON format export does seem to be what some other task management tools offer these days, but I, too, would like to also have CSV format as an option because that would allow me to manipulate data in Excel.
JSON format export does seem to be what some other task management tools offer these days, but I, too, would like to also have CSV format as an option because that would allow me to manipulate data in Excel.
lee_colmer says:
Excel / CSV please! Why haven't they listened and implemented it already, how hard can it be?!!
stevejlock says:
+100000000
thomas.decker says:
@lee_colmer: There are many thinks like kanban waiting or will never be there what I personally believe.
rjallison81 says:
Users have been requesting an export to Excel function for more than eight years and still nothing from the RTM team.
lalorm664 says:
+1 for excel or csv export, thanks
juanescofet says:
Simple answer. They dont want us to take our work flow out form them, because we may (probably) not come back
jhernelyn says:
scrolled through this hoping there was a solution in the end........
jhernelyn says:
Emily leave the company?
juancamilobarrero says:
This should be as simple as clicking on a button and choosing export to... CSV, TXT, XLS, CLIPBOARD.
There are workarounds to export lists, but this is a productivity tool. I shouldn´t have to waste time:
- SAVING AS...
- OPENING IN EXCEL
- COPYING
- PASTING...
I use a smartlist to control my follow ups with my team. Every time I want to follow up on stuff I have to go through this annoying process...
There are workarounds to export lists, but this is a productivity tool. I shouldn´t have to waste time:
- SAVING AS...
- OPENING IN EXCEL
- COPYING
- PASTING...
I use a smartlist to control my follow ups with my team. Every time I want to follow up on stuff I have to go through this annoying process...
I wrote a MilkScript script to export selected tasks as CSV.
The code is here, which you can copy-paste into a new MilkScript script and export tasks as CSV: https://gist.github.com/EvanHahn/cd5c705063b0300ffe6e8346f4e104a0
I consider this a prototype, and it may have bugs or missing features, but I hope it can be useful to others.
The code is here, which you can copy-paste into a new MilkScript script and export tasks as CSV: https://gist.github.com/EvanHahn/cd5c705063b0300ffe6e8346f4e104a0
I consider this a prototype, and it may have bugs or missing features, but I hope it can be useful to others.
- The link for iCalendar export doesn't mention exporting to iCalendar. Maybe it's there somewhere, but one has to explore every link there to figure that out.
- Exporting to CSV is just basic functionality. I don't understand why RTM doesn't provide it.
- It's great that a user has created a script to do this, but how do I know it's not malicious in some way? I will have to learn Milkscript to feel secure using it and understand how to use it. This functionality should be provided by RTM.
- Exporting to CSV is just basic functionality. I don't understand why RTM doesn't provide it.
- It's great that a user has created a script to do this, but how do I know it's not malicious in some way? I will have to learn Milkscript to feel secure using it and understand how to use it. This functionality should be provided by RTM.
I wrote a more detailed post about how to use my unofficial CSV exporter. Hope this helps!
Log in
to post a reply.