Hello @aleksandra.albera
The CSV Importer can be very particular at times. When it comes to the numeric data, it doesn’t seem to like when there are separator characters, e.g. commas. These are most commonly introduced with the “Accounting” format selected so I would try to avoid it.
Of the numeric formats available in Excel, I typically use “Number”. When saving your import file as a CSV it will change the format to “General”, but Asana will still recognize the numerical value and allow you to associate it with a numeric Custom Field. Here are the standard (non-custom) formats to choose from:
You’ll see in the screenshot below that I ran a test with all standard formats. Accounting was not accepted even though the raw data is the same. This was the case whether I included the currency symbol or not.
Personally, I would avoid “General” and “Text” as well when building my import file in excel. This will allow you to more easily ensure your data is input correctly prior to saving the configuration to CSV so it can be imported into Asana.
Once your data is in Asana you can choose to introduce the formatting you prefer, e.g. currency symbols, commas, decimals, etc.
Happy importing! 