When I do an Asana export (I used Velocity - super useful) some of my Project IDs look like this: 1.15599E+15 1.16308E+15 1.16266E+15 1.12531E+15 And some of my Task IDs look like this 1.12775E+15 Now for us, Project IDs = CLIENT IDs - and TASKS = PROJECTS for that client. In the FORMULA bar…

Hi @KarenV , is this happening with different sofwares? Could you try opening your file with Excel and GoogleSheet and let us know if you’re experiencing the same issue? Also, if you open GoogleSheet, what format (see screenshot below) comes us as default? [Capture d’écran 2020-03-12 à 17.45.30] …

[image] Marie : Could you try opening your file with Excel and GoogleSheet FYI in my experience Excel doesn’t work for Asana IDs - it can’t handle the precision and mangles the formatting. Google Sheets has worked perfectly for me in regard to handling IDs.

Hi thanks @Marie and @Phil_Seeman for your help. Just came back here to report and update. BTW - this was happening in Excel and Google Sheets. It happened again this morning and no amount of copying and special pasting were fixing the issue (Marie - I think the default was automatic - but I trie…

[image] KarenV: EDIT: I spoke too soon. It turned the entries into a number, but on sorting I noticed there were a lot of duplicated #s. So something happens to the Task IDs when being converted or copying and pasting into new cells. In Google Sheets also? I’ve not had issues with Task IDs in…

Hi Phil @Phil_Seeman yes it’s both… [image]

@KarenV , Hmm, did you set the column to “Plain text” in Google Sheets? That format works for me. The IDs will be left-justified if you have it set that way, and it should display the whole ID. (Don’t bother trying Excel - I spent hours trying every formatting possibility I could think of, and neve…

[image] Phil_Seeman: (Don’t bother trying Excel - I spent hours trying every formatting possibility I could think of, and never got IDs displaying properly in Excel.) Oops, that’s wrong - I had completely forgotten that I did figure out a way to have the IDs work properly in Excel! See: …

Some Project IDs and Task IDs not displaying properly on export

Asana Community Ask the Community

Marie 12 March 2020 16:53 4

Thanks for weighting in @Phil_Seeman!

Topic		Replies	Views
Some Task IDs are incorrect on CSV Export Ask the Community projects , tasks	13	5177	23 September 2019
Duplicating Tasks also duplicates the Task ID Ask the Community projects , tasks	5	4734	10 June 2021
エクスポートで個々のタスクのURLを取り出せませんか？質問とアドバイス tasks , import-export	6	283	25 July 2024
include URL to task in export CSV Product Ideas links , tasks , import-export	6	1576	18 March 2025
Id de Tarea Comunidad de Asana	1	1250	5 September 2022

Some Project IDs and Task IDs not displaying properly on export

Related topics