Created attachment 153541 [details] Example file where 0123 becomes 123 I have attached an example CSV file that demonstrates this issue. When importing the CSV the value "0123" shows in the preview as 0123 but after clicking OK and viewing the new spreadsheet in Calc both A1 and B1 are set as 123 and the leading 0 is removed. This causes phone numbers from an export to load without their leading digits and become invalid. Tested on the 6.3.0.4 and 6.0.7.3 releases on Ubuntu 18.04.
You can click on the head of the column and select Text as type. https://help.libreoffice.org/6.3/en-US/text/scalc/guide/csv_files.html?DbPAR=CALC#bm_id892361 Please do your questions in Ask.libreoffice.org
That is a workaround but I think that if the value is wrapped in a string delimiter then it should be treated like a string and preserved (and if not, it can be treated like a number). In this example 0123,"0123" would import as 123,0123 Other cases like "0/10" will preserve the 0 and this feels inconsistent.
Please attach a sample with a couple of lines. Do you see in the import window "Format quoted field as Text"
Thanks m.a.riosv :) "Format quoted field as text" creates the behaviour I was after. Not sure how I missed that.