Loading the new Help Center

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

Available for:

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, section, or note (these are case-sensitive and should be written in lowercase) Use task to add a task. Use section to add a section. Use note if you’re adding a comment to the task in the row above.

name of the task, name of the section, or content of the note

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

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

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

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


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 the task.


1, 2, 3 or 4

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.


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.


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 to set the 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.

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.


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

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. At the top right, click the web_three-dots.svg three dots icon.
  3. Select Export as a template.
  4. Select Export as file.
  5. Open the CSV file and find the username and user ID in the RESPONSIBLE cell in the row of the assigned task.

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

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.

Please note that the content (such as task, section and note) written in the TYPE column are case-sensitive and should be written in all lowercase.

Can I undo an import?

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

When I open the template with Excel, all the text is merged together in column A. How do I fix this?

You can fix this by following these steps:

  1. At the top of Excel, click the Data tab.
  2. Click on Text to Columns.
  3. Select Delimited and click Next.
  4. Check the Comma box and uncheck all other boxes.
  5. Click on Finish.

My project is in board view and I want to export it as a CSV file. If I later import it again, will it retain board view?

Yes, it will! Whether you export a project as a CSV file in list view or in board view, it'll retain that view once imported.