Click Finish, and a new sheet of a new workbook has been created with the texts. Click Open, and in the Text Import Wizard dialog, check Delimited option and click Next to check a delimiter you use to split the text and go on clicking Next to specify the format you use. Then in the Open dialog, select Text Files in the drop-down list next to the File name, and select the text file you use. To convert a text file to a sheet, you can use the Open utility in Excel.ġ. Import a text file to a sheet with or without delimiter
Have you ever tried to convert a text file to an Excel file with delimiters? In this article, I am going to talk about the methods of solving this problem.Ĭonvert text file to sheet with delimiter by Open How to quickly convert a text file to excel file with delimiter?
