Briefly describe (1-2 sentences) the Bug you’re experiencing: Some Task IDs on CSV Export don’t match the expected Task ID of the URL provided in “Copy Task Link” option. Steps to reproduce: Press project … → Export/Print → CSV Browser version: Chrome Version 73.0.3683.103 (Official Build) (64-…

That looks worrying. Did you look at the cell and see if there was some kind of formatting in place, like rounding up number or something like this? It’s a long shot.

Hi @EljVek and thanks for reporting this issue! In order to help us investigating this issue, could you please share the URL of the Project you’ve exported? These ID’s look very neat (as in they have a loads of 0’s and end by 1,2,3); considering each task ID in the whole Asana is unique, the proba…

A regular ID looks like this " 1107608961464616". So my gut feeling is some kind of overflow because the cell is a number celle and your Excel does not know how to display such a big number. Try to change to a text celle instead…

@Bastien_Siebman @Marie , It’s not an Excel formatting issue. Excel will display all Task IDs by default as “1.12E+15” since there are too many digits, but when viewing the direct cell the raw data will display the true Task ID number. I should have expanded on my initial post, but I slightly modif…

[image] EljVek: I should have expanded on my initial post, but I slightly modified the Task IDs in my example for privacy purposes. I reduced the number of digits down and changed the pattern such that the issue could be easily understood. In reality, my Task IDs are 16 digits long and differ gr…

Thanks for the additional information @EljVek , Could you please provide me the URL of the three tasks exported in your CSV above? This would be super useful to help us investigate this issue further! Looking forward to your reply!

Hi @EljVek and thank you so much for providing me with additional details via DM! I took a look at your project and can confirm there is absolutely nothing wrong with your task IDs. We recently modified our system for task ID’s (see Reminder about two big upcoming API changes (String IDs and new se…

I’m also seeing this issue. The task ID from the export is not matching the ID reflected in the Asana URL. For example, here is a URL to a task in Asana: Log in - Asana However, when I do an export that includes that task, the ID shows: 1126533934904030 All IDs in the export have had the last val…

I agree with you. There shouldn’t be any differences. The export feature isn’t useful unless these match.

After looking again, this seems to be an issue with Excel. When I view the export as text, the ID numbers are correct but when I open in Excel the numbers have been rounded. Unfortunately, I can’t seem to get the Excel Data Import Wizard to pull and format the data correctly without the rounding. I…

Some Task IDs are incorrect on CSV Export

English Forum Ask the Community

Phil_Seeman 23 September 2019 15:14 14

FYI, for anyone looking for a solution to importing tasks into Excel and retaining the proper ID values, please see:

Topic		Replies	Views
Some Project IDs and Task IDs not displaying properly on export Ask the Community	9	2458	27 April 2022
Duplicating Tasks also duplicates the Task ID Ask the Community projects , tasks	6	4573	30 May 2025
エクスポートで個々のタスクのURLを取り出せませんか？質問とアドバイス tasks , import-export	7	215	1 August 2024
Task ID in CSV exports only shows 15 of the 16 Task ID characters Closed	3	2084	26 June 2021
include URL to task in export CSV Product Feedback links , tasks , import-export	6	1500	18 March 2025

Some Task IDs are incorrect on CSV Export

Related topics