Skip to main content

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

Author: Xiaoyang Last Modified: 2024-12-12

Kutools for Excel

Boosts Excel With 300+
Powerful Features

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:

shot insert file at cursor 1 doc arrow right shot insert file at cursor 2

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:

shot insert file at cursor 3

1: Click this shot-Browse-button button to select a cell where to start inserting data.

2: Click this shot-insert-file-at-cursor-button 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 shot-insert-file-at-cursor-button 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:
shot the Select a file to be inserted at the cell cursor position dialog
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:
shot the Select a Worksheet dialog

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

shot result


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:

shot-insert-file-at-cursor-8

1: You can click this shot-Browse-button button to select a cell where to start inserting data.

2: Click this shot-insert-file-at-cursor-button 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:

shot the Select a file to be inserted at the cell cursor position dialog

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

shot-insert-file-at-cursor-7

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


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

 
Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase