# Export CSV

**URL:** <https://forum.asana.com/t/export-csv/85126>\
**Category:** Ask the Community\
**Created:** [2 June 2020 07:06 UTC](https://forum.asana.com/t/export-csv/85126 "2020-06-02T07:06:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![anon1630481](https://luna1.co/8d76cd.png) [@anon1630481](https://forum.asana.com/u/anon1630481)\
**Post date:** [2 June 2020 07:06 UTC](https://forum.asana.com/t/export-csv/85126/1 "2020-06-02T07:06:27Z")

</div>

Briefly describe (1-2 sentences) the Bug you’re experiencing: When downloading the Asana Project as a .csv the rows are really messed up, it’s not seperating the columns by " , ". It’s just one big mess! I have seem a similar bug ([Export .csv task order modified since new sections implementation](https://forum.asana.com/t/export-csv-task-order-modified-since-new-sections-implementation/63403)) that seems to have been fixed but not for me.

Steps to reproduce: trying to download .csv, columns and everything is messed up.

Browser version: Chrome 83

Upload screenshots below:

 ![image](https://us1.discourse-cdn.com/asana/original/3X/0/d/0dd0a2323f03582292de4e439cd2e62626c81026.png)

---

<div class="post-metadata">

**Author:** ![Marie](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/marie/32/42208_2.png) [@Marie](https://forum.asana.com/u/Marie)\
**Post date:** [2 June 2020 07:46 UTC](https://forum.asana.com/t/export-csv/85126/2 "2020-06-02T07:46:24Z")

</div>

Hi @anon1630481 and thanks for reaching out!

Sounds like this might be a formatting issue rather than a bug, but let’s take a look into it together.

1. Can you confirm which application you’re opening your CSV with?

2. Could you give it a go with Google Sheet and let me know if you’re running into the same issue?

Looking forward to your reply!

---

<div class="post-metadata">

**Author:** ![anon1630481](https://luna1.co/8d76cd.png) [@anon1630481](https://forum.asana.com/u/anon1630481)\
**Post date:** [2 June 2020 07:50 UTC](https://forum.asana.com/t/export-csv/85126/3 "2020-06-02T07:50:11Z")

</div>

Thank you for your quick reply!  
I used Excel and you were right, it’s a formatting issue 🙂 worked perfectly with Google Sheets, but how can I make it work with Excel as well?

Thank you!

---

<div class="post-metadata">

**Author:** ![Marie](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/marie/32/42208_2.png) [@Marie](https://forum.asana.com/u/Marie)\
**Post date:** [2 June 2020 07:59 UTC](https://forum.asana.com/t/export-csv/85126/4 "2020-06-02T07:59:35Z")

</div>

Thanks for the quick follow-up @anon1630481,

Microsoft Excel will open .csv files, but depending on the system’s regional settings, it may expect a semicolon as a separator instead of a comma, since in some languages the comma is used as the decimal separator.

You should be able to change the List separator settings following the steps in this Office Support Guide: [https://support.office.com/en-ie/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba](https://support.office.com/en-ie/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba)

---

<div class="post-metadata">

**Author:** ![anon1630481](https://luna1.co/8d76cd.png) [@anon1630481](https://forum.asana.com/u/anon1630481)\
**Post date:** [2 June 2020 08:26 UTC](https://forum.asana.com/t/export-csv/85126/5 "2020-06-02T08:26:38Z")

</div>

Thank you very much for your help 🙂

---

<div class="post-metadata">

**Author:** ![Marie](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/marie/32/42208_2.png) [@Marie](https://forum.asana.com/u/Marie)\
**Post date:** [2 June 2020 08:37 UTC](https://forum.asana.com/t/export-csv/85126/6 "2020-06-02T08:37:19Z")

</div>

You’re very welcome 🙂 Don’t hesitate to reach out if you have any question in the future!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/system/32/276370_2.png) [@system](https://forum.asana.com/u/system)\
**Post date:** [27 April 2022 14:14 UTC](https://forum.asana.com/t/export-csv/85126/7 "2022-04-27T14:14:56Z")

</div>

Closed on 27 April 2022 14:14 UTC


