Moving from TickTick
TickTick's backup is already a CSV. Rename a few columns, convert the priority numbers, import with a preview. Lists, tags, dates, repeat rules and completed tasks come across; habits and the Pomodoro log do not.
TickTick's export checked on ; the import path is that of OpenTodo v0.6.0
What comes across
- Tasks, with their content as descriptions
- Lists, as projects; folders as parent projects if you want them
- Kanban columns, as sections
- Tags, as labels
- Due dates and times
- Repeat rules written as RRULE, which OpenTodo reads when it can express them
- Completed tasks, once the status column is converted
- Subtasks, through the parent id column
What does not
- Habits and their streaks, and the Pomodoro and focus records
- Start dates (not in this release)
- Reminders, unless the preview can read TickTick's spelling; set them again if not
- Attachments and comments
- Calendar subscriptions and shared lists (share again in OpenTodo)
Before you start
At the time of checking, TickTick’s export is a backup made from the web app (Settings → Account → Generate Backup), which downloads a CSV file of every list. The file starts with a few lines of notes above the real header, and its columns include Folder Name, List Name, Title, Content, Tags, Due Date, Reminder, Repeat, Priority, Status, Completed Time, Column Name, taskId and parentId. Trust your own file over this page.
OpenTodo reads a CSV with a header row and a title column; spaces in header names count as underscores, so Due Date is already due_date. The columns it understands are in the import reference.
Export from TickTick
- In the TickTick web app, open Settings → Account and select Generate Backup. Download the CSV. Import formats
- Open it in a spreadsheet and delete the note lines above the header row, so the header is the first line. Import formats
Tidy the file
- Rename
Contenttodescription. OpenTodo would otherwise readcontentas a second title column. CSV columns - Rename
List NametoprojectandColumn Nametosection. Lists become projects and Kanban columns become sections. Sections - Rename
taskIdtoidandparentIdtoparent. Subtasks then find their parents. Mapping rules - Convert
Priority. TickTick writes 5 (high), 3 (medium), 1 (low) and 0 (none); OpenTodo wants 1 to 4 with 1 the highest. Replace 5 with 1, 3 with 2, 1 with 3 and 0 with 4 (or with the wordshigh,medium,low,none). CSV columns - Convert
Status. TickTick marks completed tasks with 2; rename the column tocompletedand replace 2 withyes, everything else with nothing. Completion times come fromCompleted Timeif you rename itcompleted_at. CSV columns - Leave
Tags,Due DateandRepeatas they are. Tags become labels,Due Dateis read as a date-time, and RRULE repeat rules are read when the rule can be expressed; the preview names any it cannot. Recurrence - Reminders: OpenTodo reads durations such as
-PT15Mand1 day; if the preview does not accept TickTick’s spelling, delete the column and set reminders again in the app. Reminders
Import into OpenTodo
- Open Settings → Data → Import data… and choose the file. Import from another app
- In the preview, check the time zone (dates with a zone are converted to it), then read the row list; problems come first with the row number and the reason. Nothing is written yet. Import from another app
- Select Import. One file brings all your lists; the tasks reach every device on its next sync. An import can be undone. Undo an import
Your first week
- Pomodoro habits: give tasks an estimate (
+25min quick add, or e) and plan them on the Day calendar; the header shows whether the day fits. Plan your day Estimate how long a task takes - Smart lists become saved views:
due <= 7 days & p1,@errand & !completed. Save a filter as a view Save your own views - Turn on notifications on each device so reminders arrive while the app is closed. Get reminders on your phone Get reminders when the app is closed
- Share the lists you shared before, with a role per person. Share a project Share a project
TickTick words, OpenTodo words
| In TickTick | In OpenTodo | Note |
|---|---|---|
| Task | Task | |
| List | Project | |
| Folder | Parent project | |
| Section / Kanban column | Section | |
| Tag | Label | |
| Priority High, Medium, Low, None | Priority P1, P2, P3, P4 | |
| Repeat | Repeat rule | |
| Reminder | Reminder | |
| Pomodoro / estimated duration | Estimate | Estimates feed the Day and Week calendar. |
| Habit | No equivalent | Habits are on the roadmap, not in this release. |
| Filter / Smart list | Saved view |
Documentation this page relies on
Bring your tasks over at your own pace.
Import into the demo first if you like: the sandbox is private and deleted after two hours. Then do it for real on your server.