How to Import Text File to Excel Automatically (2 Suitable Ways)

While working with large Microsoft Excel, sometimes we need to import text files to Excel. Importing text files to Excel automatically is an easy task. This is a time-saving task also. Today, in this article, we’ll learn two quick and suitable ways to import text file to Excel automatically with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Suitable Ways to Import Text File to Excel Automatically

Let’s assume we have an Excel large worksheet that contains the information about several students of Armani School. We will import text files to Excel automatically. To do that, we will apply the From Text/CSV command, and File option. This is an easy task and time-saving also. Here’s an overview of the dataset for today’s task.

import text file to excel automatically


1. Use From Text/CSV Command to Import Text File to Excel Automatically

Undoubtedly, importing text files to Excel automatically is an easy task. To import a text file, we will use the From Text/CSV command in Excel. To do that, first, you have to create a text file. After that, follow the instructions below to import text files!

Step 1:

  • First of all, select a cell where we want to import a text file. For the convenience of our work, we select cell B15. Hence, from your Data tab, go to,

Data → Get & Transform Data → From Text/CSV

Use From Text/CSV Command to Import Text File to Excel Automatically

  • After that, a text file named Grade Sheet will appear in front of you. Hence, press the Import option.

Step 2:

  • As a result, a window named Grade Sheet.txt pops up. From that window, go to,

Load → Load To

Use From Text/CSV Command to Import Text File to Excel Automatically

  • After pressing the Load To option, an Import Data window will appear in front of you. From that window, firstly, select the Existing worksheet: option under the Where do you want to put the data? At last, press OK.

  • After completing the above process, you will be able to import data from text files which have been given in the below screenshot.

import text file to excel automatically

Read More: How to Import Text File to Excel Using VBA (3 Easy Ways)


Similar Articles


2. Utilize File Tab to Import Text File to Excel Automatically

We can also import data from the text file by using the File tab. This is an easy and time-saving task also. Let’s follow the instructions below to import data from text files in Excel!

Step 1:

  • First of all, select the File option.

Apply File Tab to Import Text File to Excel Automatically

  • After selecting the File tab, go to,

Open → Browse

  • Hence, an Open window will appear in front of you. From that window, firstly, select the All Files Secondly, select a text file named Grade Sheet. At last, press the Open option.

Apply File Tab to Import Text File to Excel Automatically

Step 2:

  • As a result, a window named Text Import Wizard – Step 1 of 3 will appear in front of you. From that window, firstly, select the Delimited option under the Original data type Secondly, check the My data has headers option. Thirdly, press the Next option.

Apply File Tab to Import Text File to Excel Automatically

  • Hence, a new window named Text Import Wizard – Step 2 of 3 pops up. From that window, press the Next option.

  • After that, again, the Text Import Wizard – Step 3 of 3 window pops up. From that window, select the Finish option.

Apply File Tab to Import Text File to Excel Automatically

  • After completing the above process, you will be able to import data from text files which have been given in the below screenshot.

Apply File Tab to Import Text File to Excel Automatically

Read More: How to Open CSV File in Excel with Columns Automatically (3 Methods)


Things to Remember

➜ While a value can not found in the referenced cell, the #N/A error happens in Excel.

➜ If you want to copy data in Excel, simply press Ctrl + C on your keyboard, and to paste the copied data, press Ctrl + V. You can also open a text file using the keyboard shortcut Ctrl + O.

➜ Legacy Wizard is available in Excel 2016 or later version.


Conclusion

I hope all of the suitable methods mentioned above to import text files to Excel automatically will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo