What changes when you convert XLSX to CSV
.xlsx is a zip archive of XML parts, which is why the file is larger than the data in it and why unzipping one shows you a folder of sheets, styles and shared strings. Reading it means unpacking that archive and walking the sheet XML, which is what happens here.
The conversion keeps values and drops everything that describes how they look. Styles live in a separate part of the archive from the cell data, so leaving them behind is not a compromise, it is the natural result of reading only the sheet.
A workbook can hold many sheets and a CSV cannot. The first sheet is used.
What carries over from XLSX 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.