Friday, 6 September 2013

How to import data from text file(.txt) to an Excel sheet?

It's really tedious to copy and paste from the text file to excel worksheet. Microsoft Office Excel provides a feature to import data from text file into your excel worksheet as an external data range.

  • On your active worksheet, click the cell where you want the data from text file.
    Select Range/Cell in Excel Worksheet
  • Click on "Data" ribbon. In "Get External Data", select "From Text".
    Import From Text in Excel Worksheet
  • Browse and select the text file from which you want to import data.
  • Choose the file type which is related to your data. Click Next.
    Delimited Or Fixed Width Import Option In Excel Sheet
  • Select the delimiters that your data contains. You can also see the preview below. Click Next
    Tab Seperation Comma Space Options For Import
  • Then you can select each column and set the data format for each of them. After that click finish.Set Data Format For Each Column
  • "Import Data" window will pop and select "Existing Worksheet". Click OK.
  • Done! Data from text file will appear in your active worksheet.

No comments:

Post a Comment

ShareThis