よくある質問に対する回答を見つけて、自分でまたはチームで Todoist を使う方法を学びましょう。. CSV のフォーマットを整えて Todoist にインポートする方法. Automate CSV file parsing using Integromat and raise your data management game. Try one of our pre-made scenarios, or design your own and start automating today. Then, go to file Open and export Import/Export Export to a file Comma Separated Values select your desired folder/list save the file. Then you can go in and open that file, and add your tasks according to the template that was downloaded. Remember to save this as a CSV!
After 8 years of RTM pro membership, I decided to move on to Todoist. I gave up after my first attempt since Todoist could not process the extract file from RTM. However, I decided to dig a bit deeper and came up with the following approach.Disclaimer: this is was a personal project which I am documenting here for other people's benefit. This is strictly a 'where is, as is' endeavour. However, while you could fail - you cannot really break anything either. So - good luck!
Getting an extract file out of RTM (Remember the milk)
The first step is getting an *.ics file out of RTM. *.ics is a diary format, but it can be reconverted.Delete your completed tasks from RTM
When you export, ALL your RTM tasks will get into the *.ics file. If you have 2,000 completed tasks in RTM, they will end up there as well. Given that you most likely only want the active tasks, select the completed ones and delete them first. That will make your migration job a lot easier.
Go to the RTM search an search for 'status:completed':
Select all your tasks, click the 'more functions' thingy '...' and select delete tasks:
Finally, it will ask you if you want 'delete repeating tasks' or not.
I guess it depends how certain you are that you want to migrate away from RTM:
- If you are 100% certain it does not matter, you could choose 'stop repeating'.
- If you are less than 100% sure, better stick with 'continue repeating' - better save than sorry!
Extract your active tasks from RTM
Now is when the fun begins!On the top right corner on the RTM screen, click the 'tools' button and select 'account settings'.
Click 'export' on the left hand column and click 'download export'.
Finally, save it where-ever you want:
You will get a cryptically named *.ICS file (red rectangle). If you open it you get tagged file in some proprietary format (blue rectangle):
Convert your *.ics file into a CSV (Comma separated value) file
Now, I am not vouching for any online conversion services. Google 'ICS file conversion' and you get plenty of choices. For no particular reason, I selected the red bordered one - which does not mean that I recommend it as save. Use the usual cautions - if you have sensible private information in your tasks, remove them before proceeding.The conversion itself is pretty straight-forward: select the *.ics file you saved from RTM, choose your date format (I am going for 'civilised part of the world') and click the 'Convert to CSV' button:
Todoist Csv Download
After you downloaded the converted file, I would also use the 'Deleted file from our server' option. (Please note that I am not saying that this option actually does anything in the background).The result is, unsurprisingly, a CSV (aka 'comma separated value') file:
You can open it in a spreadsheet (MS Excel for most people, LibreOffice Calc for the Linux people like myself) and delete any columns you do not need or want.
Personally, I am only keeping the 'Title' column at the beginning document and manually re-doing the dates, frequencies, tags, etc. on the tasks. However, feel free to play around with the columns and see how much information you can get across (more on that later).
For the demonstration purposes of this blog, I only kept the 'Title' column and 5 non-descriptive tasks:
Load your CSV file into Todoist
Now the last bit is REALLY easy, but you can play around with it and come up with a more advanced approach. Basically, Todoist allows you import CSV files which they call 'templates'.
Let's do the easy approach first.
For the purposes of this blog, I simply created a new project called 'RTM import demonstration'. Please have a look at the tool icon in top right corner ... you will need it in a second:
Let's do the easy approach first.
For the purposes of this blog, I simply created a new project called 'RTM import demonstration'. Please have a look at the tool icon in top right corner ... you will need it in a second:
Todoist Csv
Click the tool icon and select 'Input from template' (this is what Todoist calls CSV files) ;-)
This dialogue will open and you can select your updated/culled CSV file:
This dialogue will open and you can select your updated/culled CSV file:
... and, voilà, as if by magic ... my 5 tasks in the CSV file have been imported:
That's it, you are finished importing your old RTM tasks. I had about 250 of them and preferred to manually cull, date, tag, assign repetitions, etc. to them. The big advantage is that this will show you how Todoist works (which is different from RTM).
Now, for extra points only (remember, you are finished already) ... let's produce a Todoist template and save it as a CSV file:
The result is:
- the first line gives you the header and the sequence of the data elements
- you can clearly see the 5 tasks that were in the Todoist project
- for some reason, Todoist is also putting the ',' sequence in which is causing empty lines. You can safely remove them (use 'change all') - have done this a few times without encountering any issues.
- Knowing now what input structure structure Todoist expects in its 'template', you can now go back to your ICS to CSV converted file, load it into a spreadsheet and play around with copying/pasting it into this order.
- When re-importing, you will most likely get more information across. That could be useful if you are migrating thousands of tasks.
Todoist Csv Editor
Todoist Csv File
Some honourable mentionings: this blog entry was brought to you using
- Linux Mint Debian Edition 2 (LMDE2),
- LibreOffice Calc,
- GNU image manipulation program (GIMP) and
- Pinta
... and, voilà, as if by magic ... my 5 tasks in the CSV file have been imported:
That's it, you are finished importing your old RTM tasks. I had about 250 of them and preferred to manually cull, date, tag, assign repetitions, etc. to them. The big advantage is that this will show you how Todoist works (which is different from RTM).
Now, for extra points only (remember, you are finished already) ... let's produce a Todoist template and save it as a CSV file:
The result is:
- the first line gives you the header and the sequence of the data elements
- you can clearly see the 5 tasks that were in the Todoist project
- for some reason, Todoist is also putting the ',' sequence in which is causing empty lines. You can safely remove them (use 'change all') - have done this a few times without encountering any issues.
- Knowing now what input structure structure Todoist expects in its 'template', you can now go back to your ICS to CSV converted file, load it into a spreadsheet and play around with copying/pasting it into this order.
- When re-importing, you will most likely get more information across. That could be useful if you are migrating thousands of tasks.
Todoist Csv Editor
Todoist Csv File
Some honourable mentionings: this blog entry was brought to you using
- Linux Mint Debian Edition 2 (LMDE2),
- LibreOffice Calc,
- GNU image manipulation program (GIMP) and
- Pinta
If you are one of those hard-done by Microsoft users - it does not have to be that way! Switch to Linux!
Good luck and enjoy!
Good luck and enjoy!