Home Tips How to Import Text file into Excel 2010, 2007 & 2003

How to Import Text file into Excel 2010, 2007 & 2003

788
0
SHARE
Import Text file into Excel

Convert a text file to an Excel file

Looking to convert text file into Excel of any version like Excel 2010, 2007 or 2003? Then check out the below steps to Convert a text file to Excel file. It helps you to get separate in short time if you have text file with any details like side by side. You can convert them into excel file without any disturbance and loosing the data from text file.

The procedure and options are different by comparing to versions like Excel 2003, 2007 & 2010. So you need to choose the method which version of Excel you are using in your computer or laptop.

Microsoft Excel 2003

Convert Text file to MS Excel 2003

People, who are using MS Excel 2003 version, must follow below steps to convert text file to Excel.

Steps:

  1. Open MS Excel, ClickData from the top menu (See above Image for idea)
  2. Select Import External Data > Import Data from the Data (Data> Import External Data > Import Data)
  3. Open the text file & Select Delimited and click Next
  4. Uncheck Tab and select Space & click next
  5. Here you click Finish button and save it
  6. You should select anyone from Excel Workbook (*xlsx), Excel 97-2003 Workbook (*.xls), or CSV (Comma Delimited)(*.csv) From save as during save the file
  7. You should select ok and yes for the next two messages if you saved as a CSV file
  8. Note: Import your Email address after you saved converted file to system

How to Convert Text file to MS Excel 2007

  1. Open MS Excel and clickData from the menu
  2. Clickfrom Text option
  3. Browse for thetext file which you want to convert into Microsoft Excel 2007
  4. Click on Import and the next procedure same like the above MS Excel 2003

How to convert Text file into MS Excel 2010

Here you can follow below steps to convert text file into MS Excel 2010

  1. Open MS Excel and click onData tab
  2. Next click fromText in the Get External Data group
  3. The next steps as same as above versions

These are methods to convert a text file into Microsoft Excel 2013, 2007 and 2010

LEAVE A REPLY