scalar email

Exactly how To Import a CSV File Containing a Column With a Leading 0 Into Excel

Microsoft Excel will instantly transform information columns into the style that it thinks is best when opening up comma-separated information documents. For those of us that do not desire our data changed, we can transform that habits.

You have a CSV documents possibly exported from other application or provided to you by other people. You would like to open it up in Excel given that you know it quite possibly. The CSV documents will look like this (if you open the file in notepad.exe):

The data has columns: ProductModelID, Name, SpecialID, as well as ModifiedDate. The column SpeicalID containing information with leading 0 and also it is specialized code so you would love to maintain the leading 0s in Excel. Considering that it is a CSV documents it is, by default, displayed in your Windows Explorer as an Excel documents:

So you double-click the data and also open up the data in Excel thus:

You can see that by default, Excel removed out the leading 0s in column 3 “SpecialID

Leave a Reply

Need help with the Commons? Visit our
help page
Send us a message