[Solved] CSV Import formats the data incorrectly

[Ultra]

I'm using Calc to edit CSV tables used with Magento 2.

When importing the CSV, the preview displays the data correctly, however when imported the data is changed.

[jrkrideau]

I must be going blind but I do not see the difference between the .csv and .ods .

[Lupp]

It's very strange.
a) You chose the comma as the (only) field separator, but the preview is showing commas inside the third and forth field-column of the shown part.
b) BUT you don't address this obvious issue, but complain about "changed value". I cannot tell for sure, but assume the column BQ2 of your sheet is supposed to contain what was imported from the third column shown in the preview.
Please be so kind to explain what you expected, and how you got the paradox addressed under a).
c) IF your cell BQ 2 was imported from the previewed csv, and your settings (Dansk local) use the comma as the decimal separator, the shown result should be expected. It displays the number to the maximum resolution a spreadsheet number can be expected to give significant decimal digits (15). Assuming the cell has no explicit alignment, the left aligned header and the right aligned content of BQ2 back the guess this was the case.
d) If you want to import what looks like a number from csv as a text, you need to rightclick on the column header in the preview and choose that option.

Explainingto a bit more detail: The third shown column should be supposed to be kept together by a pair of doublequotes in the csv. Nonetheless it gets imported as a number under 'Standard' recognition.

[Villeroy]

I think, the 2 long numbers are in double-quotes. They are meant to be one text.
Check option "Quoted fields as text".
And always check "Detect special numbers".

[Ultra]

I think, the 2 long numbers are in double-quotes. They are meant to be one text.
Check option "Quoted fields as text".
And always check "Detect special numbers".

Thank you. Those checkboxes did the trick.

[ApacheOO]

Thank you so much for the solution