Select the ' Finish' button, and you will be taken to your file converted to Excel.For any columns you would like to keep the data exactly as shown, such as keeping all leading and trailing 0s in account numbers, select ' Text' as the ' Column data format'. The default is ' General', which will allow Excel to guess the format and convert it to the corresponding type. This step lets you specify the data type for each column, as well as indicate if a column should not be imported (' Do not import column (Skip)').Select ' Next' to proceed to step 3 of 3.For a preview of how your data will be separated refer to the ' Data preview' section in the bottom portion of the Import Wizard. For files delimited by a character not listed, type the character in the ' Other:' option.

Select the character used as the delimiter, for example, Tab for tab-delimited files.

Select ' Next' to proceed to step 2 of 3.

Leave the radio button for the ' Original data type' as ' Delimited'.

If your file has a header row, check the radio button ' My data has headers', otherwise leave the button unselected.You will be taken to the Text Import Wizard.For Excel to detect text files, you will need to change the file type detection outlined in red in the screenshot below to either ' All Files' or ' Text Files'. Navigate to the directory where your text filed is saved at select the text file file you want to convert, then ' Open' the file.Select ' Open' in the side menu, followed by the ' Browse' option.Open a new instance of Microsoft Excel.Steps to convert a character delimited text files to an Excel workbook Learn how to convert a character delimited text file into.

Convert delimited text file to excel