Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to import a text file or worksheet in Excel?

Sometimes, we may need to import data into current worksheet from a text file or worksheet. For importing text file in Excel, it’s quite easy. But to import a worksheet into current worksheet, it’s a little bit sophisticated.

Import a text file in worksheet with Text Import Wizard

Import contents of a text file or worksheet into current worksheet



arrow blue right bubble Import a text file in worksheet with Text Import Wizard

You can import the data of a text file into 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 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:

doc-import-text 1

4. Then click Next button, you can set the delimiters your data contains. Also, you can preview the result in the Data preview box. See screenshot:

doc-import-text 2

5. Go ahead and click Next button, the Text Import Wizard allows you to specify data format for each column and other advanced settings. Click Finish.

doc-import-text 3

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.

doc-import-text 4

Your text data will now be input into the current Excel worksheet. See screenshot:

doc-import-text 5

With so many steps, we finally finish it. If you want to import data from a worksheet, you need to save the worksheet as text file first or using a VBA to get it done. Is there an easier and more multifunctional tool to solve this problem?


arrow blue right bubble Import contents of a text file or worksheet into current worksheet

With Kutools for excel, we can not only import txt, PRN or CSV files but also Excel files into an excel worksheet beginning at a specific cell.

Kutools for excel: with more than 100 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

1. After installing Kutools for excel, click Enterprise > Import/Export > Insert File at Cursor…, see screenshot:

doc-import-text-6

2. Then in the Insert File at Cursor dialog box, do the following options:

(1.) Click the doc-button1 button to specify a cell you want to import data beginning at.

(2.) Then click Browse button to choose the file that you want to import, see screenshot:

doc-import-text-7

3. And then click OK, if there are multiple worksheets in your workbook file, a prompt box will pop out to remind you selecting a worksheet you want to import, see screenshot:

doc-import-text-8

4. And click OK, and the data in the selected worksheet has been imported into the current worksheet.

doc-import-text-9

Notes:

1. This function supports these file formats: Text files, Excel files, PRN files and CSV files.

2. If you don’t want to keep the data formatting, please check Do not transfer formatting option. And 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 Insert File at Cursor feature description.



Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 300 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.