Quick Tip: How to import text in Excel

August 1, 2022

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

Excel plays a vital role in any financial model and it provides easy ways to work under a lot of functions and programs. This updated excel comes up with much more interesting function and built-in formulas through which mankind save time up to 50% and increase the speed of productivity along with their learning skills. These programs are very easy to use.

There are many ways by which we can easily import text in Excel.

Firstly, we find how to import text in excel through these steps.

1) Open up the excel sheet and click on the open option which shows on the top of the spreadsheet.

2) When we press on the Menu option more options will open and select the open like this.

3) The third step is to open and 1 dialog box will appear in which you require to open the file but it shows only excel form of files so to open and convert text file you find fil type option which shows in the dialog when you click on it you find many options that in which method you want to open your file click on the top all type files so the text will appear and open it your file will convert to excel form and opened it in a spreadsheet.

So by all these steps, you can easily find how to import text to excel.

Convert text files to excel in.

As we know there are multiple steps to import text to excel, now we do this with the other method and to do this function we require some steps and those are below.

1) The first step here is to copy the text from a text file and go to the excel sheet.

2) The second step is to click on the data option which appears on the top of the spreadsheet like this.

3) The third step is to click on the text to the column which appears under the data option, and when you press it a dialog box will pop in which a few options will ask regarding copy text to the column. Mark on the delimited option in the dialog box and after that press Next.

4) The fourth and final step is to click on next again by which your text file will copy in a column like this.

Congratulations, by all these steps you again import text into excel form respectively.

How to import text to excel by another method.

This is also a way by which we can easily import text to excel easily, to perform this function we gain need to follow some steps which are given below.

1) Make text file in note pad which you want to import in excel.

2) The second step to go in excel and click on the Data ribbon which shown on the top of exce, after clicking it further more options will pop up below and then click on import data like that.

3) After that click on import data a dialog box will open and then click on next which show below of dialog box, after that a new window will open which would like to select the text file, after selection of text file click on open.

4) The last step is that after click open a new window will open in which selected text of textfile will be shown, after that again click next, next and finish. Your text will automatically import in excel sheet.

Congratulations, you import text to excel easily.

Did you learn about how to import text in Excel Spreadsheets? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit the documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience

You can also find this feature in the latest excel versions 2016/2018/2019 spreadsheet, where you can easily find how to import text to Excel.