How to import external data in excel

How to import external data in excel: first create a blank excel worksheet; then click on a functional data in the upper right corner; then click on a button in the upper left corner to import external data; finally select the import method , and find the file that needs to be imported, and then confirm the import.

The operating environment of this article: Windows7 system, Microsoft Office Excel2016, Dell G3 computer.

Create a blank excel worksheet.

After creating a new one, we click on a function data in the upper right corner,

After selecting, we Click the Import from external data button in the upper left corner.

After clicking, the following prompt pops up. Let’s choose the import method.

Find the file that needs to be imported. For example, what needs to be imported is in text format.

Select the file and import it.

[Recommended: Excel Tutorial]

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!