A .gov website belongs to an official government organization in the United States.
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
Datatab and choose
From Text. An Import Text File window will open.
Textformat to keep the leading zeroes. Here’s how to do it:
Textin the Column Data Format section.
Finish. The Import Data window will open. Choose
OK. All of the data records now appear in the workbook with one field per column.