How to convert text into table

Method: First click "File" - "Open" in the top navigation bar to import the text file; then check "Delimiter" in the "Text Import Wizard" and click the delimiter used; finally Select the appropriate data format for each column and click "Finish".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Converting text files into table files can combine the advantages of both, so we often use it. Before converting a text file into a table file, you must first format the text file, that is, use commas, semicolons, spaces, or the Tab key to separate the content that needs to be turned into cell data. In fact, formatting text means turning text into a file recognized by Excel.

After formatting the file, click "File - Open" in the excel worksheet.

In the file selection window, find the text file you want to import and click it, then click "Open".

In the window that opens, check "Delimiter" and click "Next".

Check the delimiter we use in the newly opened window, and then click "Next".

In the new pop-up window, select "Column Data Format", then preview the column, and finally click "Finish".

Related learning recommendations: excel tutorial

The above is the detailed content of How to convert text into table. For more information, please follow other related articles on the PHP Chinese website!