answers.vt.edu / Third Party Applications / Converting a Text File (.txt, .prn, .csv) to an Excel 2003/2007/2010...
 
Converting a Text File (.txt, .prn, .csv) to an Excel 2003/2007/2010 File (.xls) in Windows
Time to Complete (in minutes): 5
Question:
How do I convert a text file (.txt, .prn, .csv) to an Excel 2003/2007/2010 file (.xls) in Windows?

Answer:
  1. Start Excel.
  2. View all readable text files.
    • In Excel 2003:
      1. From the File drop-down list, select Open....
      2. From the Files of type: drop-down list, select Text Files (*.prm; *.txt; *.csv).
    • In Excel 2007:
      1. Click the Office button.
      2. From the drop-down list, select Open.
      3. From the Files of type: drop-down list, select Text Files (*.prm; *.txt; *.csv).
    • In Excel 2010:
      1. Select the File tab.
      2. In the left menu column, select Open.
      3. To the right of the File name: text box, from the drop-down list, select Text Files (*.prm; *.txt; *.csv).
  3. Navigate to and select the document you want to convert.
  4. Click the Open button.
  5. Select the Delimited radio button.
  6. Click Next.
  7. Under Delimiters, clear all the check boxes.
  8. Under Delimiters, place a check in the check box(es) corresponding to the separator(s) your data contains.
  9. Click Next.
  10. Click Finish.

If you have feedback about the content of this article, please leave a comment. If you need assistance with these instructions, contact 4Help at http://4help.vt.edu.

  • Article ID: 393
  • Last updated: 07 Sep, 2012
  •  
  • Views: 62786
  • Comments: 0
  •  
  • Add comment
  •  
  • If you have feedback about the content of this article, please leave a comment. If you need assistance with these instructions, contact 4Help at http://4help.vt.edu.
© 2009 Virginia Polytechnic Institute and State University
Powered by KBPublisher (Knowledge base software)