How to Import Data from Text File into Excel (3 Methods)
We’ll use the following data present in a text file as our source. The data contains the Salesman, Product, and Sales information of a company. We’ll import this information into an Excel worksheet.
How to Import Data from a Text File into Excel: 3 Easy Ways
Method 1 – Import Data from a Text File by Opening It in Excel
- A dialog box will pop out.
- Select your desired text file and press Open.
- You’ll see the text file information in a new Excel workbook. If the file has a delimiter such as space, vertical bar, or comma between values in a row, Excel will immediately separate those values into columns.
Method 2 – Use the Excel Power Query Editor to Include Text File Data
Steps:
Text File Data" width="541" height="522" />
- The Import Data dialog box will emerge.
- Select the text file where you have your required information.
- Press Import.
Text File Data" width="598" height="431" />
- A new window will pop out where you’ll see the text file information.
- Press Load.
- This’ll return a new Excel worksheet with the data from the text file.
Method 3 – Apply Copy and Paste for Importing Data from a Text File
Steps:
- Go to the Excel worksheet where you want the information to appear.
- Select the range B4:D10.
Refresh Imported Data in Excel
Steps:
- Right-click on the imported data. A list of options will appear.
- Select Refresh.
- This’ll return the refreshed data.
Download the Practice Workbook
Import Data from Text File.xlsx
Related Articles
- How to Convert Text File to Excel Automatically
- VBA Code to Convert Text File to Excel
Save Saved Removed 0
Aung Shine
Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel. Read Full Bio
