Hacker News new | ask | show | jobs
by nodata 4026 days ago
Can't you set the number format on the cell?
2 comments

You set the field to text on import. Very simple. Its a shipping number so text is fine.
It's possible with .xls or .xlsx files, but csv files can't store number formats.
That is why you convert the spread sheet column to a number before you export to csv. The fulfillment center was lazy, when you paste large numbers like that into excel, it auto converts your large number into scientific notation. you simply only have to change the data type of the column and it will change it back to a number. A CSV is dumb, it only exports what Excel displays.