Ways to import txt Notepad in Excel tables

Ways to import txt Notepad in Excel tables

Such data can be very cumbersome when modifying or updating data in Notepad. You can use Excel to import external data features to turn Notepad files into Excel data.

First create a new Excel document, and follow the steps in the following diagram.

In the Text Import Wizard that pops up, click Next, and in the second step, set the following figure:

In the third step, click the column label of the column that contains the ID number and click on the text format.

Similarly, if there is a bank card number of such a longer data, but also to be formatted as text, otherwise 15-digit after will become 0.

Click the Finish button, in the Import Data dialog box, click Properties, and then check refresh data when opening a file so that if the data in Notepad changes, the latest results are updated in Excel.

OK, let's see the result: