info

Current Computing Status:

Service Info

The new “Remote Access – VPN” service (aka Junos Pulse) went into production on Tuesday, July 29th, 2014. The legacy “PPTP Virginia Tech VPN” service will be decommissioned on August 12, 2014. The new VPN service works... view Status History All Active Statuses

Converting a Text File (.txt .prn .csv) to an Excel File (.xls) in Windows

Question:
How do I convert a text file (.txt, .prn, .csv) to an Excel file (.xls) in Windows?
Answer:

For Mac, see Converting a Text File (.txt) to an Excel File (.xls) in Mac OS.

  1. Start Excel.
  2. Start opening a file.
    • In 2007, after clicking the Office button, select Open.
    • In 2010 / 2013, under the File tab, select Open.
  3. View available text files.
    • In 2007, from the Files of type: drop-down list, select Text Files (*.prm; *.txt; *.csv).
    • In 2010 / 2013, to the right of the File name: text box, from the drop-down list, select Text Files (*.prm; *.txt; *.csv).
  4. Select the document you want to convert.
  5. Click the Open button.
  6. Select the Delimited radio button.
  7. Click the Next button.
  8. Under Delimiters, clear all the check boxes.
  9. Under Delimiters, place a check in the check box(es) corresponding to the separator(s) your data contains.
  10. Click the Next button.
  11. Click the Finish button.
Mon, 07/29/2013 - 2:55pm 66914 Views Article ID: 393