Need a hand? We've got you covered.

Knowledge Base Home aero-right Contact Lists aero-right How do I convert a text file to an Excel file?

How do I convert a text file to an Excel file?

Contact Lists Updated on July 23, 2011

Converting your text files into excel files can save you time because the data will be divided into separate columns, making the information easy to distinguish and manage. Follow these steps to take advantage of this option:

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

Can't find what you're looking for?

Submit a Ticket

view ticket history