Question: how to import data into excel from pi?
Answer: Go to the Data tab and click Get External Data > From Other Sources > From Data Connection Wizard. ... 
In the Data Connection Wizard dialog, select the Other/advanced item and click Next. ... 
Configure a Universal Data Link (UDL) to a PI Server. ... 
Select the database that contains the data you want.