include URL to task in export CSV

[Floris_Assies1]

The URL to a task should be included in the export CSV file.

this has been suggested in 2018 but in ‘use cases’ > Including the Task Url in Export

this feature would really make my life easier!

Please vote up!

[Bastien_Siebman]

I disagree, the URL to a task is really easy to create with the gid, so you can create your own column if you need it. A CSV is about providing the basic building blocks, and then you do the work to build what you need with it

[anon72737593]

When you import the CSV, the taskId is a number instead of text so that the task id in Excel is wrong… Not easy solution and a lot of manual process that is crap!

For reference:

Duplicating Tasks also duplicates the Task ID

I do see that if I open the same CSV in Google sheets I get a different last digit, but that digit is a zero in Excel. It is either rounding down always or replacing the last digit with a zero in Excel. When I expand the sheet in Excel, I can see that all the last digits are zero. That tells me that we are somehow dropping the last digit and replacing it with a zero in Excel. Any ideas on how to avoid that? [image] [image]

[Bastien_Siebman]

Which I believe is something Asana can’t do anything about, a CSV doesn’t carry anything about the format, it is as raw as it can be.

[Katie_Dix]

I agree I have to keep everyone accountable for their work and a lot of folks do not even live in asana like I do as the project manager. So exporting an excel or csv file of an assignees tasks with a link to the task can actually help us get things done and hold folks accountable fast.

[lpb]

Note: Not a solution but marked as such to elevate a key reply

Asana2Go (disclaimer: I’m the creator) has an easy way to create a CSV that includes the task URL automatically (choose CSV - Detailed). With Asana2Go, there’s a way to get those CSV row into either Excel or GSheets without even creating a file! See the Help link in the main Asana2Go window.

But there are around 20 other outputs (lists, tables, etc.) that may be more appropriate for your purpose, @Katie_Dix.

How Well Do You Know Asana2Go?

As part of this special Integrations Edition of Forum Leader Tips, I’m covering an integration I should know better than anybody else—because I created it! Asana2Go is a free*, 5-star-rated Chrome (and MS Edge, Opera, and Brave) extension that enables you to copy, print, and export flexibly from Asana. It works with all free/paid Asana plans, requires no extra login/authentication, and does not modify/write anything in your Asana. Asana2Go has a diverse set of features, including some that Asa…

Thanks,

Larry

[Dan_Raney]

This is an Excel issue, not Asana. There is a workaround here, but basically the answer is not to double click open the csv, but instead to create a blank excel file, and then use “load data” from the data tab to import the data. during the import, change the data type of the task id column to text. as many have mentioned, add the url to the export would make this much easier, but i suspect would make more work happen outside the platform, which may not be beneficial to your overall project.