Dear Tamara,
Thanks for your detailed feedback.
In the Microsoft documentation you linked, the name "text qualifier" is misleading.
Can this view trigger any further consequences?
It doesn't mean the value will always be formatted as text by the program.
This aspect is interesting, isn't it?
"01" became the integer 1, …
Which data types can handle “numbers” so that leading zeros would be preserved?
So adding double quotes around all values to designate a "text" datatype will not work for Excel;
This can be fine in some use cases.
users still need to manually change the formats of the cells.
This can happen also.
The "Format quoted field as text" is a LibreOffice-specific option
Would you like to take related program variants better into account?
that does format all of the values as text,
Do you like such a software functionality?
not numbers or dates.
I find such a setting occasionally useful.
To accomplish the same in Excel requires several complicated steps.
Do any advanced users require special CSV data import configurations?
Examples: https://www.winhelponline.com/blog/stop-excel-convert-text-to-number-date-fo...
Will the attention grow for further clarification also according to information from the article “Stop Excel from Converting Text to Number or Date format when Opening a CSV file”?
…, and even if it were it wouldn't accomplish what you want.
I suggest to reconsider this view a bit more.
Do I eventually need to reimplement CSV export functionality by XQuery means of customised string concatenations?
Regards, Markus