MS Excel Secrets - Importing a Text File in Excel 2007
![](http://img2.blogblog.com/img/icon18_edit_allbkg.gif)
https://ingenuitydias.blogspot.com/2014/03/ms-excel-secrets-importing-text-file-in.html
Importing a text file in Excel 2007:
1. Select File -> Open -> find the text file and click Open.
2. In Text Import Wizard dialogue box:
Step 1:
Select Delimited, US- ASCII and click Next.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7GLWy-Qvr1KBqiO2ZODNtWcKehv_zATyfREDV5WVv4doLwD5WTzkepL8L3p0yWj-GKD66I9QtMGPEvDaoLXeoIzTeu7hNFKRQi24qoiKWuTL-wsIrUYwSfVJxeI7H4elVdRb-SresYV9l/s1600/1376-2.jpg)
Step 3:
For each column select the Column Data Format and click Finish.
1. Select File -> Open -> find the text file and click Open.
2. In Text Import Wizard dialogue box:
Step 1:
Select Delimited, US- ASCII and click Next.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7GLWy-Qvr1KBqiO2ZODNtWcKehv_zATyfREDV5WVv4doLwD5WTzkepL8L3p0yWj-GKD66I9QtMGPEvDaoLXeoIzTeu7hNFKRQi24qoiKWuTL-wsIrUYwSfVJxeI7H4elVdRb-SresYV9l/s1600/1376-2.jpg)
Step 3:
For each column select the Column Data Format and click Finish.