I’ve noticed that when I import a csv that contains apostrophes in a field mapping to the description field in Asana, they get picked up as errors and show up as “’” instead. So far I’ve tried these things to see if it fixes it:
- Editing the cell’s format in an excel to be text instead of general before exporting as a csv and then importing into Asana
- Creating the csv as an export from Google sheets first instead of from Excel
- Importing as a plain csv vs. csv utf-8
- Changing the Asana character encoding option between utf-8 and Windows
Any other suggestions? Or have any folks that have run into this as well?
Thanks in advance!