I have a python script which pulls the data from SQL and save the file in CSV Format. There are 80000 records but it shows in excel as 100000 records. So, I opened the csv file in Notepad++ and it shows _x000D_LF or LF and some other lines shows CR LF. I need to find a way how fix this issue. it should all show CR LF not _x000D_LF or LF. Attached is the CSV file.
it should be like this one below:
Please let me know what code can I write in VBA (excel macro) so that it can be fixed and I can save my file as xlsx format.