Convert xlsx to csv

[Anish_Kumar2 (Anish Kumar)]

Hi Team,

I have one xlsx file I have to convert into csv.

So, I have use read range activity then after that I use write csv activity.

but my output come like this why.

but when I copy this csv file from the server and open in my local system the output is correct

so can anyone help me on this, and also i attached an input file below:
RawInput.xlsx (11.4 KB)

[Parvathy (PS Parvathy)]

Hi @Anish_Kumar2

Check out this thread

.xlsl to CSV

Don’t use the use Excel file activity and all delete all the excel activities and simply use read range workbook activity provide the path of the excel file and sheet name create a variable in the output of read range workbook. After that use write CSV activity and pass the datatable variable which is the out of read range workbook and give the path of CSV file. Then it will work!! It was the simplest procedure. Just use the above two activities don’t use use Excel file and write data to exce…

Check out the below zip file. It was working fine at my end.
BlankProcess31.zip (36.9 KB)

Hope it helps!!

[Anish_Kumar2 (Anish Kumar)]

That do not work for me maybe in my server there is problem.
I notice whenever I open csv on my server. that popup is came maybe that why its happen

[Parvathy (PS Parvathy)]

Hi @Anish_Kumar2

May be that you be cause. It’s working fine at my local machine too.

Hope you have found the solution. If yes, please mark my post it as solution

Regards

[rlgandu (Rajyalakshmi Gandu)]

@Anish_Kumar2

Instead of writing data in a csv file write it in text file,Here i give comma as a seperator

[Anil_G (Anil Gorthi)]

@Anish_Kumar2

I dint see any error with the file…to view a csv ideally we need to use text file…sometimes excel might not parse it properly that is usual…the output you are showing is having comma inbetween which is the basic ask for csv

Cheers