Question: how to import data to excel from yahoo finance?
Answer: Open the Yahoo! ...  Copy the link to the financial statement. ...  Open a new Excel document. Click "Data," then "Import External Data." Then select "New Web Query." Paste the link in the Address box.