Conversion method: 1. Create a new excel document and open it; 2. Click "Data" - "From Text"; 3. In the pop-up window, select the txt file that needs to be converted and click "Import"; 4. . In the pop-up window, check the "Delimiter" item and click "Next"; 5. In the delimiter, check the options as needed and click "Next" - "Finish".
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.
There is a txt text document with the following data.
How to convert this txt document into an excel table? Let me introduce the method below.
How to convert a txt document into an excel table
Create a new excel table document on the desktop, right-click on the desktop and select [New--Worksheet].
Double-click to open the Excel table and click [Data--From Text].
In the pop-up window, select the converted txt file and click [Import].
In the text import wizard window, select [Delimiter--Next], in Delimiter, check the option, and click [Next-- Complete] to complete the operation.
The summary is as follows:
①Open the txt text document and check whether the data is correct, Right-click on the desktop and select [New - Worksheet].
②Open the worksheet, click [Data--From Text], select the file, and click [Import].
③In the text import wizard window, select [Delimiter--Next], check the option, and click [Next--Finish].
Related learning recommendations:excel tutorial
The above is the detailed content of How to convert txt document into excel table. For more information, please follow other related articles on the PHP Chinese website!
