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.
- Click on "Data" ribbon. In "Get External Data", select "From Text".
- 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.
- Select the delimiters that your data contains. You can also see the preview below. Click Next
- Then you can select each column and set the data format for each of them. After that click finish.
- "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