CSV Encoding Standard

[anon12655787]

This is the simplest question really. I just want to know what encoding standard Asana uses to create their CSV’s. I’m trying to import the CSV’s into a database and I want to eliminate the possibility of using the wrong encoding setting before I start escaping characters. My assumption is that the files are utf-8, but I’d like to know for sure.

Good Fortune,
Rick

[Andrea_Mayer]

Hey @anon12655787,
I am not completely sure but I also think utf-8 as another person mentioned it here in the forum as well: CSV importer stuck - #5 by Kaitlyn_Tagarelli

And here is more info: Export to .CSV - UTF8 Issue - #5 by Alexis

UTF problem for .csv export - Excel VBA solution

We all know the problem with the UTF for international languages discussed previously for xample here: Export to .CSV - UTF8 Issue. So here is an instrument that might help: Asana UTF Processing.xlsm - Google Drive Download this .xlsm and put it in the same folder where are all the exported .csv file(s). Run the macro (the only one in the workbook). It will create new files (.xlsx) and delete the old .csv files. By this the unrecognized symbols will be converted to UTF-8 and Chr(10) invisible…

I hope this helps

[anon12655787]

Thanks @Andrea_Mayer. I’m having anticipated issues importing data from the CSV’s. It won’t be a language issue for me, but almost certainly special characters that are messing up the works. I just wanted to make sure I’m using the right encoding setting because if I pick the wrong one, I’m just making more work for myself.

[Andrea_Mayer]

@anon12655787

I’m just making more work for myself.

Oh yeah that makes sense. That would not be ideal at all!