Import Data from Another Worksheet or Text Files in Excel Office 365!!
Tags: importdatafromanothe, kutoolsexceltutorial, kutools
Published: 2020-11-19 09:58:41

---
title: Import Data from Another Worksheet or Text Files in Excel Office 365!!
published: true
date: 2020-11-19 05:20:21 UTC
tags: ImportDatafromAnothe,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/import-data-from-another-worksheet-or-text-files-in-excel-office-365/
---

In this article, we are going to see how to **Import Data from Another Worksheet or Text Files in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Import Data from Another Worksheet:

To import or insert data from another worksheet in the cursor position of the active worksheet, do as below steps.

- You need to **place the cursor in a cell where you want to start inserting data** from another [sheet](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/).

![Place the cursor](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Place-the-cursor.png)<figcaption id="caption-attachment-17606">Place the cursor</figcaption>

- Then, go to the **Kutools Plus Tab, select** the **Import & Export** option, **choose** the **Insert File at Cursor** option from the menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Plus-Tab-1.png)<figcaption id="caption-attachment-17607">Kutools Plus Tab</figcaption>

- It will display the **Insert File at Cursor Dialog Box**.
- Then, **click** the **browse button** to select the cell where you want to insert data**(1)**.
- You need to **click** the **browse button** to select the Excel file that contains the worksheet you want to insert**(2)**.
- **Value only (no formulas) –** This option will help you to import the values only**(3)**.
- **Do not transfer formatting –** It will import the data into the worksheet without formatting.

![Insert File at Cursor Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Dialog-Box.png)<figcaption id="caption-attachment-17608">Insert File at Cursor Dialog Box</figcaption>

- Then, in the **Select a file to be inserted at the cell cursor position Dialog Box** , You need to **select** the **workbook** that contains the worksheet you want to import.

![Select the file](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-file.png)<figcaption id="caption-attachment-17609">Select the file</figcaption>

- After selecting the file, you can return the **Insert File at Cursor Dialog Box ** and **click** the **OK** button**(4)**.
- If the selected workbook contains multiple worksheets, it will open the **Select a Worksheet** dialog box where you need to **select** the **worksheet.**

![Select a Worksheet Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-a-Worksheet-Dialog-Box.png)<figcaption id="caption-attachment-17613">Select a Worksheet Dialog Box</figcaption>

- Then, **hit** the **OK** button. It will insert the selected worksheet as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-11.png)<figcaption id="caption-attachment-17563">Output</figcaption>

## Import Data from Text File (CSV, Text, or PRN):

You can also import data from text files such as CSV files, Text, or PRN Files in the cursor position of the current worksheet. To do this, do as follows.

- You need to **put your cursor in the cell** where you want to start inserting data from text files.

![Place the cursor](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Place-the-cursor.png)<figcaption id="caption-attachment-17606">Place the cursor</figcaption>

- On the **Kutools Plus**  **Tab** , **select** the **Import**  **& Export** option, then **choose** the **Insert File at Cursor** option from the menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Plus-Tab-1.png)<figcaption id="caption-attachment-17607">Kutools Plus Tab</figcaption>

- It will display the **Insert File at Cursor Dialog Box**.
- Then, **click** the **browse button** to select the cell where you want to insert data**(1)**.
- You need to **click** the **browse button** to select the Excel file that contains the worksheet you want to insert**(2)**.
- **Value only (no formulas) –** This option will help you to import the values only.
- **Do not transfer formatting –** It will import the data into the worksheet without formatting.

![Insert File at Cursor Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-29.png)<figcaption id="caption-attachment-17616">Insert File at Cursor Dialog Box</figcaption>

- Then, in the **Select a file to be inserted at the cell cursor position Dialog Box** , You need to **select** the **text file** that you want to import.

![Select the text file](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-text-file.png)<figcaption id="caption-attachment-17615">Select the text file</figcaption>

- After selecting the file, you can return the **Insert File at Cursor Dialog Box ** and **click** the **OK** button**(3)**.
- Finally, it will import the selected text file as shown in the below figure.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-28.png)<figcaption id="caption-attachment-17617">Result</figcaption>

## Verdict:

In the above article, you can easily understand the steps to **Import Data from Another Worksheet or Text Files in Excel Office 365** using **Kutools. ** Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Related Articles:

- [How to Freeze Panes Across Multiple Worksheets in Excel Office 365?](https://geekexcel.com/how-to-freeze-panes-across-multiple-worksheets-in-excel-office-365/)
- [Quickly Print First Page of Each Worksheet in Excel Office 365!!](https://geekexcel.com/quickly-print-first-page-of-each-worksheet-in-excel-office-365/)