# Completed tasks when importing a csv-file into asana **URL:** \ **Category:** Ask the Community\ **Created:** [18 August 2022 05:29 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682 "2022-08-18T05:29:57Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Marina\_Moskaleva](https://luna1.co/8d76cd.png) [@Marina\_Moskaleva](https://forum.asana.com/u/Marina_Moskaleva)\ **Post date:** [18 August 2022 05:29 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/1 "2022-08-18T05:29:57Z")
Hello! Please help with this issue. What format and structure should the csv-file have so that when it is imported into Asana, the tasks will be marked as completed? ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [18 August 2022 07:19 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/2 "2022-08-18T07:19:14Z")
Hi, I am not sure this is possible with the CSV importer. @LEGGO any idea? ---
**Author:** ![Paul\_Grobler](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/paul_grobler/32/100608_2.png) [@Paul\_Grobler](https://forum.asana.com/u/Paul_Grobler)\ **Post date:** [18 August 2022 14:18 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/3 "2022-08-18T14:18:42Z")
According to my understanding importing from csv will not update the current tasks but will create new ones. see this thread: > [@Import to update existing tasks](https://forum.asana.com/t/import-to-update-existing-tasks/26670): > > Apologies if there is a way to do this but my google-fu has failed thus far. It would be great if importing could use unique identifiers (such as the Asana assigned Task ID) to match to existing tasks and update/add/overwrite fields associated with that task. From my current testing it duplicates tasks rather than updating them, which makes sense given that many use-cases may have tasks which require duplicate names so maybe an option to match or not to match? Thanks for thoughts, tips, help. … ---
**Author:** ![Rosario\_Messina](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/rosario_messina/32/105419_2.png) [@Rosario\_Messina](https://forum.asana.com/u/Rosario_Messina)\ **Post date:** [18 August 2022 15:27 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/4 "2022-08-18T15:27:47Z")
Hello @Marina_Moskaleva , Welcome to the Asana Forum 👋 🙂 As of today you cannot import tasks as completed or match them to existing completed tasks. You can upvote the thread that Paul shared, the more votes, the more likely it is that the feature request will be prioritized. May I ask you what your specific workflow, in this case, is and why do you need to import completed tasks? Maybe there is another way to achieve this efficiently. Are you already aware of bulk actions? You can complete up to 50 tasks simultaneously with just a click. > **[Ways to save time in Asana | Product guide • Asana Product Guide](https://asana.com/guide/team/advanced/save-time-in-asana#gl-multiselect)** > > Get work done faster with these time-saving features. Cheers, Rosario ---
**Author:** ![anon13753567](https://luna1.co/8d76cd.png) [@anon13753567](https://forum.asana.com/u/anon13753567)\ **Post date:** [5 January 2024 18:40 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/5 "2024-01-05T18:40:14Z")
Do you have any recent developments to share regarding this matter? I’m currently in the process of importing a substantial volume of tasks, and it would be highly beneficial if they could be pre-completed upon import. Presently, I find myself manually completing 50 tasks at a time, and any improvements in this workflow would be greatly appreciated. ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [6 January 2024 08:44 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/6 "2024-01-06T08:44:40Z")
No news on this topic I am afraid. ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [6 January 2024 20:35 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/7 "2024-01-06T20:35:57Z")
Hi @anon13753567 , I’ve tested this and it works: In your destination project, where you will import your CSV, prepare it with the following: 1. Create a ‘status’ single-select field with the a single option ‘complete’ (or better yet, add an existing status field from your field library if you want the value to remain on your tasks, after importing). 2. Create a Rule that when tasks are added to the project, check if ‘status’ field is complete, then change task completion status to complete AND clear ‘status’ field (skip this AND step if you use a status field from your library and you actually want the ‘complete’ value to remain on your tasks). Then, in your CSV file, BEFORE you import it, add a column called ‘status’ and add the value ‘complete’ for all tasks you want to be imported as complete. (or use the relevant value from your status field in your library, which could be eg. ‘Done’). During the CSV import, choose ‘Make changes’ to make sure your status field in your CSV is correctly mapped to the status field in the destination project. Once the project is imported, the rule should fire and you can remove/delete the status field from the project (or keep it if you have used a status field from the library and you want that value to remain on all tasks). ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [8 January 2024 07:35 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/8 "2024-01-08T07:35:01Z")
Are we sure rules fire on CSV import? A little voice in my head is telling me someone pointed out it doesn’t… ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [8 January 2024 07:45 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/9 "2024-01-08T07:45:22Z")
Yup, tried and tested 😉 ---
**Author:** ![anon13753567](https://luna1.co/8d76cd.png) [@anon13753567](https://forum.asana.com/u/anon13753567)\ **Post date:** [8 January 2024 19:29 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/10 "2024-01-08T19:29:13Z")
After testing this, the Rule seems rather inconsistent, and does not complete all tasks even though the status is set to complete. Is anyone else experiencing this? attaching an image of the test batch of 55. 7/55 were not triggered ![image](https://us1.discourse-cdn.com/asana/original/3X/3/8/3848417dc86a7dc6c2b7599d805fad6489b8ee92.png) ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [8 January 2024 19:35 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/11 "2024-01-08T19:35:00Z")
Ah that’s a shame. I admit I have tested this on a much smaller batch without any misfires. Good to know and look out for it! @Bastien_Siebman , is this what you were referring to above? i.e. an inconsistency of rules being triggered? ---
**Author:** ![Bastien\_Siebman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/bastien_siebman/32/172354_2.png) [@Bastien\_Siebman](https://forum.asana.com/u/Bastien_Siebman)\ **Post date:** [9 January 2024 05:28 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/12 "2024-01-09T05:28:13Z")
I had a similar issue when bulk-editing tasks where an edit would fire a rule: out of 200-300 tasks, 2 or 3 would not fire the rule 😅 My point was more that the CSV import was not firing at all, but looks like this was either not true or fixed. ---
**Author:** ![system](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/system/32/276370_2.png) [@system](https://forum.asana.com/u/system)\ **Post date:** [16 January 2024 05:28 UTC](https://forum.asana.com/t/completed-tasks-when-importing-a-csv-file-into-asana/192682/13 "2024-01-16T05:28:33Z")
Closed on 16 January 2024 05:28 UTC This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.