How To Import Financial Statements Into Excel. Using excel the latest version of excel, you must turn on smart tags by clicking on the microsoft office. About press copyright contact us creators advertise developers terms privacy policy & safety how youtube works test new features press copyright contact us creators.
Now select the “data” tab, click on “get data from text/csv,” and select the file you have downloaded from yahoo finance. I am generatingthe financial statement using the t.code s_alr_87012284, then i am selecting all required fields and coming to out put list ,i am selecting third option like alv tree control. Get financial data for multiple companies in excel, straight from the web.