Question: how to import data into excel from an external source?
Answer: Step 1 − Click the DATA tab on the Ribbon. Step 2 − Click Existing Connections in the Get External Data group. The Existing Connections dialog box appears. Step 3 − Select the connection from where you want to import data and click Open.