Here is a thing when you open CSV in excel by double clicking the file then excel open the file not in standard CSV format but in one of excel's own default data format, similarly, when you try to save the file as CSV format then you will see warning message about formatting and UTF character files will convert into question marks that way.
If you try to open your original file from this thread into SQL server or even in excel as CSV you will notice the issue in the header of the CSV file i.e. on separate rows which will happen in any tool that follow the CSV file standards, same thing is happening with my library as it is following the CSV standards. Original CSV file that you provide Test01.csv
will show as follow in excel if you open it as CSV i.e.
that contains correct header in the CSV and open in excel as CSV will show header correctly i.e.
I hope I am able to clarify few things here. Enjoy!!!
Thanks & Regards.
Like, Share, Support, Subscribe!!!
YouTube Subscribe: https://bit.ly/2sY1aBb
E-Store Bytezaar: https://www.bytezaar.com/