How to format your CSV file so you can import it into Todoist

Available for:
Free
Premium
Business

Sometimes, you might be keeping track of tasks in another program or spreadsheet, but then you want to import them into Todoist. No problem — simply export your tasks from the other program or spreadsheet into a CSV file and then import them into Todoist.

When importing tasks using a CSV file you must stick to a specific format that Todoist can recognize. Download this template and modify it to ensure that you don’t encounter any issues when importing your tasks.

When reviewing your CSV file, ensure that each line follows the rules below:



Column

Content

Description

TYPE

task or note

Use task to add a task.

Use note if you’re adding a comment to the task in the row above.

CONTENT

name of the task or content of your note

Type the name of the task if you’re adding a task.

Type the content of your note if you’re adding a comment.

When creating a task, you can add labels by typing the @labelname as an addition to the name of the task.

PRIORITY

1, 2, 3, or 4

Type 1 to add p1 to the task (highest priority).

Type 2 to add p2 to the task.

Type 3 to add p3 to the task.

Type 4 to add p4 to the task (lowest priority).

Leaving this cell empty will automatically add p1 to your task.

INDENT

1, 2, 3, 4, or 5

Use 1 and the task will not be indented (meaning the task is a parent task).

Use 2 to indent the task to be a sub-task.

Use 3 to indent the task to be a sub-sub-task.

And so on.

Leaving this cell empty will set the task to not be indented.

AUTHOR

username (ID)

Add the username + user ID in brackets of the person that created the task.

For example: Evan (14781400).

Leaving this cell empty will automatically add your name and ID.

RESPONSIBLE

username (ID)

Add the username + user ID in brackets of the person that you’d like to assign this task to.

For example: Evan (14781400).

Leaving this cell empty will not add an assignee to the task.

DATE

due date and time or recurring due date and time

Add a due date and time if you want to schedule the task. You can also set a recurring due date.

If you leave this cell empty, no due date will be assigned to the task.

DATE_LANG

Language code

Add the language code for the set due date (if any). These are the official Todoist language codes:

da for Danish.

de for German.

en for English.

es for Spanish.

fi for Finnish.

fr for French.

it for Italian.

ja for Japanese.

ko for Korean.

nb for Norwegian.

nl for Dutch.

pl for Polish.

pt_BR for Brazilian Portuguese.

ru for Russian.

sv for Swedish.

zh_CN for Simplified Chinese.

Leaving this cell empty will automatically set the date language to English.

TIMEZONE

Time zone

Add the time zone that’s set for your Todoist account. (You can find your time zone under Settings > General.)

For example: US/Eastern

Leaving this cell empty will have Todoist automatically detect your time zone.





FAQs

Q: If I want to assign tasks to someone in my CSV file, how do I find their username and user ID?

A: You can get this information by exporting a shared Todoist project that the user is currently a part of:

  1. Find the shared Todoist project that the user has joined.
  2. Export the project as a template and select Export as file.
  3. Open the CSV file and find the username and user ID in the RESPONSIBLE cell in the row of the assigned task.

Q: Why are some of my tasks missing when using the import?

A: Make sure you double check that every cell has the correct content — if a mistake was made in a cell, Todoist will ignore the row and move onto the next one.

Q: Can I undo an import?

A: It’s not possible to undo an import, however, you can multi-select and delete any tasks that were imported by mistake.