Work on downloaded Reports using Excel

[MotherEarths]

Hi, 

I have downloaded Sales Report in .csv format but seems all the cells are locked and cannot use Excel to work with the report! Is there any way to be able to use Excel on the downloaded reports?

Thanks.

[JJ_]

Hey there @MotherEarths 

In order to make a CSV editable in Excel, you will need to first save it as a compatible Excel file. You can accomplish this by using the Save As... Feature in your Spreadsheet program and choose the Excel format. After this, you will be able to edit the data in the export.

[MotherEarths]

Hi JJ, 

Thank you for your response.

I did save the downloaded CSV file in .xls and .xlsx formats but was not able to edit it in any format including CSV. 

As a workaround, I opened the CSV using Google Sheets and it worked. Using Google Sheets I downloaded and saved the file in xls format and was then able to edit it. 

Through Google search results, I understand many users experience difficulty using CSV with Excel, hope my experience helps others.

Many thanks.

[MotherEarths]

Hi JJ,

I missed mentioning that I was attempting the files using MacBook, not sure if people using Windows also have issues.

Thanks 

[JJ_]

Thanks for this information @MotherEarths. I will share it with the team to keep an eye out for additional reports of trouble editing exports.

[helenmiller]

.csv is used for google sheet, there is a proper serpeate layout of excel sheets. You should have to use that one.