Does anyone know how to upload a CSV to Netsuite t...
# general
t
Does anyone know how to upload a CSV to Netsuite that contains leading 0's in the CSV data?
e
What field type are you wanting to upload into?
t
ah, it's a custom field. 7-12 digits
e
is it Free Form Text?
t
yes
e
in that case the issue won't be NetSuite, it'll be Excel trying to be "smart"
t
ahh, okay. i'll go for solving that
✔️ 1
e
You can put leading 0's as much as you want - as long as the data is in the CSV. If you use Excel however, you have to have that column formatted as Text, not General
t
we'll keep trying - excel seems to be fighting that solution. thank you!
e
If you have the data in the CSV originally, and you want to modify it in Excel - use the Excel Data Import Wizard to ensure the CSV data is preserved, as opposed to just opening it up as a CSV
Excel... Data > From Text/CSV