I am having trouble with a column when importing the file into NetSuite, being saved as Scientific Notion instead of as a large number or text. When you open the CSV file in Excel, one column with a large number is shown as Scientific Notation. When you open with a text editor, the large number is shown, which I guess it means that the value is stored as that. However, when importing this CSV in NetSuite, that column is still imported as Scientific Notion. I have tried several methods suggested online, such as this one https://www.teachexcel.com/excel-tutorial/convert-scientific-notation-to-numbers-in-excel_1594.html Any idea on how can I import succesfully this column into NetSuite? In other words, if I open the CSV with a text editor, and the large number is shown (no scientific notation), which I guess it means that the value is stored as that. Is there any chance that during the import NetSuite behaves like excel and somehow transform it to scientific notation?

@Roc127 what field type are you mapping it to in NetSuite?

@Chris Corcoran Free form text is the field type in NetSuite

@Roc127 my guess is that you're saving over the file from excel. Don't even open it in excel. If you see it correctly in notepad, save the file, and import, it should work. Alternatively, you can open in excel and format the column so it no longer shows there as scientific notation and then save. I've never seen netsuite convert anything itself. If my file has scientific notation, that gets imported...if it doesn't, it doesnt

@Roc127 use formula text and insert the following formula (hard to read but there are 4 single quotes). CONCAT('''', {name}) substitute name with the field name you need. You can find it using the formula builder.

Thank you both, I will try your suggestions!

NP @Roc127 post an update here if the suggestions work (so others that search or follow will know).

Hi all, basically seeing the file correctly in notepad, saving the file, and importing it into NetSuite worked fine, as expected. My guess is that the when the issue happened (this action was done by other user), the csv file was open with excel, view with scientific notion, saved it, and then imported, thus the incorrect result we had at the beggining. Thank you for your help!

Thanks for the update!