Line breaks when exporting CSV

English Forum Tips and Tricks
1

Briefly describe (1-2 sentences) the Bug you’re experiencing:
When exporting a portfolio in CSV format, line breaks are incorrectly added in the CSV file for the custom fields ie. any line break in the Asana field is creating a line break (LF) also in the CSV. This behavior is not correct, and it’s not happening in case of any line break of Asana standard fields.

Impact:
When importing the CSV in Excel through Text to Columns, the content of the custom field is split in more lines in case of any line break in a free text custom field. This is not happening in case a line break is added to a standard field like eg Project Description, and that should be the correct behavior.

Steps to reproduce:

  1. Open the Portfolio in Asana
  2. Actions Menu > Export > CSV
  3. Open the CSV with Notepad++ and enable the option to see all Characters
  4. You can see the difference in the screenshots below.

Browser version:
Google Chrome Version 85.0.4183.121 (Official Build) (64-bit)

Upload screenshots below:

  1. LF at the end of the row - correct behavior
    image

  2. LF after a line break in the custom field - incorrect behavior
    image

  3. No LF after a line break in the standard field, but a space - correct behavior

    image
    image1151×35 5.22 KB

2

Hi @anon76770981, thanks for reaching out and reporting this issue!

In order to best assist you and investigate this issue, I recommend you to contact our Support team and share the following information:

  • URL of this forum thread so you don’t need to rewrite everything
  • An example CSV file

This will help us to identify the issue quicker and escalate it to our development team.

Thanks again for this report and please let me know if you have any questions.

3

Thanks @Emily_Roman, will do!

Pasquale

1 Like