What changes when you convert XLS to CSV
.xls is a binary format, not a zip of XML. That is why a text editor shows you noise when you open one, and why some converters that handle .xlsx refuse it. The reader used here handles both.
The row limit that made .xls painful, 65,536 rows, is a property of the file rather than of the conversion. If your data hit that ceiling, the file is already truncated and converting it will not bring the missing rows back.
As with any spreadsheet conversion, formulas resolve to their values and formatting is left behind.
What carries over from XLS to CSV
Excel records 3 things about a table that CSV has no way to hold.
Excel distinguishes a number from the text of a number; CSV does not, so every value arrives as text and has to be re-parsed by whatever reads it next.
An empty cell and a missing one are the same thing in CSV, so a null and an empty string in the Excel both come out blank and can no longer be told apart.
Anything visual in the Excel - weight, alignment, colour, column widths - has no counterpart in CSV and is dropped. The values are what survives.
The result can be read a record at a time, and appended to by adding to the end of it. That is worth having for a table too large to hold in memory, and it means a CSV file that is cut off part way through still gives you every record before the cut.