Green version "software, extract the name of the folder into the txt file, and then import the txt file into excel.

The steps are as follows:

1. First, open excel, select the data tab, and then select the self-text option.

2. Select the saved txt file in the pop-up Explorer interface, and click the Open button.

3. The text import wizard will pop up. Because my numbers are separated by spaces, I choose separators. Of course, if your text is of a fixed width, you can choose the second one. Then click the Next button.

4. Check the blank space to see if the preview data is consistent with your expectations. Continue to click the Next button after you agree.

5. Check the preview effect. There is no special requirement for choosing column data format, so it is recommended to choose regular format, which is also the default format of excel. Click finish.

6. In the pop-up dialog box, select the data area to import. Here I want to import into the current cell, starting with cell a 1, so I choose cell a 1, and the extra data will automatically open to both sides with this cell. Click the OK button.

Our data is imported perfectly.