How to open import text file in excel without losing leading zeros

1. Launch Excel Spreadsheet. Click the "Data" tab. Click the "From Text" option icon.

2. Click the "From Text" icon. Use the file manager to locate the TXT file you want import.

3. Select the CSV file with the mouse. Click the "Import" button

4.Click the "Delimited" radio button in the Text Import Wizard. Deselect the "Tab," "Semicolon" and "Space" boxes. Click the "Next" button.

5.Select "Tab" Delimiters. Click "Next."

6.Select the column that contains the data with leading zeros. Click the "Text" radio button to select it. Do the same for each column with leading zeros that you want to retain.

7. Click the "Finish" button.

8. Click the "OK" button in the "Input Data" dialog box.

9. Your data will be display correctly in excel.