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:

• The Import Data dialog box will emerge.
• Select the text file where you have your required information.
• Press Import.

• 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

Related Articles

• How to Convert Text File to Excel Automatically
• VBA Code to Convert Text File to Excel

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