Question: how to import data to excel online?
Answer: On the Data tab, click Existing Connections. ... 
In the Show drop-down list, do one of the following: ... 
Select the connection that you want, and then click Open.
In the Import Data dialog box, under Select how you want to view this data in your workbook do one of the following: ... 
Under Where do you want to put the data?,