How to Import Yahoo Finance Financial Statements to Excel

By Charlotte Mission

Yahoo Finance provides up-to-date financial information for many companies that helps business owners keep track of how other companies in their industry are performing as well as providing important information about investments. You can use Microsoft Excel's "Web Query" tool to import these financial statements to your computer so you have them on hand.

Go to the Yahoo Finance page of the company for which you want the financial statement.

Triple-click the Web address in the address bar at the top of the window. Right-click it and select "Copy" from the menu.

Open Excel and click the "Data" tab.

Click the "From Web" icon in the "Get External Data" section.

Paste the Web address in the "Address" text box and click "Go."

Click the yellow arrow next to the parts of the page you want to import to Excel. This allows you to avoid importing ads, graphics or information you don't need.

Click "Import." Excel will populate the document with the financial statement data.

Click the "File" tab and select "Save" from the menu. Name the document and click the "Save" button.


Information in this article applies to Microsoft Excel 2010. It may vary slightly or significantly with other versions or products.