How to convert a text file to an Excel file

Office Excel2003 conversion method:

1. Open excel2003 first, and click "import data" in "import external data" from the "data" drop-down menu, as shown in the figure;

2. Select the txt file to be converted into an excel file and click "open;

3. Then, select the "separator" in the pop-up window and click "next;

4. Input other parameters, and click next;

5. In step 3, click "finish;

6. At last, = $ A $1 indicates starting from the first cell. If you modify it, click the icon next to it to set other positions for filling, and then click OK;

7. After the import is successful, the data has been separated based on the set separator;

Office Excel 2007 conversion method:

1. Click "data"-"self-text" in excel2007, as shown in the figure below.

2. Select "import data from text" and click "Select File". Other operations are the same as those in excel2003.