How to import external data in excel?

During the process of editing Excel, if you need to copy the full text of data in other files into the Excel file, what should you do? The following article will explain to you a specific method of importing external data. I hope it will be helpful to you.

#Excel can import many types of data, the most common one is Access data, but today I will give you an example of how to import a document file.

Specific steps:

1. First open a blank table of an Excel file. As shown below.

#2. In the menu, you can find the "Data" item. Click on it and we will see a horizontal list item about "Data". As shown below.

In the picture, we can see the options for external data. Access type data is the most common, so it is placed first.

#3. Because the external file that needs to be imported is a text file, just select "Self Text".

#4. Find the file to be imported in the dialog box and click "Import".

#5. The "Text Import Wizard" window will pop up to set options. There are not many key settings among them. We need to pay attention to the starting row setting, column width, and finally click Finish to complete the import of external data.

We left-click "Separator"-"Next"-"Tab key"-"Next"-"General"-"Complete"-"Existing Tool Sheet"-"OK".

#6. In this way, the content of the text document is successfully imported into the table.

For more excel-related technical knowledge, please visit the excel usage tutorial column to learn!

The above is the detailed content of How to import external data in excel?. For more information, please follow other related articles on the PHP Chinese website!