CSV file saved is corrupted

[jonnymop5]

Hello,
I am writing a collection to excel and saving the workbook. I save with a file name of .CSV or .txt. I've tried both and the file ends up corrupted (still opens and looks fine). I'm trying to load file to a server and need a good file. Any ideas on how to save an excel file or a collection, as a CSV file without corrupting it?
View attachment 1569006126453.png

Thanks,
Jon

 

[faraz13]

First save it as excel file (.xlsx). Then open the excel file, perform an edit operation on any cell (adding a value and removing it), then save as ‘.csv’.

The reason why it has to be done this way is that the data connection will still be tied to the source after exporting if directly converted to .csv. It will always ask for confirming the security of the file. So, we first save it as excel and then convert it.