| A | B | C | |
|---|---|---|---|
1 | |||
2 | |||
3 | |||
4 | Auto-generated Gantt chart view from Todoist project csv export | ||
5 | |||
6 | Created by Leighton Price | ||
7 | |||
8 | |||
9 | |||
10 | Last updated: 29 April 2025 | ||
11 | |||
12 | Objective | ||
13 | |||
14 | This Google Sheet is designed for you to be able to export a project from Todoist as a csv file and quickly view it in a Gantt chart format upon importing it here. | ||
15 | |||
16 | What will it do? | ||
17 | |||
18 | Post-import, the "Auto Gantt View" tab will reference your Todoist csv tab when you've inserted its name into cell B1. Then, automatically, this will happen… | ||
19 | |||
20 | - Filter the csv so that only tasks and sections are carried into the Gantt view. Sections are highlighted blue and tasks with no due dates, red. | ||
21 | |||
22 | - For tasks with dates, only one-off tasks are returned. This is done by filtering out "ev" and "every". | ||
23 | |||
24 | - Note, the Gantt view is only designed to work with DATES and not DEADLINES. this would make things a lot more complicated, beyond a "quick and dirty," which is essentially what this is. Todoist of course does not have any dependencies like a true Gantt chart. So this is very much limited to seeing your project in a Gantt-esque manner, with timeline scrolling to the right. | ||
25 | |||
26 | Once the tab name has been inserted in B1, the Gantt chart will be auto-generated for your review. | ||
27 | |||
28 | How to use | ||
29 | |||
30 | Go to your project in Todoist on desktop or web and click on the 3 horizontal dots in the top-right. From the menu, select, Export as csv. It's very important that you untick "use relative dates," prior to clicking on Export. We want actual dates. | ||
31 | |||
32 | Once you have your file downloaded to your computer, in this workbook, go to the menu bar above and… | ||
33 | |||
34 | File > Import and then select your file if it's on your Google Drive, or more likely, use Upload and drag your csv file there from your computer. | ||
35 | |||
36 | Once the upload has taken place, we need to configure the Import location. From the drop down, select the second option, Insert new sheet(s)and click on Import data. | ||
37 | |||
38 | With the data imported, all you need do now is go to cell B1 on the "Auto Gantt View" tab and type in the name of the tab with your imported Todoist data. This obviously has to be exactly the same. And that's it! Your Gantt will be generated. | ||
39 | |||
40 | Queries / feedback | ||
41 | |||
42 | Please get in touch via my homepage if you've any queries or issues to flag | ||
43 |
