Convert CSV Unicode Text type to CSV MS-DOS type

[Enna]

I have multiple large CSV files. I would like to change the file type from Unicode text to MS-DOS without opening all the files. Is there a way to do that? Thank you

 

[Enna]

If you don't know how to write VBA code, then I do not think that VBA is a viable solution for you unless someone volunteers to create the code for you. I wish you well, but unfortunately I do not have the time to spend on that effort.

I have 4 small and bigger csv files. I would like to change file type from "csv unicode text" to "csv ms-dos". Some files are very large, so when I open and use "save as" it would truncate the data (as excel max reaches about 1047000 rows but I have over 1900000 rows). I can open the smaller file and use a VBA converter to apply for all 4 files. How can i do that? Thank you

 

[Enna]

I have 4 small and bigger csv files. I would like to change file type from "csv unicode text" to "csv ms-dos". Some files are very large, so when I open and use "save as" it would truncate the data (as excel max reaches about 1047000 rows but I have over 1900000 rows). I can open the smaller file and use a VBA converter to apply for all 4 files. How can i do that? Thank you

 

[Marc L]

​

As a reminder there are other ways - faster - than using Excel for this kind of need but if you really want to use Excel like a swiss knife tool​

link at least an attachment on a files host website like Dropbox containing a source text file sample and its expected result text file …​

​