Office of School Technology > ISD15 - Requests for the Office of School Technology > Knowledgebase

Search help:

Keep Leading Zeros when importing data into Excel


Follow the following instructions to keep leading zeros in data when importing from CSV file into Excel:

Open a new, blank Excel file.

Go to the Data tab, then the Get External Data section and choose From Text.
Select your CSV file, then click Import.
Original Data Type: select Delimited
Check the box if you data has a header
Delimiters: select Comma
Column Data Format: select Text
In the Data Preview select the first column, then press shift and select the last column to highlight all columns.
This should change all columns to text type and keep any leading zeros in the data.
Was this article helpful? yes / no
Article details
Article ID: 20
Category: Knowledgebase
Date added: 10-14-2020 09:36:17
Views: 13
Rating (Votes): Article not rated yet (0)

« Go back

Powered by Help Desk Software HESK, in partnership with SysAid Technologies