WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to import text file in excel

August 1, 2022
6.1K Views

Excel is a spreadsheet program that allows you to create, edit and view spreadsheets. It allows you to import a text file into the spreadsheet. This can be done for a variety of reasons. For example, if you want to create a list of all the words that appear in a certain document, or if you want to add numbers and dates to cells based on some criteria, you'll need to import the text file into Excel first. And doing it is quite easy. You might need to import text file in Excel if you want to edit the file. For example, if you have a text file with information about your company's employees and you want to change the names of some of them, then you can use this feature to quickly update your spreadsheet.

How to import text file in excel using copy and paste?

Importing and exporting data is a basic part of any spreadsheet. Whether you're moving data between different spreadsheets or importing it from a text file, the process is similar. When you want to import a text file into an Excel spreadsheet, you can use the copy-and-paste feature of Excel.

This method works best with versions 2016/2016/mac/online.

If you're looking to add data a text file into an Excel spreadsheet, there are a few different ways to do it. One of the most straightforward methods is to copy the file using Ctrl+C to copy it. You can then select a blank cell in your spreadsheet and use Ctrl+V to paste the copied file into that cell.

How to import text file in excel by opening it in Excel?

Importing a text file into Excel is not a difficult task, but it can be very time consuming if you don't know how to do it. This section  will explain the steps required to import a text file into Excel by opening it in Excel.

This method works best with versions 2016/2016/mac/online.

1. To open a text file, go to File > Open and browse to the location that contains the text file you want to open.

2. Once you've located your text file, select Text Files in the file type dropdown list in the Open dialog box.

How to import text file in excel using Import data option?

The Import Data option allows you to import text file in Excel spreadsheet and even automatically create a new worksheet for the imported data.

This method works best with versions 2016/2016/mac/online.

1. Click on ‘Data’ in the Main Menu. Press the right arrow for more options if the ‘Import Data’ option is not visible.

2. Click on ‘Select Data Source’ on the pop-upbox.

3. Now locate your text file and click open.

4. Now in the File Conversion menu, check Windows (default) under Text encoding section and click Next.

5. In the Text Import Wizard, click Finish and the text file will be imported in excel.

Did you learn about how to import text file in excel? Do you now know how to use IF, AND, OR functions in excel with text? 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 word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.