How does Excel convert text into tables?

Double-click to open a new Excel form, click the data in the menu bar, click its own text in the function area of obtaining external data, or select an existing connection, click Browse More, select a text document with data, click Import, select a separator, and click Next;

Select the check box in front of the Tab key, select Next, click General, and then select Finish. In the imported data that pops up, click the existing worksheet and select OK to convert the text document into an Excel table.