Note: The other languages of the website are Google-translated. Back to English

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:

shot insert file at cursor 1 doc arrow right

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

Kutools for Excel: with more than 300 handy Excel utilities, free to try with no limitation in 30 days. Download and free trial 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 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (2)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
This is a great utility but could be improved. Most CSV or other files contain header rows that do not need to be imported. Adding an option to not import the first row of data would be an improvement.
This comment was minimized by the moderator on the site
Hi, Troy,

Thanks for your comment, your suggestion has been fed back to the developers, if there's an upgrade, I'll let you know in the first time. 😄
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations