CSV parser does not recognize numbers in scientific notation

When uploading a CSV containing numbers in scientific notation Sigma is unable to cast them to a number during the parsing phase.

Ex consider the following CSV:

string, number
this is a number test, 3.4743674885626824e-05

The number column is interpreted as text.

At the moment Sigma CSV parser does not interpret values in scientific notation as numbers and will throw a warning when forced to cast the value to number. Additionally it will nullify the values. A workaround would be to let the parser interpret as a text string and then convert the column to number once in the worksheet.