How to Import Data from Text File into Excel (3 Methods)

Import Data from Text File into Excel

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

Import Data from Text File by Opening It in Excel

Import Data from Text File by Opening It in Excel

Method 2 – Use the Excel Power Query Editor to Include Text File Data

Steps:

Excel Power Query Editor to Include <a href=Text File Data" width="541" height="522" />

Excel Power Query Editor to Include <a href=Text File Data" width="598" height="431" />

Method 3 – Apply Copy and Paste for Importing Data from a Text File

Steps:

Apply Copy & Paste Features for Importing Data from Text File

Apply Copy & Paste Features for Importing Data from Text File

Refresh Imported Data in Excel

Steps:

Download the Practice Workbook

Import Data from Text File.xlsx

Related Articles

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