Quickly import or insert data from another worksheet or text files in Excel

When you operate a worksheet, you may need to import or insert data from a certain type of files (CSV, other worksheet, Text or PRN) in a specific location of worksheet. Kutools for Excel’s Insert file at cursor utility can quickly import data to begin in a cell (the cursor position) in worksheet. With this utility, you can quickly:

Import or insert data from another worksheet
Import or insert data from text file (CSV, TXT or PRN)

Click Kutools Plus > Import & Export > Insert File at Cursor. See screenshots:

Import or insert data from another worksheet

Supposing you have to import or insert data from another worksheet in the cursor position (to start inserting the data from a cell) of the active worksheet in Excel, you can do it easily as following steps:

1. Put your cursor in a cell where you want to start inserting or importing the data from another worksheet, and then apply the utility by clicking Kutools Plus > Import & Export > Insert File at Cursor. In the Insert File at Cursor dialog box, make the below settings:

1: Click this  button to select a cell where to start inserting data. 2: Click this  button to specify the file you like to import to the worksheet. 3: Choose the options below according to your needs: Value only (no formulas): Only the value will be imported, and the formulas won't be imported. Do not transfer formatting: It will import the data into the worksheet without formatting. 4: Click the Ok button.

Tips:

1) After clicking the  button, a Select a file to be inserted at the cell cursor position dialog will pop up, please select the workbook which contains the workhseet you want to import and then click the Open button. See screenshot:

2) If the selected workbook contains multiple worksheets, a Select a Worksheet dialog box will pop up for you to select a worksheet. You need to select the worksheet and click the OK button to start inserting data. See screenshot:

Then data in the selected worksheet will be inserted to the worksheet starting with a specific cell:

Import or insert data from text file (CSV, TXT or PRN)

Supposing you have to import or insert data from text files (such as CSV file, text file or PRN file) in the cursor position (to start insert the data from a cell) of the active worksheet in Excel, you can do it easily as following steps:

1. Put your cursor in a cell where you want to start inserting or importing the data from text file, and then apply the utility by clicking Kutools Plus > Import & Export > Insert File at Cursor. In the Insert File at Cursor dialog box, and then do as follows:

1: You can click this  button to select a cell where to start inserting data. 2: Click this  button to specify the file you like to import to the worksheet. 3: Choose the options below according to your needs: Value only (no formulas): Only the value will be imported, and the formulas won't be imported. Do not transfer formatting: It will import the data into the worksheet without formatting. 4: Click the Ok button.

 Tips: If you want to import data from an CSV file, please specify CSV Files in the file type drop-down list. See screenshot:

Then data in selected CSV, TXT or PRN file will be inserted to the worksheet starting with a specific cell. See screenshot:

Notes: This function supports undo (Ctrl +Z).

Demo: Quickly import or insert data from another worksheet or text files in Excel