Excel Tip – Import a Text File to Excel:

1. Select File -> Open -> find the text file and click Open.
2. In Text Import Wizard dialog box:
Step 1:
Select Delimited, US- ASCII and click Next.



Step 2:
Select Tab and click Next.



Step 3:
For each column select the Column Data Format and click Finish.



3. If delimiter is not present in the text file,

Step 1:
Select Fixed width and click Next.

Step 2:
By default, the data will be split at each spaces available in the data. If any changes are required, then click on the arrow and move it to the desired place of data separation and click next.


Step 3:
For each column select the Column Data Format and click Finish.