How to import a text file or worksheet in Excel?
Occasionally, you might find yourself needing to import data into your current Excel worksheet from a text file or another worksheet. While importing data from a text file is relatively straightforward, integrating an entire worksheet into your current worksheet can be more complex. This guide will provide you with step-by-step instructions on how to efficiently handle both scenarios, ensuring seamless data integration into your Excel environment.
Import a text file in the worksheet with Text Import Wizard
Import contents of a text file or worksheet into the current worksheet
Import a text file in the worksheet with Text Import Wizard
You can import the data of a text file into the current worksheet beginning at a specific cell with Text Import Wizard as the following steps:
1. Activate the worksheet you want to import data to, click the Data tab, and choose the From Text button on the Get External Data group.
2. Choose the text file you want to import from the Import Text File window, and then click Import.
3. A Text Import Wizard dialog box will be displayed. See screenshot:
4. Then click the Next button, and you can set the delimiters your data contains. Also, you can preview the result in the Data preview box. See screenshot:
5. Go ahead and click the Next button, the Text Import Wizard allows you to specify data format for each column and other advanced settings. Click Finish.
6. It will display a window asking where you want to put the data into the current worksheet or a new worksheet. Here you can see I choose A2. Click OK.
Your text data will now be input into the current Excel worksheet. See screenshot:
With so many steps, we finally finished it. If you want to import data from a worksheet, you need to save the worksheet as a text file first or use a VBA to get it done. Is there an easier and more multifunctional tool to solve this problem? Please read the following method.
Import contents of a text file or worksheet into the current worksheet
With Kutools for Excel, we can not only import text, PRN, or CSV files but also Excel files into an Excel worksheet beginning at a specific cell.
1. After installing Kutools for Excel, click Kutools Plus > Import/Export > Insert File at Cursor, see screenshot:
2. Then in the Insert File at Cursor dialog box, do the following options:
(1.) Click the button to specify a cell you want to import data beginning at.
(2.) Then click the Browse button to choose the file that you want to import, see screenshot:
3. And then click OK, if there are multiple worksheets in your workbook file, a prompt box will pop out to remind you to select a worksheet you want to import, see screenshot:
4. Click OK, and the data in the selected worksheet has been imported into the current worksheet.
- This function supports these file formats: Text files, Excel files, PRN files, and CSV files.
- If you don’t want to keep the data formatting, please check the Do not transfer formatting option. If you check the Values only option, the formulas are imported into the sheet as values.
- For more detailed information about Insert File at Cursor, please visit the Insert File at Cursor feature description.
- Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Get Kutools for Excel Now!
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
![Screen Shot of Excel (with Office Tab installed)](http://cdn.extendoffice.com/images/stories/kte-module/officetab-bottom-02.gif)